[Home] [Help]
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
2909: and plRt.lf_evt_ocrd_dt = pl.lf_evt_ocrd_dt
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
2926: and plRt.lf_evt_ocrd_dt = pl.lf_evt_ocrd_dt
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
2944: and optRt.lf_evt_ocrd_dt = pl.lf_evt_ocrd_dt
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
3111: and plRt.lf_evt_ocrd_dt = pl.lf_evt_ocrd_dt
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
3128: and plRt.lf_evt_ocrd_dt = pl.lf_evt_ocrd_dt
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
3146: and optRt.lf_evt_ocrd_dt = pl.lf_evt_ocrd_dt
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
3279: and plRt.lf_evt_ocrd_dt = pl.lf_evt_ocrd_dt
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
3296: and plRt.lf_evt_ocrd_dt = pl.lf_evt_ocrd_dt
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
3310: and optRt.lf_evt_ocrd_dt = pl.lf_evt_ocrd_dt
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
3387: and atxn.transaction_id = per.assignment_id
3388: AND atxn.transaction_type = 'CWBASG' || p_asg_updt_eff_date
3389: AND TO_NUMBER (atxn.attribute7) = pgr.grade_or_spinal_point_id