APPS.GHR_RIF_PKG dependencies on PER_PERSON_ANALYSES

Line 29: per_person_analyses pan

25: select pea.segment2 segment2,
26: pea.segment3 segment3,
27: pan.date_from date_from
28: from per_analysis_criteria pea,
29: per_person_analyses pan
30: where pan.person_id = p_person_id
31: and decode(pan.id_flex_num,l_id_flex_num,1,2) = 1
32: and pea.analysis_criteria_id = pan.analysis_criteria_id
33: and add_months(p_effective_date,-48) < ghr_general.return_rif_date(pea.segment3)