OTL table value set -Trying to reference the person id for the current user in the WHERE clause
DDL of HXC_CUI_CUSTOM3_V view
-- new definition of view controlling cost center timesheet lov
CREATE OR REPLACE FORCE VIEW "APPS"."HXC_CUI_CUSTOM3_V" ("DISPLAY_VALUE", "VALUE", "EFFECTIVE_START_DATE", "EFFECTIVE_END_DATE", "DIVISION_ID", "PERSON_ID") AS
select scc.cost_center_code||'-'||scc.description "DisplayValue", scc.cost_center_id as "Value" , scc.effective_start_date, scc.effective_end_date, scc.division_id, papf.person_id
from per_all_people_f papf, per_all_assignments_f paaf, hr_all_organization_units haou, PER_ASSIGNMENT_EXTRA_INFO paei, sjr_cost_centers scc, hr_lookups lkp
where papf.person_id = paaf.person_id