APPS.GHR_EHRI_DYNRPT dependencies on PER_PERSON_ANALYSES

Line 387: FROM per_person_analyses pan,

383: l_effective_date DATE;
384: BEGIN
385: SELECT MAX(pan.date_from)
386: INTO l_effective_date
387: FROM per_person_analyses pan,
388: fnd_id_flex_structures flx
389: WHERE pan.id_flex_num = flx.id_flex_num
390: AND flx.id_flex_code = 'PEA'
391: AND flx.application_id = 800