DBA Data[Home] [Help]

APPS.PAY_SE_ALECTA dependencies on HR_ORGANIZATION_UNITS

Line 246: FROM hr_organization_units o1

242: IS
243: SELECT o1.NAME legal_employer_name
244: ,hoi2.org_information2 org_number
245: ,hoi1.organization_id legal_id
246: FROM hr_organization_units o1
247: ,hr_organization_information hoi1
248: ,hr_organization_information hoi2
249: WHERE o1.business_group_id = g_business_group_id
250: AND hoi1.organization_id = o1.organization_id

Line 1088: FROM hr_organization_units o1

1084: )
1085: IS
1086: SELECT o1.NAME
1087: ,hoi2.org_information1
1088: FROM hr_organization_units o1
1089: ,hr_organization_information hoi1
1090: ,hr_organization_information hoi2
1091: WHERE o1.business_group_id = g_business_group_id
1092: AND hoi1.organization_id = o1.organization_id

Line 2547: FROM hr_organization_units o1

2543: IS
2544: SELECT o1.NAME legal_employer_name
2545: ,hoi2.org_information2 org_number
2546: ,hoi1.organization_id legal_id
2547: FROM hr_organization_units o1
2548: ,hr_organization_information hoi1
2549: ,hr_organization_information hoi2
2550: WHERE o1.business_group_id = g_business_group_id
2551: AND hoi1.organization_id = o1.organization_id