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_WEBADI_UTILS dependencies on BEN_CWB_PL_DSGN

Line 360: from ben_cwb_pl_dsgn

356: ,max(ws_abr_id) ws_abr_id
357: ,max(elig_sal_abr_id) elig_sal_abr_id
358: ,max(ws_nnmntry_uom) ws_nnmntry_uom
359: ,null ws_sub_acty_typ_cd
360: from ben_cwb_pl_dsgn
361: where group_pl_id = p_group_pl_id
362: and group_pl_id = pl_id
363: and group_oipl_id = oipl_id
364: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt

Line 374: from ben_cwb_pl_dsgn

370: ,max(ws_abr_id) ws_abr_id
371: ,max(elig_sal_abr_id) elig_sal_abr_id
372: ,max(ws_nnmntry_uom) ws_nnmntry_uom
373: ,null ws_sub_acty_typ_cd
374: from ben_cwb_pl_dsgn
375: where group_pl_id = p_group_pl_id
376: and group_pl_id = pl_id
377: and group_oipl_id <> oipl_id
378: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt

Line 388: from ben_cwb_pl_dsgn

384: ,max(ws_abr_id) ws_abr_id
385: ,max(elig_sal_abr_id) elig_sal_abr_id
386: ,max(ws_nnmntry_uom) ws_nnmntry_uom
387: ,null ws_sub_acty_typ_cd
388: from ben_cwb_pl_dsgn
389: where group_pl_id = p_group_pl_id
390: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
391: and group_oipl_id <> -1
392: and oipl_ordr_num = 1;

Line 401: from ben_cwb_pl_dsgn

397: ,max(ws_abr_id) ws_abr_id
398: ,max(elig_sal_abr_id) elig_sal_abr_id
399: ,max(ws_nnmntry_uom) ws_nnmntry_uom
400: ,null ws_sub_acty_typ_cd
401: from ben_cwb_pl_dsgn
402: where group_pl_id = p_group_pl_id
403: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
404: and group_oipl_id <> -1
405: and oipl_ordr_num = 2;

Line 414: from ben_cwb_pl_dsgn

410: ,max(ws_abr_id) ws_abr_id
411: ,max(elig_sal_abr_id) elig_sal_abr_id
412: ,max(ws_nnmntry_uom) ws_nnmntry_uom
413: ,null ws_sub_acty_typ_cd
414: from ben_cwb_pl_dsgn
415: where group_pl_id = p_group_pl_id
416: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
417: and group_oipl_id <> -1
418: and oipl_ordr_num = 3;

Line 427: from ben_cwb_pl_dsgn

423: ,max(ws_abr_id) ws_abr_id
424: ,max(elig_sal_abr_id) elig_sal_abr_id
425: ,max(ws_nnmntry_uom) ws_nnmntry_uom
426: ,null ws_sub_acty_typ_cd
427: from ben_cwb_pl_dsgn
428: where group_pl_id = p_group_pl_id
429: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
430: and group_oipl_id <> -1
431: and oipl_ordr_num = 4;

Line 440: from ben_cwb_pl_dsgn

436: ,max(ws_abr_id) ws_abr_id
437: ,max(elig_sal_abr_id) elig_sal_abr_id
438: ,max(ws_nnmntry_uom) ws_nnmntry_uom
439: ,max(ws_sub_acty_typ_cd) ws_sub_acty_typ_cd
440: from ben_cwb_pl_dsgn
441: where group_pl_id = p_group_pl_id
442: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
443: and group_pl_id <> pl_id
444: and group_oipl_id = -1

Line 454: from ben_cwb_pl_dsgn

450: ,max(ws_abr_id) ws_abr_id
451: ,max(elig_sal_abr_id) elig_sal_abr_id
452: ,max(ws_nnmntry_uom) ws_nnmntry_uom
453: ,max(ws_sub_acty_typ_cd) ws_sub_acty_typ_cd
454: from ben_cwb_pl_dsgn
455: where group_pl_id = p_group_pl_id
456: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
457: and group_pl_id = pl_id
458: and group_oipl_id = -1

Line 782: from ben_cwb_pl_dsgn

778: And SEQUENCE_NUM = p_inf_seq;
779:
780: cursor csr_asg_updt_date is
781: select '1'
782: from ben_cwb_pl_dsgn
783: where pl_id = p_group_pl_id
784: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
785: and asg_updt_eff_date is not null;
786:

Line 2884: ben_cwb_pl_dsgn grp_pl

2880: cursor c_plan_validation ( l_group_per_in_ler_id number) is
2881: select
2882: nvl(lcl_pl.grade_range_validation,grp_pl.grade_range_validation) grade_range_validation
2883: from
2884: ben_cwb_pl_dsgn grp_pl
2885: ,ben_cwb_pl_dsgn lcl_pl
2886: ,ben_cwb_person_rates rates
2887: where rates.group_per_in_ler_id = l_group_per_in_ler_id
2888: and rates.group_pl_id = grp_pl.pl_id

Line 2885: ,ben_cwb_pl_dsgn lcl_pl

2881: select
2882: nvl(lcl_pl.grade_range_validation,grp_pl.grade_range_validation) grade_range_validation
2883: from
2884: ben_cwb_pl_dsgn grp_pl
2885: ,ben_cwb_pl_dsgn lcl_pl
2886: ,ben_cwb_person_rates rates
2887: where rates.group_per_in_ler_id = l_group_per_in_ler_id
2888: and rates.group_pl_id = grp_pl.pl_id
2889: and rates.lf_evt_ocrd_dt = grp_pl.lf_evt_ocrd_dt

Line 2903: ben_cwb_pl_dsgn pl

2899: decode(l_ws_val,'-0.0000000000000001',plRt.ws_val,l_ws_val) ws_val,
2900: (per.grd_min_val*per.grade_annulization_factor/pl.pl_annulization_factor) grd_min,
2901: (per.grd_max_val*per.grade_annulization_factor/pl.pl_annulization_factor) grd_max
2902: from
2903: ben_cwb_pl_dsgn pl
2904: ,ben_cwb_person_rates plRt
2905: ,ben_cwb_person_info per
2906: where plRt.group_per_in_ler_id = l_group_per_in_ler_id
2907: and plRt.group_per_in_ler_id = per.group_per_in_ler_id

Line 2920: ben_cwb_pl_dsgn pl

2916: (per.base_salary*per.pay_annulization_factor/pl.pl_annulization_factor) base_salary,
2917: (per.grd_min_val*per.grade_annulization_factor/pl.pl_annulization_factor) grd_min,
2918: (per.grd_max_val*per.grade_annulization_factor/pl.pl_annulization_factor) grd_max
2919: from
2920: ben_cwb_pl_dsgn pl
2921: ,ben_cwb_person_rates plRt
2922: ,ben_cwb_person_info per
2923: where plRt.group_per_in_ler_id = l_group_per_in_ler_id
2924: and plRt.group_per_in_ler_id = per.group_per_in_ler_id

Line 2938: ben_cwb_pl_dsgn pl

2934: (per.grd_min_val*per.grade_annulization_factor/pl.pl_annulization_factor) grd_min,
2935: (per.grd_max_val*per.grade_annulization_factor/pl.pl_annulization_factor) grd_max,
2936: per.group_per_in_ler_id
2937: from
2938: ben_cwb_pl_dsgn pl
2939: ,ben_cwb_person_rates optRt
2940: ,ben_cwb_person_info per
2941: where optRt.person_rate_id = l_rate_id
2942: and optRt.group_per_in_ler_id = per.group_per_in_ler_id

Line 3105: ben_cwb_pl_dsgn pl

3101: decode(l_ws_val,'-0.0000000000000001',plRt.ws_val,l_ws_val) ws_val,
3102: (per.grd_min_val*per.grade_annulization_factor/pl.pl_annulization_factor) grd_min,
3103: (per.grd_max_val*per.grade_annulization_factor/pl.pl_annulization_factor) grd_max
3104: from
3105: ben_cwb_pl_dsgn pl
3106: ,ben_cwb_person_rates plRt
3107: ,ben_cwb_person_info per
3108: where plRt.group_per_in_ler_id = l_group_per_in_ler_id
3109: and plRt.group_per_in_ler_id = per.group_per_in_ler_id

Line 3122: ben_cwb_pl_dsgn pl

3118: (per.base_salary*per.pay_annulization_factor/pl.pl_annulization_factor) base_salary,
3119: (per.grd_min_val*per.grade_annulization_factor/pl.pl_annulization_factor) grd_min,
3120: (per.grd_max_val*per.grade_annulization_factor/pl.pl_annulization_factor) grd_max
3121: from
3122: ben_cwb_pl_dsgn pl
3123: ,ben_cwb_person_rates plRt
3124: ,ben_cwb_person_info per
3125: where plRt.group_per_in_ler_id = l_group_per_in_ler_id
3126: and plRt.group_per_in_ler_id = per.group_per_in_ler_id

Line 3140: ben_cwb_pl_dsgn pl

3136: (per.grd_min_val*per.grade_annulization_factor/pl.pl_annulization_factor) grd_min,
3137: (per.grd_max_val*per.grade_annulization_factor/pl.pl_annulization_factor) grd_max,
3138: per.group_per_in_ler_id
3139: from
3140: ben_cwb_pl_dsgn pl
3141: ,ben_cwb_person_rates optRt
3142: ,ben_cwb_person_info per
3143: where optRt.person_rate_id = l_rate_id
3144: and optRt.group_per_in_ler_id = per.group_per_in_ler_id

Line 3273: ben_cwb_pl_dsgn pl

3269: cursor c_plan_salary is
3270: select
3271: nvl(plRt.ws_val,0) ws_val
3272: from
3273: ben_cwb_pl_dsgn pl
3274: ,ben_cwb_person_rates plRt
3275: ,ben_cwb_person_info per
3276: where plRt.group_per_in_ler_id = p_group_per_in_ler_id
3277: and plRt.group_per_in_ler_id = per.group_per_in_ler_id

Line 3290: ben_cwb_pl_dsgn pl

3286: (per.base_salary*per.pay_annulization_factor/pl.pl_annulization_factor) base_salary,
3287: (per.grd_min_val*per.grade_annulization_factor/pl.pl_annulization_factor) grd_min,
3288: (per.grd_max_val*per.grade_annulization_factor/pl.pl_annulization_factor) grd_max
3289: from
3290: ben_cwb_pl_dsgn pl
3291: ,ben_cwb_person_rates plRt
3292: ,ben_cwb_person_info per
3293: where plRt.group_per_in_ler_id = p_group_per_in_ler_id
3294: and plRt.group_per_in_ler_id = per.group_per_in_ler_id

Line 3304: ben_cwb_pl_dsgn pl

3300: cursor c_option_salary ( l_oipl_ordr_num number) is
3301: select
3302: nvl(optRt.ws_val,0) ws_val
3303: from
3304: ben_cwb_pl_dsgn pl
3305: ,ben_cwb_person_rates optRt
3306: ,ben_cwb_person_info per
3307: where optRt.group_per_in_ler_id = p_group_per_in_ler_id
3308: and optRt.group_per_in_ler_id = per.group_per_in_ler_id

Line 3382: from ben_cwb_pl_dsgn pl

3378: ,nvl(per.grade_annulization_factor/pl.pl_annulization_factor,1)*fnd_number.canonical_to_number(pgr.minimum)
3379: || ' - ' || nvl(per.grade_annulization_factor/pl.pl_annulization_factor,1)*fnd_number.canonical_to_number(pgr.maximum) proposed_grade_range
3380: ,nvl(per.grade_annulization_factor/pl.pl_annulization_factor,1)*fnd_number.canonical_to_number(pgr.mid_value) proposed_grade_mid
3381: ,get_new_salary(p_group_per_in_ler_id) * 100 / (nvl(per.grade_annulization_factor/pl.pl_annulization_factor,1)*fnd_number.canonical_to_number(pgr.mid_value)) proposed_grade_comparatio
3382: from ben_cwb_pl_dsgn pl
3383: ,pay_grade_rules_f pgr
3384: ,ben_transaction atxn
3385: ,ben_cwb_person_info per
3386: WHERE per.group_per_in_ler_id = p_group_per_in_ler_id