APPS.PAY_SE_ARCHIVE_CWCA dependencies on HR_ORGANIZATION_INFORMATION

Line 329: csr_v_local_unit_id hr_organization_information.organization_id%TYPE

325:
326: lr_address_details csr_address_details%ROWTYPE;
327:
328: CURSOR csr_legal_employer_details (
329: csr_v_local_unit_id hr_organization_information.organization_id%TYPE
330: )
331: IS
332: SELECT o.NAME
333: ,hoi3.org_information2 "ORG_NUMBER"

Line 337: ,hr_organization_information hoi1

333: ,hoi3.org_information2 "ORG_NUMBER"
334: ,o.location_id
335: ,o.organization_id
336: FROM hr_all_organization_units o
337: ,hr_organization_information hoi1
338: ,hr_organization_information hoi2
339: ,hr_organization_information hoi3
340: WHERE o.business_group_id = g_business_group_id
341: AND hoi1.organization_id = o.organization_id

Line 338: ,hr_organization_information hoi2

334: ,o.location_id
335: ,o.organization_id
336: FROM hr_all_organization_units o
337: ,hr_organization_information hoi1
338: ,hr_organization_information hoi2
339: ,hr_organization_information hoi3
340: WHERE o.business_group_id = g_business_group_id
341: AND hoi1.organization_id = o.organization_id
342: AND hoi1.org_information_context = 'CLASS'

Line 339: ,hr_organization_information hoi3

335: ,o.organization_id
336: FROM hr_all_organization_units o
337: ,hr_organization_information hoi1
338: ,hr_organization_information hoi2
339: ,hr_organization_information hoi3
340: WHERE o.business_group_id = g_business_group_id
341: AND hoi1.organization_id = o.organization_id
342: AND hoi1.org_information_context = 'CLASS'
343: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 353: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE

349:
350: lr_legal_employer_details csr_legal_employer_details%ROWTYPE;
351:
352: CURSOR csr_contact_details (
353: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
354: )
355: IS
356: SELECT hoi4.org_information3
357: FROM hr_organization_information hoi4

Line 357: FROM hr_organization_information hoi4

353: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
354: )
355: IS
356: SELECT hoi4.org_information3
357: FROM hr_organization_information hoi4
358: WHERE hoi4.organization_id = csr_v_legal_employer_id
359: AND hoi4.org_information_context = 'SE_ORG_CONTACT_DETAILS'
360: AND hoi4.org_information_id =
361: (SELECT MIN (org_information_id)

Line 362: FROM hr_organization_information

358: WHERE hoi4.organization_id = csr_v_legal_employer_id
359: AND hoi4.org_information_context = 'SE_ORG_CONTACT_DETAILS'
360: AND hoi4.org_information_id =
361: (SELECT MIN (org_information_id)
362: FROM hr_organization_information
363: WHERE organization_id = csr_v_legal_employer_id
364: AND org_information_context = 'SE_ORG_CONTACT_DETAILS'
365: AND org_information1 = 'PHONE');
366: