[Home] [Help]
382: BEGIN
383: SELECT MAX(pan.date_from)
384: INTO l_effective_date
385: FROM per_person_analyses pan,
386: fnd_id_flex_structures flx
387: WHERE pan.id_flex_num = flx.id_flex_num
388: AND flx.id_flex_code = 'PEA'
389: AND flx.application_id = 800
390: AND flx.id_flex_structure_code = 'US_FED_PERF_APPRAISAL'