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 658: ,per_person_type_usages_f ptu

654: function is_free_to_purge(p_party_id number,p_effective_date date) return string is
655: cursor c1 (p_party_id number,p_effective_date date) is
656: select 1
657: from per_all_people_f per1
658: ,per_person_type_usages_f ptu
659: ,per_person_types ppt
660: where per1.party_id = p_party_id
661: and per1.person_id = ptu.person_id
662: and p_effective_date between per1.effective_start_date and per1.effective_end_date

Line 720: , per_person_type_usages_f ptu,

716: inp.party_id
717: from irc_notification_preferences inp
718: where exists (select 1
719: from per_all_people_f per
720: , per_person_type_usages_f ptu,
721: per_person_types ppt
722: where per.party_id=inp.party_id
723: and nvl(per.current_emp_or_apl_flag,'N')='N'
724: and nvl(per.current_npw_flag,'N')='N'