[Home] [Help]
21: 23-Jan-02 fusman 115.0 created
22: 14-may-02 fusman 115.1 Added Get_Hours_Worked function.
23: 10-Jun-02 fusman 115.2 2404709 Removed the padding in NH hours calc.
24: 11-Nov-02 ppanda 115.3 For Rita/CCA city code in
25: pay_us_city_tax_info_f.city_information1
26: starts from 6 char position. This changes
27: made to generalised the Local Mag Tape
28: 02-Dec-02 ppanda 115.4 Nocopy hint added to OUT and IN OUT parameters
29: 19-FEB-03 sodhingr 115.5 Changed Get_hours_worked for bug
94: CURSOR GET_CITY_CODE(c_jurisdiction_code varchar2,
95: c_date varchar2)
96: IS
97: /* City code starts from 5 instead of 4 in city_information1 column in
98: pay_us_city_tax_info_f table. This changes made to generalise the Local Mag Tape */
99: SELECT substr(city_information1,1,5),
100: substr(city_information1,6)
101: FROM pay_us_city_tax_info_f
102: WHERE to_date(c_date,'dd-mm-yyyy') between effective_start_date
97: /* City code starts from 5 instead of 4 in city_information1 column in
98: pay_us_city_tax_info_f table. This changes made to generalise the Local Mag Tape */
99: SELECT substr(city_information1,1,5),
100: substr(city_information1,6)
101: FROM pay_us_city_tax_info_f
102: WHERE to_date(c_date,'dd-mm-yyyy') between effective_start_date
103: and effective_end_date
104: AND jurisdiction_code = c_jurisdiction_code;
105:
138:
139: hr_utility.trace('No city information found for jurisdiction code = '||p_jurisdiction_code);
140: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
141: pay_core_utils.push_token('record_name','jurisdiction '||p_jurisdiction_code
142: ||' in '||'pay_us_city_tax_info_f');
143: pay_core_utils.push_token('description','City tax infm not found.');
144:
145: sp_out_1 := ' ';
146: sp_out_2 := ' ';