APPS.PAY_SE_WORK_TIME_CERTIFICATE dependencies on HR_ORGANIZATION_INFORMATION

Line 409: csr_v_local_unit_id hr_organization_information.organization_id%TYPE

405:
406: lr_address_details csr_address_details%ROWTYPE;
407:
408: CURSOR csr_legal_employer_details (
409: csr_v_local_unit_id hr_organization_information.organization_id%TYPE
410: )
411: IS
412: SELECT o.NAME
413: ,hoi3.org_information2 "ORG_NUMBER"

Line 417: ,hr_organization_information hoi1

413: ,hoi3.org_information2 "ORG_NUMBER"
414: ,o.location_id
415: ,o.organization_id
416: FROM hr_all_organization_units o
417: ,hr_organization_information hoi1
418: ,hr_organization_information hoi2
419: ,hr_organization_information hoi3
420: WHERE o.business_group_id = g_business_group_id
421: AND hoi1.organization_id = o.organization_id

Line 418: ,hr_organization_information hoi2

414: ,o.location_id
415: ,o.organization_id
416: FROM hr_all_organization_units o
417: ,hr_organization_information hoi1
418: ,hr_organization_information hoi2
419: ,hr_organization_information hoi3
420: WHERE o.business_group_id = g_business_group_id
421: AND hoi1.organization_id = o.organization_id
422: AND hoi1.org_information_context = 'CLASS'

Line 419: ,hr_organization_information hoi3

415: ,o.organization_id
416: FROM hr_all_organization_units o
417: ,hr_organization_information hoi1
418: ,hr_organization_information hoi2
419: ,hr_organization_information hoi3
420: WHERE o.business_group_id = g_business_group_id
421: AND hoi1.organization_id = o.organization_id
422: AND hoi1.org_information_context = 'CLASS'
423: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 433: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE

429:
430: lr_legal_employer_details csr_legal_employer_details%ROWTYPE;
431:
432: CURSOR csr_contact_details (
433: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
434: )
435: IS
436: SELECT hoi4.org_information3
437: FROM hr_organization_information hoi4

Line 437: FROM hr_organization_information hoi4

433: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
434: )
435: IS
436: SELECT hoi4.org_information3
437: FROM hr_organization_information hoi4
438: WHERE hoi4.organization_id = csr_v_legal_employer_id
439: AND hoi4.org_information_context = 'SE_ORG_CONTACT_DETAILS'
440: AND hoi4.org_information_id =
441: (SELECT MIN (org_information_id)

Line 442: FROM hr_organization_information

438: WHERE hoi4.organization_id = csr_v_legal_employer_id
439: AND hoi4.org_information_context = 'SE_ORG_CONTACT_DETAILS'
440: AND hoi4.org_information_id =
441: (SELECT MIN (org_information_id)
442: FROM hr_organization_information
443: WHERE organization_id = csr_v_legal_employer_id
444: AND org_information_context = 'SE_ORG_CONTACT_DETAILS'
445: AND org_information1 = 'PHONE');
446: