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.IRC_PURGE_OLD_DATA_PKG dependencies on PER_PERSON_TYPE_USAGES_F

Line 785: ,per_person_type_usages_f ptu

781: function is_free_to_purge(p_party_id number,p_effective_date date) return string is
782: cursor c1 (p_party_id number,p_effective_date date) is
783: select 1
784: from per_all_people_f per1
785: ,per_person_type_usages_f ptu
786: ,per_person_types ppt
787: where per1.party_id = p_party_id
788: and per1.person_id = ptu.person_id
789: and p_effective_date between per1.effective_start_date and per1.effective_end_date

Line 847: , per_person_type_usages_f ptu,

843: inp.party_id
844: from irc_notification_preferences inp
845: where exists (select 1
846: from per_all_people_f per
847: , per_person_type_usages_f ptu,
848: per_person_types ppt
849: where per.party_id=inp.party_id
850: and nvl(per.current_emp_or_apl_flag,'N')='N'
851: and nvl(per.current_npw_flag,'N')='N'