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

Line 140: ,p_ni per_all_people_f.national_identifier%TYPE

136: FROM per_business_groups
137: WHERE business_group_id = v_bg_id;
138:
139: CURSOR csr_get_prim_assg( p_business_group_id per_business_groups.business_group_id%TYPE
140: ,p_ni per_all_people_f.national_identifier%TYPE
141: ,p_employer_org_no HR_ORGANIZATION_INFORMATION.org_information2%TYPE)
142: IS
143: SELECT PAA.ASSIGNMENT_ID
144: FROM per_all_assignments_f PAA

Line 145: , per_all_people_f PAP

141: ,p_employer_org_no HR_ORGANIZATION_INFORMATION.org_information2%TYPE)
142: IS
143: SELECT PAA.ASSIGNMENT_ID
144: FROM per_all_assignments_f PAA
145: , per_all_people_f PAP
146: , hr_soft_coding_keyflex SCL
147: WHERE PAA.BUSINESS_GROUP_ID = p_business_group_id
148: AND PAP.per_information_category ='FI'
149: AND PAP.NATIONAL_IDENTIFIER = p_ni

Line 181: ,p_ni per_all_people_f.national_identifier%TYPE

177:
178:
179:
180: CURSOR csr_get_all_assg( p_business_group_id per_business_groups.business_group_id%TYPE
181: ,p_ni per_all_people_f.national_identifier%TYPE
182: ,p_employer_org_no HR_ORGANIZATION_INFORMATION.org_information2%TYPE)
183: IS
184: SELECT PAA.ASSIGNMENT_ID
185: FROM per_all_assignments_f PAA

Line 186: , per_all_people_f PAP

182: ,p_employer_org_no HR_ORGANIZATION_INFORMATION.org_information2%TYPE)
183: IS
184: SELECT PAA.ASSIGNMENT_ID
185: FROM per_all_assignments_f PAA
186: , per_all_people_f PAP
187: , hr_soft_coding_keyflex SCL
188: WHERE PAA.BUSINESS_GROUP_ID = p_business_group_id
189: AND PAP.per_information_category ='FI'
190: AND PAP.NATIONAL_IDENTIFIER = p_ni