eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PL_PERSON_EXTRA_INFO dependencies on PER_PEOPLE_F

Line 14: per_people_f pap,per_person_types ppf,per_person_type_usages_f ptu

10:
11:
12: cursor csr_chk_contact is
13: select 1 from
14: per_people_f pap,per_person_types ppf,per_person_type_usages_f ptu
15: where pap.person_id = P_PERSON_ID and
16: pap.person_id = ptu.person_id and
17: ppf.person_type_id = ptu.person_type_id and
18: ppf.SEEDED_PERSON_TYPE_KEY = 'CONTACT' and

Line 137: per_people_f pap,per_person_types ppf,per_person_type_usages_f ptu

133: -- This cursor checks if the Updated Dates are within the Start/End Dates of the 'Contact'
134:
135: cursor csr_chk_contact_date is
136: select 1 from
137: per_people_f pap,per_person_types ppf,per_person_type_usages_f ptu
138: where pap.person_id in (select person_id from per_people_extra_info where person_extra_info_id = P_PERSON_EXTRA_INFO_ID) and
139: pap.person_id = ptu.person_id and
140: ppf.person_type_id = ptu.person_type_id and
141: ppf.SEEDED_PERSON_TYPE_KEY = 'CONTACT' and