DBA Data[Home] [Help]

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