DBA Data[Home] [Help]

APPS.HXC_FIND_NOTIFY_APRS_PKG dependencies on PER_PERSON_TYPES

Line 2000: per_person_types ppt,

1996:
1997: cursor csr_validate_person(b_person_id number, b_effective_date date) is
1998: SELECT 1
1999: FROM per_all_people_f per,
2000: per_person_types ppt,
2001: per_person_type_usages_f pptu
2002: WHERE per.person_id = b_person_id
2003: AND TRUNC(b_effective_date) between TRUNC(per.effective_Start_date) and TRUNC(per.effective_end_date)
2004: AND TRUNC(b_effective_date) between TRUNC(pptu.effective_Start_date) and TRUNC(pptu.effective_end_date)