APPS.PAY_SE_ARCHIVE_CWCA dependencies on HR_ORGANIZATION_INFORMATION

Line 332: csr_v_local_unit_id hr_organization_information.organization_id%TYPE

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

Line 340: ,hr_organization_information hoi1

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

Line 341: ,hr_organization_information hoi2

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

Line 342: ,hr_organization_information hoi3

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

Line 356: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE

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

Line 360: FROM hr_organization_information hoi4

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

Line 365: FROM hr_organization_information

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