APPS.PER_SUC_BUS dependencies on PER_PERSON_TYPE_USAGES_F

Line 130: FROM per_people_f ppf, per_person_type_usages_f ptu, per_person_types ppt

126: --
127: CURSOR c1
128: IS
129: SELECT NULL
130: FROM per_people_f ppf, per_person_type_usages_f ptu, per_person_types ppt
131: WHERE ppf.person_id = p_person_id
132: AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date AND ppf.effective_end_date
133: AND ppf.person_id = ptu.person_id
134: AND TRUNC (SYSDATE) BETWEEN ptu.effective_start_date AND ptu.effective_end_date