DBA Data[Home] [Help]

APPS.PA_RESOURCES_PKG dependencies on PER_JOBS

Line 214: from per_jobs pj -- For 1807084, per_jobs replaces pa_jobs_res_v

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: