APPS.IGC_CC_OPEN_INTERFACE_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 4240: FROM hr_all_organization_units a,

4236: -- AND organization_id = P_Expenditure_Org_Id
4237: -- AND sysdate between date_from and nvl(date_to, sysdate);
4238:
4239: SELECT a.organization_id INTO l_expenditure_org_id
4240: FROM hr_all_organization_units a,
4241: pa_all_organizations b
4242: WHERE a.organization_id = b.organization_id
4243: AND sysdate between a.date_from and nvl(a.date_to, sysdate)
4244: AND b.pa_org_use_type = 'EXPENDITURES'