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

Line 131: ,p_ni per_all_people_f.national_identifier%TYPE

127: WHERE business_group_id = v_bg_id;
128:
129: CURSOR csr_get_prim_assg
130: ( p_business_group_id per_business_groups.business_group_id%TYPE
131: ,p_ni per_all_people_f.national_identifier%TYPE
132: )
133: IS
134: SELECT PAA.ASSIGNMENT_ID
135: FROM per_all_assignments_f PAA

Line 136: , per_all_people_f PAP

132: )
133: IS
134: SELECT PAA.ASSIGNMENT_ID
135: FROM per_all_assignments_f PAA
136: , per_all_people_f PAP
137: WHERE PAA.BUSINESS_GROUP_ID = p_business_group_id
138: AND PAP.per_information_category ='NO'
139: AND PAP.NATIONAL_IDENTIFIER = p_ni
140: AND PAA.PERSON_ID = PAP.PERSON_ID