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_DOCUMENT_API dependencies on PER_ALL_PEOPLE_F

Line 702: from per_all_people_f paf,

698: --
699: cursor csr_application_count
700: Is
701: select count(pasf.person_id)
702: from per_all_people_f paf,
703: per_all_assignments_f pasf
704: where
705: paf.party_id = p_party_id
706: and pasf.person_id = paf.person_id

Line 1119: from per_all_people_f paf,

1115:
1116: cursor csr_internet_applicant
1117: Is
1118: select count(pasf.person_id)
1119: from per_all_people_f paf,
1120: per_all_assignments_f pasf
1121: where
1122: paf.party_id = p_party_id
1123: and trunc(sysdate) between paf.effective_start_date and paf.effective_end_date