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_DATA_MODEL_UPGRADE dependencies on FND_NUMBER

Line 951: select fnd_number.canonical_to_number(minimum) into l_grd_min_val

947: --
948: l_grd_min_val number;
949: --
950: begin
951: select fnd_number.canonical_to_number(minimum) into l_grd_min_val
952: from pay_grade_rules_f grdrule
953: where grdrule.rate_id = p_rate_id
954: and grdrule.grade_or_spinal_point_id = p_grade_id
955: and p_effective_date between grdrule.effective_start_date

Line 969: select fnd_number.canonical_to_number(maximum) into l_grd_max_val

965: --
966: l_grd_max_val number;
967: --
968: begin
969: select fnd_number.canonical_to_number(maximum) into l_grd_max_val
970: from pay_grade_rules_f grdrule
971: where grdrule.rate_id = p_rate_id
972: and grdrule.grade_or_spinal_point_id = p_grade_id
973: and p_effective_date between grdrule.effective_start_date

Line 987: select fnd_number.canonical_to_number(mid_value) into l_grd_mid_point

983: --
984: l_grd_mid_point number;
985: --
986: begin
987: select fnd_number.canonical_to_number(mid_value) into l_grd_mid_point
988: from pay_grade_rules_f grdrule
989: where grdrule.rate_id = p_rate_id
990: and grdrule.grade_or_spinal_point_id = p_grade_id
991: and p_effective_date between grdrule.effective_start_date