APPS.EDW_HR_JOBS_M_SIZING dependencies on HRI_EDW_DIM_JOB

Line 84: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,1)),0))

80: CURSOR job_cur IS
81: SELECT
82: avg(nvl(vsize(job.job_id),0))
83: ,avg(nvl(vsize(job.name),0))
84: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,1)),0))
85: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,2)),0))
86: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,3)),0))
87: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,4)),0))
88: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,5)),0))

Line 85: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,2)),0))

81: SELECT
82: avg(nvl(vsize(job.job_id),0))
83: ,avg(nvl(vsize(job.name),0))
84: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,1)),0))
85: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,2)),0))
86: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,3)),0))
87: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,4)),0))
88: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,5)),0))
89: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,6)),0))

Line 86: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,3)),0))

82: avg(nvl(vsize(job.job_id),0))
83: ,avg(nvl(vsize(job.name),0))
84: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,1)),0))
85: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,2)),0))
86: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,3)),0))
87: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,4)),0))
88: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,5)),0))
89: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,6)),0))
90: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,7)),0))

Line 87: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,4)),0))

83: ,avg(nvl(vsize(job.name),0))
84: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,1)),0))
85: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,2)),0))
86: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,3)),0))
87: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,4)),0))
88: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,5)),0))
89: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,6)),0))
90: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,7)),0))
91: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,8)),0))

Line 88: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,5)),0))

84: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,1)),0))
85: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,2)),0))
86: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,3)),0))
87: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,4)),0))
88: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,5)),0))
89: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,6)),0))
90: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,7)),0))
91: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,8)),0))
92: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,9)),0))

Line 89: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,6)),0))

85: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,2)),0))
86: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,3)),0))
87: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,4)),0))
88: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,5)),0))
89: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,6)),0))
90: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,7)),0))
91: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,8)),0))
92: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,9)),0))
93: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,10)),0))

Line 90: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,7)),0))

86: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,3)),0))
87: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,4)),0))
88: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,5)),0))
89: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,6)),0))
90: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,7)),0))
91: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,8)),0))
92: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,9)),0))
93: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,10)),0))
94: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,11)),0))

Line 91: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,8)),0))

87: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,4)),0))
88: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,5)),0))
89: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,6)),0))
90: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,7)),0))
91: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,8)),0))
92: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,9)),0))
93: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,10)),0))
94: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,11)),0))
95: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,12)),0))

Line 92: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,9)),0))

88: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,5)),0))
89: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,6)),0))
90: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,7)),0))
91: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,8)),0))
92: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,9)),0))
93: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,10)),0))
94: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,11)),0))
95: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,12)),0))
96: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,13)),0))

Line 93: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,10)),0))

89: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,6)),0))
90: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,7)),0))
91: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,8)),0))
92: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,9)),0))
93: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,10)),0))
94: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,11)),0))
95: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,12)),0))
96: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,13)),0))
97: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,14)),0))

Line 94: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,11)),0))

90: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,7)),0))
91: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,8)),0))
92: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,9)),0))
93: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,10)),0))
94: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,11)),0))
95: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,12)),0))
96: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,13)),0))
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))

Line 95: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,12)),0))

91: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,8)),0))
92: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,9)),0))
93: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,10)),0))
94: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,11)),0))
95: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,12)),0))
96: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,13)),0))
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))

Line 96: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,13)),0))

92: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,9)),0))
93: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,10)),0))
94: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,11)),0))
95: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,12)),0))
96: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,13)),0))
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))

Line 97: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,14)),0))

93: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,10)),0))
94: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,11)),0))
95: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,12)),0))
96: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,13)),0))
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

Line 98: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,15)),0))

94: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,11)),0))
95: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,12)),0))
96: ,avg(nvl(vsize(hri_edw_dim_job.find_job_category(job.job_id,13)),0))
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;