DBA Data[Home] [Help]

APPS.PAY_SE_HOLIDAY_PAY_DEBT dependencies on HR_ORGANIZATION_UNITS

Line 298: FROM hr_organization_units o1

294: IS
295: SELECT o1.NAME legal_employer_name
296: , hoi2.org_information2 org_number
297: , hoi1.organization_id legal_id
298: FROM hr_organization_units o1
299: , hr_organization_information hoi1
300: , hr_organization_information hoi2
301: WHERE o1.business_group_id = g_business_group_id
302: AND hoi1.organization_id = o1.organization_id

Line 1021: FROM hr_organization_units o1

1017: csr_v_local_unit_id hr_organization_information.organization_id%TYPE
1018: )
1019: IS
1020: SELECT o1.NAME, hoi2.org_information1
1021: FROM hr_organization_units o1
1022: , hr_organization_information hoi1
1023: , hr_organization_information hoi2
1024: WHERE o1.business_group_id = g_business_group_id
1025: AND hoi1.organization_id = o1.organization_id