APPS.EDW_HR_ASSGNMNT_M_SIZING dependencies on HR_GENERAL

Line 109: ,avg(nvl(vsize(hr_general.decode_lookup('YES_NO', primary_flag)),0))

105: ,avg(nvl(vsize(time_normal_finish),0))
106: ,avg(nvl(vsize(probation_period),0))
107: ,avg(nvl(vsize(perf_review_period),0))
108: ,avg(nvl(vsize(sal_review_period),0))
109: ,avg(nvl(vsize(hr_general.decode_lookup('YES_NO', primary_flag)),0))
110: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', frequency)),0))
111: ,avg(nvl(vsize(hr_general.decode_lookup('EMP_APL', assignment_type)),0))
112: ,avg(nvl(vsize(hr_general.decode_lookup('YES_NO', manager_flag)),0))
113: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', probation_unit)),0))

Line 110: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', frequency)),0))

106: ,avg(nvl(vsize(probation_period),0))
107: ,avg(nvl(vsize(perf_review_period),0))
108: ,avg(nvl(vsize(sal_review_period),0))
109: ,avg(nvl(vsize(hr_general.decode_lookup('YES_NO', primary_flag)),0))
110: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', frequency)),0))
111: ,avg(nvl(vsize(hr_general.decode_lookup('EMP_APL', assignment_type)),0))
112: ,avg(nvl(vsize(hr_general.decode_lookup('YES_NO', manager_flag)),0))
113: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', probation_unit)),0))
114: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', perf_review_period_frequency)),0))

Line 111: ,avg(nvl(vsize(hr_general.decode_lookup('EMP_APL', assignment_type)),0))

107: ,avg(nvl(vsize(perf_review_period),0))
108: ,avg(nvl(vsize(sal_review_period),0))
109: ,avg(nvl(vsize(hr_general.decode_lookup('YES_NO', primary_flag)),0))
110: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', frequency)),0))
111: ,avg(nvl(vsize(hr_general.decode_lookup('EMP_APL', assignment_type)),0))
112: ,avg(nvl(vsize(hr_general.decode_lookup('YES_NO', manager_flag)),0))
113: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', probation_unit)),0))
114: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', perf_review_period_frequency)),0))
115: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', sal_review_period_frequency)),0))

Line 112: ,avg(nvl(vsize(hr_general.decode_lookup('YES_NO', manager_flag)),0))

108: ,avg(nvl(vsize(sal_review_period),0))
109: ,avg(nvl(vsize(hr_general.decode_lookup('YES_NO', primary_flag)),0))
110: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', frequency)),0))
111: ,avg(nvl(vsize(hr_general.decode_lookup('EMP_APL', assignment_type)),0))
112: ,avg(nvl(vsize(hr_general.decode_lookup('YES_NO', manager_flag)),0))
113: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', probation_unit)),0))
114: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', perf_review_period_frequency)),0))
115: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', sal_review_period_frequency)),0))
116: ,avg(nvl(vsize(hr_general.decode_lookup('HOURLY_SALARIED_CODE', hourly_salaried_code)),0))

Line 113: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', probation_unit)),0))

109: ,avg(nvl(vsize(hr_general.decode_lookup('YES_NO', primary_flag)),0))
110: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', frequency)),0))
111: ,avg(nvl(vsize(hr_general.decode_lookup('EMP_APL', assignment_type)),0))
112: ,avg(nvl(vsize(hr_general.decode_lookup('YES_NO', manager_flag)),0))
113: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', probation_unit)),0))
114: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', perf_review_period_frequency)),0))
115: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', sal_review_period_frequency)),0))
116: ,avg(nvl(vsize(hr_general.decode_lookup('HOURLY_SALARIED_CODE', hourly_salaried_code)),0))
117: FROM per_all_assignments_f

Line 114: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', perf_review_period_frequency)),0))

110: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', frequency)),0))
111: ,avg(nvl(vsize(hr_general.decode_lookup('EMP_APL', assignment_type)),0))
112: ,avg(nvl(vsize(hr_general.decode_lookup('YES_NO', manager_flag)),0))
113: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', probation_unit)),0))
114: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', perf_review_period_frequency)),0))
115: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', sal_review_period_frequency)),0))
116: ,avg(nvl(vsize(hr_general.decode_lookup('HOURLY_SALARIED_CODE', hourly_salaried_code)),0))
117: FROM per_all_assignments_f
118: WHERE last_update_date BETWEEN p_from_date AND p_to_date;

Line 115: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', sal_review_period_frequency)),0))

111: ,avg(nvl(vsize(hr_general.decode_lookup('EMP_APL', assignment_type)),0))
112: ,avg(nvl(vsize(hr_general.decode_lookup('YES_NO', manager_flag)),0))
113: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', probation_unit)),0))
114: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', perf_review_period_frequency)),0))
115: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', sal_review_period_frequency)),0))
116: ,avg(nvl(vsize(hr_general.decode_lookup('HOURLY_SALARIED_CODE', hourly_salaried_code)),0))
117: FROM per_all_assignments_f
118: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
119:

Line 116: ,avg(nvl(vsize(hr_general.decode_lookup('HOURLY_SALARIED_CODE', hourly_salaried_code)),0))

112: ,avg(nvl(vsize(hr_general.decode_lookup('YES_NO', manager_flag)),0))
113: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', probation_unit)),0))
114: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', perf_review_period_frequency)),0))
115: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY', sal_review_period_frequency)),0))
116: ,avg(nvl(vsize(hr_general.decode_lookup('HOURLY_SALARIED_CODE', hourly_salaried_code)),0))
117: FROM per_all_assignments_f
118: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
119:
120: CURSOR ast_cur IS