199:
200: if P_Resource_Type_Code = 'ORGANIZATION' then
201: select substrb(org.name,1,60) -- Bug#7832726
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: