APPS.PAY_SE_ALECTA dependencies on HR_ALL_ORGANIZATION_UNITS

Line 679: FROM hr_all_organization_units o

675:
676: CURSOR csr_get_all_legal_employer_id
677: IS
678: SELECT o.organization_id
679: FROM hr_all_organization_units o
680: ,hr_organization_information hoi1
681: WHERE o.business_group_id = g_business_group_id
682: AND hoi1.organization_id = o.organization_id
683: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 736: FROM hr_all_organization_units o

732: ,hoi3.org_information5
733: ,hoi3.org_information6
734: ,hoi3.org_information7
735: ,hoi3.org_information8
736: FROM hr_all_organization_units o
737: ,hr_organization_information hoi1
738: ,hr_organization_information hoi3
739: WHERE o.business_group_id = g_business_group_id
740: AND hoi1.organization_id = o.organization_id

Line 1111: FROM hr_all_organization_units o1

1107: csr_v_organization_id hr_organization_information.organization_id%TYPE
1108: )
1109: IS
1110: SELECT hoi3.organization_id legal_id
1111: FROM hr_all_organization_units o1
1112: ,hr_organization_information hoi1
1113: ,hr_organization_information hoi2
1114: ,hr_organization_information hoi3
1115: WHERE o1.business_group_id = g_business_group_id

Line 2951: FROM hr_all_organization_units o1

2947: csr_v_organization_id hr_organization_information.organization_id%TYPE
2948: )
2949: IS
2950: SELECT hoi3.organization_id legal_id
2951: FROM hr_all_organization_units o1
2952: ,hr_organization_information hoi1
2953: ,hr_organization_information hoi2
2954: ,hr_organization_information hoi3
2955: WHERE o1.business_group_id = g_business_group_id

Line 3212: FROM hr_all_organization_units o1

3208: csr_v_organization_id hr_organization_information.organization_id%TYPE
3209: )
3210: IS
3211: SELECT hoi3.organization_id legal_id
3212: FROM hr_all_organization_units o1
3213: ,hr_organization_information hoi1
3214: ,hr_organization_information hoi2
3215: ,hr_organization_information hoi3
3216: WHERE o1.business_group_id = g_business_group_id