DBA Data[Home] [Help]

APPS.PER_SUC_BUS dependencies on PER_PERSON_TYPES

Line 114: per_person_types ppt

110: cursor c1 is
111: SELECT NULL
112: FROM per_people_f ppf,
113: per_person_type_usages_f ptu,
114: per_person_types ppt
115: WHERE ppf.person_id = p_person_id
116: AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date AND ppf.effective_end_date
117: AND ppf.person_id = ptu.person_id
118: AND TRUNC (SYSDATE) BETWEEN ptu.effective_start_date AND ptu.effective_end_date