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_ASSIGNMENTS_F

Line 703: per_all_assignments_f pasf

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
707: and pasf.assignment_type = 'A'

Line 1120: per_all_assignments_f pasf

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
1124: and trunc(sysdate) between pasf.effective_start_date and pasf.effective_end_date