APPS.HRI_OPL_REC_CAND_PIPLN dependencies on PER_PERSON_TYPES
Line 1991: ,per_person_types ppt
1987: SELECT
1988: ppt.system_person_type
1989: FROM
1990: per_person_type_usages_f ptu 1991: ,per_person_types ppt 1992: WHERE ptu.person_id = v_person_id
1993: AND v_effective_date BETWEEN ptu.effective_start_date
1994: AND ptu.effective_end_date
1995: AND ptu.person_type_id = ppt.person_type_id