DBA Data[Home] [Help]

APPS.BEN_CWB_WEBADI_UTILS dependencies on PAY_GRADE_RULES_F

Line 3383: ,pay_grade_rules_f pgr

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
3387: and atxn.transaction_id = per.assignment_id