APPS.PAY_SE_PAYSLIP_REPORT dependencies on HR_ORGANIZATION_INFORMATION

Line 396: , hr_organization_information hoi1

392:
393: CURSOR csr_legal_employer_id (p_business_group_id NUMBER , p_organization_id NUMBER) IS
394: SELECT hoi3.organization_id legal_employer_id
395: FROM hr_organization_units o1
396: , hr_organization_information hoi1
397: , hr_organization_information hoi2
398: , hr_organization_information hoi3
399: WHERE o1.business_group_id =p_business_group_id
400: AND hoi1.organization_id = o1.organization_id

Line 397: , hr_organization_information hoi2

393: CURSOR csr_legal_employer_id (p_business_group_id NUMBER , p_organization_id NUMBER) IS
394: SELECT hoi3.organization_id legal_employer_id
395: FROM hr_organization_units o1
396: , hr_organization_information hoi1
397: , hr_organization_information hoi2
398: , hr_organization_information hoi3
399: WHERE o1.business_group_id =p_business_group_id
400: AND hoi1.organization_id = o1.organization_id
401: AND hoi1.organization_id = p_organization_id

Line 398: , hr_organization_information hoi3

394: SELECT hoi3.organization_id legal_employer_id
395: FROM hr_organization_units o1
396: , hr_organization_information hoi1
397: , hr_organization_information hoi2
398: , hr_organization_information hoi3
399: WHERE o1.business_group_id =p_business_group_id
400: AND hoi1.organization_id = o1.organization_id
401: AND hoi1.organization_id = p_organization_id
402: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 418: FROM hr_organization_information

414:
415: CURSOR csr_post_header(l_legal_emp_org_id NUMBER)
416: IS
417: SELECT ORG_INFORMATION1,ORG_INFORMATION2,ORG_INFORMATION3
418: FROM hr_organization_information
419: WHERE organization_id = l_legal_emp_org_id
420: AND org_information_context = 'SE_POST_PAYSLIP_INFO';
421:
422: lr_post_header csr_post_header%ROWTYPE;