APPS.EDW_HR_JOBS_M_SIZING dependencies on PER_JOB_DEFINITIONS

Line 106: FROM per_job_definitions jdef, per_jobs job

102: WHERE job.last_update_date BETWEEN p_from_date AND p_to_date;
103:
104: CURSOR jdef_cur IS
105: SELECT avg(nvl(vsize(jdef.job_definition_id),0))
106: FROM per_job_definitions jdef, per_jobs job
107: WHERE job.last_update_date BETWEEN p_from_date AND p_to_date;
108:
109: CURSOR bgr_cur IS
110: SELECT