APPS.PAY_FI_TC_DP_UPLOAD dependencies on HR_ORGANIZATION_INFORMATION

Line 141: ,p_employer_org_no HR_ORGANIZATION_INFORMATION.org_information2%TYPE)

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
145: , per_all_people_f PAP

Line 159: , HR_ORGANIZATION_INFORMATION hoi1

155: AND SCL.ENABLED_FLAG = 'Y'
156: AND SCL.SEGMENT2 in
157: ( select to_char(hoi1.organization_id)
158: from HR_ORGANIZATION_UNITS o1
159: , HR_ORGANIZATION_INFORMATION hoi1
160: , HR_ORGANIZATION_INFORMATION hoi2
161: , HR_ORGANIZATION_INFORMATION hoi3
162: , HR_ORGANIZATION_INFORMATION hoi4
163: WHERE o1.business_group_id = p_business_group_id

Line 160: , HR_ORGANIZATION_INFORMATION hoi2

156: AND SCL.SEGMENT2 in
157: ( select to_char(hoi1.organization_id)
158: from HR_ORGANIZATION_UNITS o1
159: , HR_ORGANIZATION_INFORMATION hoi1
160: , HR_ORGANIZATION_INFORMATION hoi2
161: , HR_ORGANIZATION_INFORMATION hoi3
162: , HR_ORGANIZATION_INFORMATION hoi4
163: WHERE o1.business_group_id = p_business_group_id
164: and hoi1.organization_id = o1.organization_id

Line 161: , HR_ORGANIZATION_INFORMATION hoi3

157: ( select to_char(hoi1.organization_id)
158: from HR_ORGANIZATION_UNITS o1
159: , HR_ORGANIZATION_INFORMATION hoi1
160: , HR_ORGANIZATION_INFORMATION hoi2
161: , HR_ORGANIZATION_INFORMATION hoi3
162: , HR_ORGANIZATION_INFORMATION hoi4
163: WHERE o1.business_group_id = p_business_group_id
164: and hoi1.organization_id = o1.organization_id
165: and hoi1.org_information1 = 'FI_LOCAL_UNIT'

Line 162: , HR_ORGANIZATION_INFORMATION hoi4

158: from HR_ORGANIZATION_UNITS o1
159: , HR_ORGANIZATION_INFORMATION hoi1
160: , HR_ORGANIZATION_INFORMATION hoi2
161: , HR_ORGANIZATION_INFORMATION hoi3
162: , HR_ORGANIZATION_INFORMATION hoi4
163: WHERE o1.business_group_id = p_business_group_id
164: and hoi1.organization_id = o1.organization_id
165: and hoi1.org_information1 = 'FI_LOCAL_UNIT'
166: and hoi1.org_information_context = 'CLASS'

Line 182: ,p_employer_org_no HR_ORGANIZATION_INFORMATION.org_information2%TYPE)

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
186: , per_all_people_f PAP

Line 199: , HR_ORGANIZATION_INFORMATION hoi1

195: AND SCL.ENABLED_FLAG = 'Y'
196: AND SCL.SEGMENT2 in
197: ( select to_char(hoi1.organization_id)
198: from HR_ORGANIZATION_UNITS o1
199: , HR_ORGANIZATION_INFORMATION hoi1
200: , HR_ORGANIZATION_INFORMATION hoi2
201: , HR_ORGANIZATION_INFORMATION hoi3
202: , HR_ORGANIZATION_INFORMATION hoi4
203: WHERE o1.business_group_id = p_business_group_id

Line 200: , HR_ORGANIZATION_INFORMATION hoi2

196: AND SCL.SEGMENT2 in
197: ( select to_char(hoi1.organization_id)
198: from HR_ORGANIZATION_UNITS o1
199: , HR_ORGANIZATION_INFORMATION hoi1
200: , HR_ORGANIZATION_INFORMATION hoi2
201: , HR_ORGANIZATION_INFORMATION hoi3
202: , HR_ORGANIZATION_INFORMATION hoi4
203: WHERE o1.business_group_id = p_business_group_id
204: and hoi1.organization_id = o1.organization_id

Line 201: , HR_ORGANIZATION_INFORMATION hoi3

197: ( select to_char(hoi1.organization_id)
198: from HR_ORGANIZATION_UNITS o1
199: , HR_ORGANIZATION_INFORMATION hoi1
200: , HR_ORGANIZATION_INFORMATION hoi2
201: , HR_ORGANIZATION_INFORMATION hoi3
202: , HR_ORGANIZATION_INFORMATION hoi4
203: WHERE o1.business_group_id = p_business_group_id
204: and hoi1.organization_id = o1.organization_id
205: and hoi1.org_information1 = 'FI_LOCAL_UNIT'

Line 202: , HR_ORGANIZATION_INFORMATION hoi4

198: from HR_ORGANIZATION_UNITS o1
199: , HR_ORGANIZATION_INFORMATION hoi1
200: , HR_ORGANIZATION_INFORMATION hoi2
201: , HR_ORGANIZATION_INFORMATION hoi3
202: , HR_ORGANIZATION_INFORMATION hoi4
203: WHERE o1.business_group_id = p_business_group_id
204: and hoi1.organization_id = o1.organization_id
205: and hoi1.org_information1 = 'FI_LOCAL_UNIT'
206: and hoi1.org_information_context = 'CLASS'