APPS.IGC_CC_OPEN_INTERFACE_PKG dependencies on PA_ALL_ORGANIZATIONS

Line 4241: pa_all_organizations b

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'
4245: AND b.inactive_date IS NULL