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 FND_NUMBER

Line 3378: ,nvl(per.grade_annulization_factor/pl.pl_annulization_factor,1)*fnd_number.canonical_to_number(pgr.minimum)

3374: ) IS
3375:
3376: CURSOR c_proposed_grade is
3377: select per.group_per_in_ler_id
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

Line 3379: || ' - ' || nvl(per.grade_annulization_factor/pl.pl_annulization_factor,1)*fnd_number.canonical_to_number(pgr.maximum) proposed_grade_range

3375:
3376: CURSOR c_proposed_grade is
3377: select per.group_per_in_ler_id
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

Line 3380: ,nvl(per.grade_annulization_factor/pl.pl_annulization_factor,1)*fnd_number.canonical_to_number(pgr.mid_value) proposed_grade_mid

3376: CURSOR c_proposed_grade is
3377: select per.group_per_in_ler_id
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

Line 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

3377: select per.group_per_in_ler_id
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