APPS.GHR_EHRI_DYNRPT dependencies on PER_PERSON_ANALYSES

Line 385: FROM per_person_analyses pan,

381: l_effective_date DATE;
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