APPS.BEN_CWB_CD_SUMMARY_PKG dependencies on BEN_CWB_PERSON_INFO_PKG

Line 130: , ben_cwb_person_info_pkg.get_grd_quartile ((per.base_salary + decode (temp.plsalarycomp, 'ICM7'

126: , opt4rt.ws_val, 0), 0)
127: , 0))) * (temp.planufactor / per.pay_annulization_factor)) / decode (per.base_salary_frequency, 'HOURLY'
128: , 1, decode (per.fte_factor, 0
129: , to_number (NULL), per.fte_factor)) new_fte_salary
130: , ben_cwb_person_info_pkg.get_grd_quartile ((per.base_salary + decode (temp.plsalarycomp, 'ICM7'
131: , plrt.ws_val, (nvl2 (temp.oipl1id, decode (opt1rt.elig_flag, 'Y'
132: , decode (temp.opt1salarycomp, 'ICM7'
133: , opt1rt.ws_val, 0), 0)
134: , 0) + nvl2 (temp.oipl2id, decode (opt2rt.elig_flag, 'Y'

Line 147: , ben_cwb_person_info_pkg.get_grd_quintile ((per.base_salary + decode (temp.plsalarycomp, 'ICM7'

143: , 0))) * (temp.planufactor / per.pay_annulization_factor)) * per.pay_annulization_factor / decode (per.base_salary_frequency, 'HOURLY'
144: , 1, decode (per.fte_factor, 0
145: , to_number (NULL), per.fte_factor)), per.grd_min_val * per.grade_annulization_factor
146: , per.grd_max_val * per.grade_annulization_factor, per.grd_mid_point * per.grade_annulization_factor) new_quartile
147: , ben_cwb_person_info_pkg.get_grd_quintile ((per.base_salary + decode (temp.plsalarycomp, 'ICM7'
148: , plrt.ws_val, (nvl2 (temp.oipl1id, decode (opt1rt.elig_flag, 'Y'
149: , decode (temp.opt1salarycomp, 'ICM7'
150: , opt1rt.ws_val, 0), 0)
151: , 0) + nvl2 (temp.oipl2id, decode (opt2rt.elig_flag, 'Y'

Line 164: , ben_cwb_person_info_pkg.get_grd_decile ((per.base_salary + decode (temp.plsalarycomp, 'ICM7'

160: , 0))) * (temp.planufactor / per.pay_annulization_factor)) * per.pay_annulization_factor / decode (per.base_salary_frequency, 'HOURLY'
161: , 1, decode (per.fte_factor, 0
162: , to_number (NULL), per.fte_factor)), per.grd_min_val * per.grade_annulization_factor
163: , per.grd_max_val * per.grade_annulization_factor) new_quintile
164: , ben_cwb_person_info_pkg.get_grd_decile ((per.base_salary + decode (temp.plsalarycomp, 'ICM7'
165: , plrt.ws_val, (nvl2 (temp.oipl1id, decode (opt1rt.elig_flag, 'Y'
166: , decode (temp.opt1salarycomp, 'ICM7'
167: , opt1rt.ws_val, 0), 0)
168: , 0) + nvl2 (temp.oipl2id, decode (opt2rt.elig_flag, 'Y'

Line 181: , round (ben_cwb_person_info_pkg.get_grd_pct_in_range ((per.base_salary + decode (temp.plsalarycomp, 'ICM7'

177: , 0))) * (temp.planufactor / per.pay_annulization_factor)) * per.pay_annulization_factor / decode (per.base_salary_frequency, 'HOURLY'
178: , 1, decode (per.fte_factor, 0
179: , to_number (NULL), per.fte_factor)), per.grd_min_val * per.grade_annulization_factor
180: , per.grd_max_val * per.grade_annulization_factor) new_decile
181: , round (ben_cwb_person_info_pkg.get_grd_pct_in_range ((per.base_salary + decode (temp.plsalarycomp, 'ICM7'
182: , plrt.ws_val, (nvl2 (temp.oipl1id, decode (opt1rt.elig_flag, 'Y'
183: , decode (temp.opt1salarycomp, 'ICM7'
184: , opt1rt.ws_val, 0), 0)
185: , 0) + nvl2 (temp.oipl2id, decode (opt2rt.elig_flag, 'Y'

Line 198: , round (ben_cwb_person_info_pkg.get_grd_comparatio ((per.base_salary + decode (temp.plsalarycomp, 'ICM7'

194: , 0))) * (temp.planufactor / per.pay_annulization_factor)) * per.pay_annulization_factor / decode (per.base_salary_frequency, 'HOURLY'
195: , 1, decode (per.fte_factor, 0
196: , to_number (NULL), per.fte_factor)), per.grd_min_val * per.grade_annulization_factor
197: , per.grd_max_val * per.grade_annulization_factor), temp.pct_decs) new_percentile
198: , round (ben_cwb_person_info_pkg.get_grd_comparatio ((per.base_salary + decode (temp.plsalarycomp, 'ICM7'
199: , plrt.ws_val, (nvl2 (temp.oipl1id, decode (opt1rt.elig_flag, 'Y'
200: , decode (temp.opt1salarycomp, 'ICM7'
201: , opt1rt.ws_val, 0), 0)
202: , 0) + nvl2 (temp.oipl2id, decode (opt2rt.elig_flag, 'Y'