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.PAY_NO_EMP_CONT dependencies on FND_NUMBER

Line 230: l_curr_zone := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', p_jurisdiction_code, p_date_earned )) ;

226:
227: -- l_curr_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',p_jurisdiction_code),1,1));
228: -- Tax Municipality for Norway has been moved to User Table NO_TAX_MUNICIPALITY
229: -- The zone for a Tax Municipality will now be fetched from the user table
230: l_curr_zone := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', p_jurisdiction_code, p_date_earned )) ;
231:
232: l_curr_under_62 := check_under_62(p_asg_act_id,p_date_earned);
233:
234: hr_utility.trace('EMP_CONT ::: l_curr_zone = '|| l_curr_zone );

Line 464: l_zone := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', l_zone_temp, p_date_earned )) ;

460:
461: -- l_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',l_zone_temp),1,1));
462: -- Tax Municipality for Norway has been moved to User Table NO_TAX_MUNICIPALITY
463: -- The zone for a Tax Municipality will now be fetched from the user table
464: l_zone := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', l_zone_temp, p_date_earned )) ;
465:
466: hr_utility.trace('EMP_CONT ::: LU ***** l_zone = '|| l_zone );
467:
468: l_cell := lookup_cell(g_tab_calc,'Y',l_zone);

Line 553: l_zone := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', l_zone_temp, p_date_earned )) ;

549:
550: -- l_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',l_zone_temp),1,1));
551: -- Tax Municipality for Norway has been moved to User Table NO_TAX_MUNICIPALITY
552: -- The zone for a Tax Municipality will now be fetched from the user table
553: l_zone := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', l_zone_temp, p_date_earned )) ;
554:
555: hr_utility.trace('EMP_CONT ::: LU ***** l_zone = '|| l_zone );
556:
557: l_cell := lookup_cell(g_tab_calc,'Y',l_zone);

Line 634: l_normal_rate := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, l_table_name, l_col_name, l_zone_value, p_date_earned ));

630:
631: hr_utility.trace('EMP_CONT ::: LU ***** exemption limit check ----------------------------' );
632:
633: l_zone_value := g_tab_calc(i).zone;
634: l_normal_rate := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, l_table_name, l_col_name, l_zone_value, p_date_earned ));
635: l_diff_rate := l_high_rate - l_normal_rate ;
636:
637:
638: /* BUG Fix 5378539 : Start */

Line 1033: l_zone := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', l_zone_temp, p_date_earned )) ;

1029:
1030: -- l_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',l_zone_temp),1,1));
1031: -- Tax Municipality for Norway has been moved to User Table NO_TAX_MUNICIPALITY
1032: -- The zone for a Tax Municipality will now be fetched from the user table
1033: l_zone := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', l_zone_temp, p_date_earned )) ;
1034:
1035: hr_utility.trace('EMP_CONT ::: LE #### l_zone = '|| l_zone );
1036:
1037: l_cell := lookup_cell(g_tab_calc,'Y',l_zone);

Line 1136: l_zone := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', p_jurisdiction_code, p_date_earned )) ;

1132:
1133: -- l_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',l_zone_temp),1,1));
1134: -- Tax Municipality for Norway has been moved to User Table NO_TAX_MUNICIPALITY
1135: -- The zone for a Tax Municipality will now be fetched from the user table
1136: l_zone := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', p_jurisdiction_code, p_date_earned )) ;
1137:
1138: hr_utility.trace('EMP_CONT ::: LE #### l_zone = '|| l_zone );
1139:
1140: l_cell := lookup_cell(g_tab_calc,'Y',l_zone);

Line 1220: l_normal_rate := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, l_table_name, l_col_name, l_zone_value, p_date_earned ));

1216:
1217: hr_utility.trace('EMP_CONT ::: LE #### exemption limit check ----------------------' );
1218:
1219: l_zone_value := to_char(g_tab_calc(i).zone);
1220: l_normal_rate := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, l_table_name, l_col_name, l_zone_value, p_date_earned ));
1221: l_diff_rate := l_high_rate - l_normal_rate ;
1222:
1223: /* BUG Fix 5378539 : Start */
1224:

Line 1940: l_ec_rate := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, l_table_name, l_col_name, l_zone_value, p_date_earned ));

1936:
1937: ELSE l_col_name := 'Over Age Percentage';
1938: END IF;
1939:
1940: l_ec_rate := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, l_table_name, l_col_name, l_zone_value, p_date_earned ));
1941:
1942: ELSIF p_org_status = 'OU' -------------------------------------
1943: THEN
1944: -- Transition rates apply for status OU

Line 1950: l_ec_rate := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, l_table_name, l_col_name, l_zone_value, p_date_earned ));

1946: THEN l_col_name := 'Transition Under Age Percentage';
1947: ELSE l_col_name := 'Transition Over Age Percentage';
1948: END IF;
1949:
1950: l_ec_rate := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, l_table_name, l_col_name, l_zone_value, p_date_earned ));
1951:
1952: ELSIF p_org_status = 'OF' -------------------------------------
1953: THEN
1954: -- Transition rate apply above limit, Normal rates apply below limit for status OF

Line 1965: l_ec_rate := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, l_table_name, l_col_name, l_zone_value, p_date_earned ));

1961: ELSIF (p_under_limit = 'N') and (p_under_62 = 'Y') THEN l_col_name := 'Transition Under Age Percentage';
1962: ELSIF (p_under_limit = 'N') and (p_under_62 = 'N') THEN l_col_name := 'Transition Over Age Percentage';
1963: END IF;
1964:
1965: l_ec_rate := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, l_table_name, l_col_name, l_zone_value, p_date_earned ));
1966:
1967: ELSIF p_org_status = 'HF' -------------------------------------
1968: THEN
1969: -- High rate apply above limit, Normal rates apply below limit for status HF

Line 1981: l_ec_rate := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, l_table_name, l_col_name, l_zone_value, p_date_earned ));

1977: THEN l_col_name := 'NIS Rates';
1978: ELSE l_col_name := 'Over Age Percentage';
1979: END IF;
1980:
1981: l_ec_rate := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, l_table_name, l_col_name, l_zone_value, p_date_earned ));
1982: ----------------------
1983: ELSE ---------------------
1984: IF p_under_62 = 'Y'
1985: THEN l_ec_rate := p_under_age_high_rate;

Line 2090: , fnd_number.canonical_to_number(global_value) VALUE

2086:
2087: cursor csr_get_ni_base_rates (p_date_earned date ) IS
2088: select EFFECTIVE_START_DATE
2089: , EFFECTIVE_END_DATE
2090: , fnd_number.canonical_to_number(global_value) VALUE
2091: from ff_globals_f
2092: where legislation_code = 'NO'
2093: and global_name = 'NO_NATIONAL_INSURANCE_BASE_RATE'
2094: and BUSINESS_GROUP_ID IS NULL

Line 2430: l_curr_zone := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', p_jurisdiction_code, p_date_earned )) ;

2426:
2427: -- l_curr_zone := to_number(SUBSTR(pay_no_emp_cont.get_lookup_meaning('NO_TAX_MUNICIPALITY', p_jurisdiction_code), 1, 1));
2428: -- Tax Municipality for Norway has been moved to User Table NO_TAX_MUNICIPALITY
2429: -- The zone for a Tax Municipality will now be fetched from the user table
2430: l_curr_zone := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', p_jurisdiction_code, p_date_earned )) ;
2431:
2432: l_curr_under_62 := pay_no_emp_cont.check_under_62(p_asg_act_id, p_date_earned);
2433:
2434: l_ec_rate := pay_no_emp_cont.get_ec_rate(l_curr_under_62, l_curr_zone, p_under_limit, l_org_status, p_bus_group_id, p_date_earned, p_under_age_high_rate, p_over_age_high_rate);