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_PERSON_RATES

Line 2886: ,ben_cwb_person_rates rates

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
2890: and grp_pl.oipl_id = -1

Line 2904: ,ben_cwb_person_rates plRt

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
2908: and plRt.pl_id = pl.pl_id

Line 2921: ,ben_cwb_person_rates plRt

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
2925: and plRt.pl_id = pl.pl_id

Line 2939: ,ben_cwb_person_rates optRt

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
2943: and optRt.pl_id = pl.pl_id

Line 2955: l_group_per_in_ler_id BEN_CWB_PERSON_RATES.GROUP_PER_IN_LER_ID%Type;

2951: l_opt1_person_rate_id Number := null;
2952: l_opt2_person_rate_id Number := null;
2953: l_opt3_person_rate_id Number := null;
2954: l_opt4_person_rate_id Number := null;
2955: l_group_per_in_ler_id BEN_CWB_PERSON_RATES.GROUP_PER_IN_LER_ID%Type;
2956: l_pl_ws_val Number := 0;
2957: l_opt1_ws_val Number := 0;
2958: l_opt2_ws_val Number := 0;
2959: l_opt3_ws_val Number := 0;

Line 3106: ,ben_cwb_person_rates plRt

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
3110: and plRt.pl_id = pl.pl_id

Line 3123: ,ben_cwb_person_rates plRt

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
3127: and plRt.pl_id = pl.pl_id

Line 3141: ,ben_cwb_person_rates optRt

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
3145: and optRt.pl_id = pl.pl_id

Line 3157: l_group_per_in_ler_id BEN_CWB_PERSON_RATES.GROUP_PER_IN_LER_ID%Type;

3153: l_opt1_person_rate_id Number := null;
3154: l_opt2_person_rate_id Number := null;
3155: l_opt3_person_rate_id Number := null;
3156: l_opt4_person_rate_id Number := null;
3157: l_group_per_in_ler_id BEN_CWB_PERSON_RATES.GROUP_PER_IN_LER_ID%Type;
3158: l_pl_ws_val Number := 0;
3159: l_opt1_ws_val Number := 0;
3160: l_opt2_ws_val Number := 0;
3161: l_opt3_ws_val Number := 0;

Line 3274: ,ben_cwb_person_rates plRt

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
3278: and plRt.pl_id = pl.pl_id

Line 3291: ,ben_cwb_person_rates plRt

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
3295: and plRt.pl_id = pl.pl_id

Line 3305: ,ben_cwb_person_rates optRt

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
3309: and optRt.pl_id = pl.pl_id

Line 3445: from ben_cwb_person_rates

3441: IS
3442: Cursor csr_group_per_in_ler_id (l_person_rate_id IN Number)
3443: IS
3444: Select group_per_in_ler_id
3445: from ben_cwb_person_rates
3446: where person_rate_id = l_person_rate_id;
3447:
3448: l_proc Varchar2(72) := g_package||'get_group_per_in_ler_id';
3449: l_rate_id Number;