210: elsif
211: P_Resource_Type_Code = 'JOB' then
212: select SUBSTR(pj.name,1,60)
213: into P_job_name
214: from per_jobs pj -- For 1807084, per_jobs replaces pa_jobs_res_v
215: ,pa_resource_txn_attributes prta
216: where prta.job_id = pj.job_id
217: and prta.resource_id = P_resource_id;
218: