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_TYPES

Line 659: ,per_person_types ppt

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
663: and ptu.effective_end_date > p_effective_date

Line 721: per_person_types ppt

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'
725: and per.person_id=ptu.person_id