APPS.EDW_HR_JOBS_M_SIZING dependencies on PER_JOBS

Line 16: FROM per_jobs job

12:
13: /* Cursor description */
14: CURSOR row_count_cur IS
15: SELECT count(job.job_id) total
16: FROM per_jobs job
17: WHERE NVL(job.last_update_date, to_date('01-01-2000','DD-MM-YYYY'))
18: BETWEEN p_from_date AND p_to_date;
19:
20: BEGIN

Line 101: FROM per_jobs job

97: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,14)),0))
98: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,15)),0))
99: ,avg(nvl(vsize(job.emp_rights_flag),0))
100: ,avg(nvl(vsize(job.benchmark_job_flag),0))
101: FROM 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))

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

Line 113: FROM hr_all_organization_units bgr, per_jobs job

109: CURSOR bgr_cur IS
110: SELECT
111: avg(nvl(vsize(organization_id),0))
112: ,avg(nvl(vsize(bgr.name),0))
113: FROM hr_all_organization_units bgr, per_jobs job
114: WHERE job.last_update_date BETWEEN p_from_date AND p_to_date;
115:
116:
117: BEGIN