APPS.PAY_FI_ARCHIVE_UMFR dependencies on HR_ORGANIZATION_INFORMATION

Line 250: csr_v_trade_union_id hr_organization_information.organization_id%TYPE

246: l_flag NUMBER := 0;
247: l_element_context VARCHAR2 (5);
248:
249: CURSOR csr_trade_union_details (
250: csr_v_trade_union_id hr_organization_information.organization_id%TYPE
251: )
252: IS
253: SELECT hou.NAME, hoi.org_information1, hoi.org_information5
254: FROM hr_organization_information hoi, hr_organization_units hou

Line 254: FROM hr_organization_information hoi, hr_organization_units hou

250: csr_v_trade_union_id hr_organization_information.organization_id%TYPE
251: )
252: IS
253: SELECT hou.NAME, hoi.org_information1, hoi.org_information5
254: FROM hr_organization_information hoi, hr_organization_units hou
255: WHERE org_information_context = 'FI_TRADE_UNION_DETAILS'
256: AND hou.organization_id = csr_v_trade_union_id
257: AND hoi.organization_id = hou.organization_id;
258:

Line 262: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE

258:
259: lr_trade_union_details csr_trade_union_details%ROWTYPE;
260:
261: CURSOR csr_legal_employer_details (
262: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
263: )
264: IS
265: SELECT hou.NAME, hoi.org_information1, hoi.org_information8
266: FROM hr_organization_information hoi, hr_organization_units hou

Line 266: FROM hr_organization_information hoi, hr_organization_units hou

262: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
263: )
264: IS
265: SELECT hou.NAME, hoi.org_information1, hoi.org_information8
266: FROM hr_organization_information hoi, hr_organization_units hou
267: WHERE org_information_context = 'FI_LEGAL_EMPLOYER_DETAILS'
268: AND hoi.organization_id = hou.organization_id
269: AND hou.organization_id = csr_v_legal_employer_id;
270:

Line 274: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE

270:
271: lr_legal_employer_details csr_legal_employer_details%ROWTYPE;
272:
273: CURSOR csr_all_local_unit_details (
274: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
275: )
276: IS
277: SELECT hoi_le.org_information1 local_unit_id,
278: hou_lu.NAME local_unit_name,

Line 282: hr_organization_information hoi_le,

278: hou_lu.NAME local_unit_name,
279: hoi_lu.org_information1 y_spare_number,
280: hoi_lu.org_information2 local_unit_number
281: FROM hr_organization_units hou_le,
282: hr_organization_information hoi_le,
283: hr_organization_units hou_lu,
284: hr_organization_information hoi_lu
285: WHERE hoi_le.organization_id = hou_le.organization_id
286: AND hou_le.organization_id = csr_v_legal_employer_id

Line 284: hr_organization_information hoi_lu

280: hoi_lu.org_information2 local_unit_number
281: FROM hr_organization_units hou_le,
282: hr_organization_information hoi_le,
283: hr_organization_units hou_lu,
284: hr_organization_information hoi_lu
285: WHERE hoi_le.organization_id = hou_le.organization_id
286: AND hou_le.organization_id = csr_v_legal_employer_id
287: AND hoi_le.org_information_context = 'FI_LOCAL_UNITS'
288: AND hou_lu.organization_id = hoi_le.org_information1

Line 295: csr_v_local_unit_id hr_organization_information.organization_id%TYPE

291:
292: lr_all_local_unit_details csr_all_local_unit_details%ROWTYPE;
293:
294: CURSOR csr_local_unit_details (
295: csr_v_local_unit_id hr_organization_information.organization_id%TYPE
296: )
297: IS
298: SELECT hou.NAME, hoi.org_information1 y_spare_number,
299: hoi.org_information2 local_unit_number

Line 300: FROM hr_organization_information hoi, hr_organization_units hou

296: )
297: IS
298: SELECT hou.NAME, hoi.org_information1 y_spare_number,
299: hoi.org_information2 local_unit_number
300: FROM hr_organization_information hoi, hr_organization_units hou
301: WHERE org_information_context = 'FI_LOCAL_UNIT_DETAILS'
302: AND hoi.organization_id = hou.organization_id
303: AND hou.organization_id = csr_v_local_unit_id;
304:

Line 1271: csr_v_local_unit_id hr_organization_information.organization_id%TYPE

1267:
1268:
1269: CURSOR csr_person_details (
1270: csr_v_business_group_id per_all_people_f.business_group_id%TYPE,
1271: csr_v_local_unit_id hr_organization_information.organization_id%TYPE
1272: )
1273: IS
1274: SELECT pap.LAST_NAME || ' ' || pap.FIRST_NAME NAME, pap.national_identifier,
1275: paa.assignment_id assignment_id,