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.PAY_US_EMP_DT_TAX_RULES dependencies on PER_ALL_ASSIGNMENTS_F

Line 12363: from per_people_extra_info where person_id=(select distinct person_id from per_all_assignments_f

12359:
12360: cursor csr_chk_student_status
12361: is
12362: select pei_information1,pei_information2
12363: from per_people_extra_info where person_id=(select distinct person_id from per_all_assignments_f
12364: where assignment_id=p_assignment_id
12365: and primary_flag='Y')
12366: and information_type like 'PER_US_ADDITIONAL_DETAILS'
12367: and pei_information_category like 'PER_US_ADDITIONAL_DETAILS'

Line 12374: from per_people_extra_info where person_id=(select distinct person_id from per_all_assignments_f

12370:
12371: cursor csr_chk_nra_status
12372: is
12373: select information_type,pei_information_category,pei_information5,pei_information9
12374: from per_people_extra_info where person_id=(select distinct person_id from per_all_assignments_f
12375: where assignment_id=p_assignment_id
12376: and primary_flag='Y')
12377: and information_type like 'PER_US_ADDITIONAL_DETAILS'
12378: and pei_information_category like 'PER_US_ADDITIONAL_DETAILS'