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

Line 2142: per_person_type_usages_f pptu

2138: cursor csr_validate_person(b_person_id number, b_effective_date date) is
2139: SELECT 1
2140: FROM per_all_people_f per,
2141: per_person_types ppt,
2142: per_person_type_usages_f pptu
2143: WHERE per.person_id = b_person_id
2144: AND TRUNC(b_effective_date) between TRUNC(per.effective_Start_date) and TRUNC(per.effective_end_date)
2145: AND TRUNC(b_effective_date) between TRUNC(pptu.effective_Start_date) and TRUNC(pptu.effective_end_date)
2146: AND pptu.person_id = per.person_id