DBA Data[Home] [Help]

APPS.GHR_CPDF_DYNRPT dependencies on PER_PERSON_ANALYSES

Line 349: FROM per_person_analyses pan,

345: l_effective_date DATE;
346: BEGIN
347: SELECT MAX(pan.date_from)
348: INTO l_effective_date
349: FROM per_person_analyses pan,
350: fnd_id_flex_structures flx
351: WHERE pan.id_flex_num = flx.id_flex_num
352: AND flx.id_flex_code = 'PEA'
353: AND flx.application_id = 800