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

Line 857: and fnd_number.canonical_to_number(AEI_INFORMATION13) = 100;

853: select ROWID, AEI_INFORMATION1
854: from PER_ASSIGNMENT_EXTRA_INFO
855: where assignment_id = X_assignment_id
856: and INFORMATION_TYPE = 'STATE'
857: and fnd_number.canonical_to_number(AEI_INFORMATION13) = 100;
858: --
859: -- Cursor to check Locality tax rules exists
860: --
861: CURSOR csr_check_local( P_state varchar2,

Line 1200: X_Aei_Information10 => fnd_number.number_to_canonical(l_allowances),

1196: X_Aei_Information6 => 'N',
1197: X_Aei_Information7 => 'Y',
1198: X_Aei_Information8 => '0',
1199: X_Aei_Information9 => '0',
1200: X_Aei_Information10 => fnd_number.number_to_canonical(l_allowances),
1201: X_Aei_Information11 => '0',
1202: X_Aei_Information12 => Null,
1203: X_Aei_Information13 => P_time_in_state,
1204: X_Aei_Information14 => '0',

Line 1258: WHERE STATE_CODE = fnd_number.canonical_to_number(substr(P_locality_code,1,2))

1254: --
1255: CURSOR csr_get_county_sd IS
1256: SELECT school_dst_code
1257: FROM pay_us_county_school_dsts
1258: WHERE STATE_CODE = fnd_number.canonical_to_number(substr(P_locality_code,1,2))
1259: AND COUNTY_CODE = fnd_number.canonical_to_number(substr(P_locality_code,4,3))
1260: AND p_resident_flag = 'Y'
1261: ORDER BY fnd_number.canonical_to_number(school_dst_code);
1262: --

Line 1259: AND COUNTY_CODE = fnd_number.canonical_to_number(substr(P_locality_code,4,3))

1255: CURSOR csr_get_county_sd IS
1256: SELECT school_dst_code
1257: FROM pay_us_county_school_dsts
1258: WHERE STATE_CODE = fnd_number.canonical_to_number(substr(P_locality_code,1,2))
1259: AND COUNTY_CODE = fnd_number.canonical_to_number(substr(P_locality_code,4,3))
1260: AND p_resident_flag = 'Y'
1261: ORDER BY fnd_number.canonical_to_number(school_dst_code);
1262: --
1263: CURSOR csr_get_city_sd IS

Line 1261: ORDER BY fnd_number.canonical_to_number(school_dst_code);

1257: FROM pay_us_county_school_dsts
1258: WHERE STATE_CODE = fnd_number.canonical_to_number(substr(P_locality_code,1,2))
1259: AND COUNTY_CODE = fnd_number.canonical_to_number(substr(P_locality_code,4,3))
1260: AND p_resident_flag = 'Y'
1261: ORDER BY fnd_number.canonical_to_number(school_dst_code);
1262: --
1263: CURSOR csr_get_city_sd IS
1264: SELECT school_dst_code
1265: FROM pay_us_city_school_dsts

Line 1266: WHERE STATE_CODE = fnd_number.canonical_to_number(substr(P_locality_code,1,2))

1262: --
1263: CURSOR csr_get_city_sd IS
1264: SELECT school_dst_code
1265: FROM pay_us_city_school_dsts
1266: WHERE STATE_CODE = fnd_number.canonical_to_number(substr(P_locality_code,1,2))
1267: AND COUNTY_CODE = fnd_number.canonical_to_number(substr(P_locality_code,4,3))
1268: AND CITY_CODE = fnd_number.canonical_to_number(substr(P_locality_code,8,4))
1269: AND p_resident_flag = 'Y'
1270: ORDER BY fnd_number.canonical_to_number(school_dst_code);

Line 1267: AND COUNTY_CODE = fnd_number.canonical_to_number(substr(P_locality_code,4,3))

1263: CURSOR csr_get_city_sd IS
1264: SELECT school_dst_code
1265: FROM pay_us_city_school_dsts
1266: WHERE STATE_CODE = fnd_number.canonical_to_number(substr(P_locality_code,1,2))
1267: AND COUNTY_CODE = fnd_number.canonical_to_number(substr(P_locality_code,4,3))
1268: AND CITY_CODE = fnd_number.canonical_to_number(substr(P_locality_code,8,4))
1269: AND p_resident_flag = 'Y'
1270: ORDER BY fnd_number.canonical_to_number(school_dst_code);
1271: --

Line 1268: AND CITY_CODE = fnd_number.canonical_to_number(substr(P_locality_code,8,4))

1264: SELECT school_dst_code
1265: FROM pay_us_city_school_dsts
1266: WHERE STATE_CODE = fnd_number.canonical_to_number(substr(P_locality_code,1,2))
1267: AND COUNTY_CODE = fnd_number.canonical_to_number(substr(P_locality_code,4,3))
1268: AND CITY_CODE = fnd_number.canonical_to_number(substr(P_locality_code,8,4))
1269: AND p_resident_flag = 'Y'
1270: ORDER BY fnd_number.canonical_to_number(school_dst_code);
1271: --
1272: begin

Line 1270: ORDER BY fnd_number.canonical_to_number(school_dst_code);

1266: WHERE STATE_CODE = fnd_number.canonical_to_number(substr(P_locality_code,1,2))
1267: AND COUNTY_CODE = fnd_number.canonical_to_number(substr(P_locality_code,4,3))
1268: AND CITY_CODE = fnd_number.canonical_to_number(substr(P_locality_code,8,4))
1269: AND p_resident_flag = 'Y'
1270: ORDER BY fnd_number.canonical_to_number(school_dst_code);
1271: --
1272: begin
1273: --
1274: hr_utility.set_location('pay_us_emp_tax_rules_pkg.insert_def_loc_rec',1);

Line 2136: WHERE STATE_CODE = fnd_number.canonical_to_number(substr(Jurisdiction,1,2))

2132: /* Cursor to get the the county School district */
2133: CURSOR csr_get_county_sd(Jurisdiction varchar2) IS
2134: SELECT school_dst_code
2135: FROM pay_us_county_school_dsts
2136: WHERE STATE_CODE = fnd_number.canonical_to_number(substr(Jurisdiction,1,2))
2137: AND COUNTY_CODE = fnd_number.canonical_to_number(substr(Jurisdiction,4,3))
2138: ORDER BY TO_NUMBER(school_dst_code);
2139:
2140: /* Check if county record already exists */

Line 2137: AND COUNTY_CODE = fnd_number.canonical_to_number(substr(Jurisdiction,4,3))

2133: CURSOR csr_get_county_sd(Jurisdiction varchar2) IS
2134: SELECT school_dst_code
2135: FROM pay_us_county_school_dsts
2136: WHERE STATE_CODE = fnd_number.canonical_to_number(substr(Jurisdiction,1,2))
2137: AND COUNTY_CODE = fnd_number.canonical_to_number(substr(Jurisdiction,4,3))
2138: ORDER BY TO_NUMBER(school_dst_code);
2139:
2140: /* Check if county record already exists */
2141: CURSOR csr_county_for_city is

Line 2151: where state_code = fnd_number.canonical_to_number(substr(P_jurisdiction,1,2));

2147: /* Get state abbreviation */
2148: CURSOR csr_state_abbrev is
2149: select state_abbrev
2150: from pay_us_states
2151: where state_code = fnd_number.canonical_to_number(substr(P_jurisdiction,1,2));
2152:
2153: /* Gets the county name */
2154:
2155: CURSOR csr_county_name is

Line 2158: where fnd_number.canonical_to_number(substr(P_jurisdiction, 1,2)) = state_code

2154:
2155: CURSOR csr_county_name is
2156: select county_name
2157: from pay_us_counties
2158: where fnd_number.canonical_to_number(substr(P_jurisdiction, 1,2)) = state_code
2159: and fnd_number.canonical_to_number(substr(P_jurisdiction, 4,3)) = county_code;
2160:
2161:
2162: BEGIN /* create_county_record */

Line 2159: and fnd_number.canonical_to_number(substr(P_jurisdiction, 4,3)) = county_code;

2155: CURSOR csr_county_name is
2156: select county_name
2157: from pay_us_counties
2158: where fnd_number.canonical_to_number(substr(P_jurisdiction, 1,2)) = state_code
2159: and fnd_number.canonical_to_number(substr(P_jurisdiction, 4,3)) = county_code;
2160:
2161:
2162: BEGIN /* create_county_record */
2163: