APPS.PAY_SE_WORK_TIME_CERTIFICATE dependencies on HR_ORGANIZATION_INFORMATION

Line 407: csr_v_local_unit_id hr_organization_information.organization_id%TYPE

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

Line 415: ,hr_organization_information hoi1

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

Line 416: ,hr_organization_information hoi2

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

Line 417: ,hr_organization_information hoi3

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

Line 431: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE

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

Line 435: FROM hr_organization_information hoi4

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

Line 440: FROM hr_organization_information

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