eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CWB_CD_SUMMARY_PKG dependencies on BEN_CWB_PERSON_INFO

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'

Line 734: FROM ben_cwb_person_info bcpi

730: ) change_reason
731: ,
732: (
733: SELECT bcpi.full_name
734: FROM ben_cwb_person_info bcpi
735: , ben_cwb_group_hrchy bcgh
736: WHERE bcgh.emp_per_in_ler_id = per.group_per_in_ler_id
737: AND bcgh.lvl_num =
738: (

Line 749: FROM ben_cwb_person_info bcpi

745: ) level1mgr
746: ,
747: (
748: SELECT bcpi.full_name
749: FROM ben_cwb_person_info bcpi
750: , ben_cwb_group_hrchy bcgh
751: WHERE bcgh.emp_per_in_ler_id = per.group_per_in_ler_id
752: AND bcgh.lvl_num =
753: (

Line 764: FROM ben_cwb_person_info bcpi

760: ) level2mgr
761: ,
762: (
763: SELECT bcpi.full_name
764: FROM ben_cwb_person_info bcpi
765: , ben_cwb_group_hrchy bcgh
766: WHERE bcgh.emp_per_in_ler_id = per.group_per_in_ler_id
767: AND bcgh.lvl_num =
768: (

Line 779: FROM ben_cwb_person_info bcpi

775: ) level3mgr
776: ,
777: (
778: SELECT bcpi.full_name
779: FROM ben_cwb_person_info bcpi
780: , ben_cwb_group_hrchy bcgh
781: WHERE bcgh.emp_per_in_ler_id = per.group_per_in_ler_id
782: AND bcgh.lvl_num =
783: (

Line 794: FROM ben_cwb_person_info bcpi

790: ) level4mgr
791: ,
792: (
793: SELECT bcpi.full_name
794: FROM ben_cwb_person_info bcpi
795: , ben_cwb_group_hrchy bcgh
796: WHERE bcgh.emp_per_in_ler_id = per.group_per_in_ler_id
797: AND bcgh.lvl_num =
798: (

Line 809: FROM ben_cwb_person_info bcpi

805: ) level5mgr
806: ,
807: (
808: SELECT bcpi.full_name
809: FROM ben_cwb_person_info bcpi
810: , ben_cwb_group_hrchy bcgh
811: WHERE bcgh.emp_per_in_ler_id = per.group_per_in_ler_id
812: AND bcgh.lvl_num =
813: (

Line 824: FROM ben_cwb_person_info bcpi

820: ) level6mgr
821: ,
822: (
823: SELECT bcpi.full_name
824: FROM ben_cwb_person_info bcpi
825: , ben_cwb_group_hrchy bcgh
826: WHERE bcgh.emp_per_in_ler_id = per.group_per_in_ler_id
827: AND bcgh.lvl_num =
828: (

Line 839: FROM ben_cwb_person_info bcpi

835: ) level7mgr
836: ,
837: (
838: SELECT bcpi.full_name
839: FROM ben_cwb_person_info bcpi
840: , ben_cwb_group_hrchy bcgh
841: WHERE bcgh.emp_per_in_ler_id = per.group_per_in_ler_id
842: AND bcgh.lvl_num =
843: (

Line 863: , ben_cwb_person_info mgrper

859: SELECT decode (temp.name_profile, 'BN'
860: , mgrper.brief_name, 'CN'
861: , mgrper.custom_name, mgrper.full_name)
862: FROM ben_cwb_group_hrchy hrchy1
863: , ben_cwb_person_info mgrper
864: WHERE hrchy1.emp_per_in_ler_id = per.group_per_in_ler_id
865: AND hrchy1.lvl_num = 1
866: AND hrchy1.mgr_per_in_ler_id = mgrper.group_per_in_ler_id
867: ) wrk_mgr_name

Line 883: , ben_cwb_person_info per

879: , ben_cwb_xchg opt2xchg
880: , ben_cwb_xchg opt3xchg
881: , ben_cwb_xchg opt4xchg
882: , ben_per_in_ler pil
883: , ben_cwb_person_info per
884: , per_assignment_status_types_tl asttl
885: , hr_all_organization_units_tl bgtl
886: , hr_all_organization_units_tl orgtl
887: , hr_locations_all_tl loctl