APPS.PA_RESOURCES_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 203: from hr_all_organization_units org --For 1807084 hr_all_organization_units

199:
200: if P_Resource_Type_Code = 'ORGANIZATION' then
201: select substr(org.name,1,60)
202: into P_organization_name
203: from hr_all_organization_units org --For 1807084 hr_all_organization_units
204: ,pa_resource_txn_attributes prta
205: where prta.organization_id = org.organization_id
206: and prta.resource_id = P_resource_id;
207: