DBA Data[Home] [Help]

APPS.PAY_SE_HOLIDAY_PAY_DEBT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 998: FROM hr_all_organization_units o1

994: csr_v_organization_id hr_organization_information.organization_id%TYPE
995: )
996: IS
997: SELECT hoi3.organization_id legal_id
998: FROM hr_all_organization_units o1
999: , hr_organization_information hoi1
1000: , hr_organization_information hoi2
1001: , hr_organization_information hoi3
1002: WHERE o1.business_group_id = g_business_group_id