APPS.PAY_SE_ALECTA dependencies on HR_ALL_ORGANIZATION_UNITS

Line 639: FROM hr_all_organization_units o

635:
636: CURSOR csr_get_all_legal_employer_id
637: IS
638: SELECT o.organization_id
639: FROM hr_all_organization_units o
640: ,hr_organization_information hoi1
641: WHERE o.business_group_id = g_business_group_id
642: AND hoi1.organization_id = o.organization_id
643: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 696: FROM hr_all_organization_units o

692: ,hoi3.org_information5
693: ,hoi3.org_information6
694: ,hoi3.org_information7
695: ,hoi3.org_information8
696: FROM hr_all_organization_units o
697: ,hr_organization_information hoi1
698: ,hr_organization_information hoi3
699: WHERE o.business_group_id = g_business_group_id
700: AND hoi1.organization_id = o.organization_id

Line 1064: FROM hr_all_organization_units o1

1060: csr_v_organization_id hr_organization_information.organization_id%TYPE
1061: )
1062: IS
1063: SELECT hoi3.organization_id legal_id
1064: FROM hr_all_organization_units o1
1065: ,hr_organization_information hoi1
1066: ,hr_organization_information hoi2
1067: ,hr_organization_information hoi3
1068: WHERE o1.business_group_id = g_business_group_id

Line 2523: FROM hr_all_organization_units o1

2519: csr_v_organization_id hr_organization_information.organization_id%TYPE
2520: )
2521: IS
2522: SELECT hoi3.organization_id legal_id
2523: FROM hr_all_organization_units o1
2524: ,hr_organization_information hoi1
2525: ,hr_organization_information hoi2
2526: ,hr_organization_information hoi3
2527: WHERE o1.business_group_id = g_business_group_id

Line 2784: FROM hr_all_organization_units o1

2780: csr_v_organization_id hr_organization_information.organization_id%TYPE
2781: )
2782: IS
2783: SELECT hoi3.organization_id legal_id
2784: FROM hr_all_organization_units o1
2785: ,hr_organization_information hoi1
2786: ,hr_organization_information hoi2
2787: ,hr_organization_information hoi3
2788: WHERE o1.business_group_id = g_business_group_id