DBA Data[Home] [Help]

APPS.PER_SUC_BUS dependencies on PER_PERSON_TYPE_USAGES_F

Line 113: per_person_type_usages_f ptu,

109: --
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