DBA Data[Home] [Help]

APPS.PAY_NO_RULES dependencies on HR_ORGANIZATION_UNITS

Line 23: FROM hr_organization_units o1

19: AND PAA.soft_coding_keyflex_id = SCL.soft_coding_keyflex_id
20: AND p_effective_date BETWEEN PAA.effective_start_date AND PAA.effective_end_date ;
21: CURSOR c_tax_unit_id (p_business_group_id NUMBER , p_organization_id NUMBER) IS
22: SELECT hoi3.organization_id
23: FROM hr_organization_units o1
24: , hr_organization_information hoi1
25: , hr_organization_information hoi2
26: , hr_organization_information hoi3
27: WHERE o1.business_group_id =p_business_group_id