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_GET_TAX_EXISTS_PKG dependencies on HR_UTILITY

Line 80: hr_utility.set_location('pay_get_tax_exists_pkg.assignment_tax_exists', 210);

76: AND TO_DATE(l_change_date, 'DD-MM-YYYY') BETWEEN
77: pest.effective_start_date AND pest.effective_end_date;
78:
79: BEGIN
80: hr_utility.set_location('pay_get_tax_exists_pkg.assignment_tax_exists', 210);
81: hr_utility.trace('The date earned is : ' || p_date_earned);
82: hr_utility.trace('The assign id is : ' || TO_CHAR(p_assign_id));
83: hr_utility.trace('The jurisdiction code is : ' || p_jurisdiction_code);
84:

Line 81: hr_utility.trace('The date earned is : ' || p_date_earned);

77: pest.effective_start_date AND pest.effective_end_date;
78:
79: BEGIN
80: hr_utility.set_location('pay_get_tax_exists_pkg.assignment_tax_exists', 210);
81: hr_utility.trace('The date earned is : ' || p_date_earned);
82: hr_utility.trace('The assign id is : ' || TO_CHAR(p_assign_id));
83: hr_utility.trace('The jurisdiction code is : ' || p_jurisdiction_code);
84:
85: l_change_date := TO_CHAR(p_date_earned, 'dd-mm-yyyy');

Line 82: hr_utility.trace('The assign id is : ' || TO_CHAR(p_assign_id));

78:
79: BEGIN
80: hr_utility.set_location('pay_get_tax_exists_pkg.assignment_tax_exists', 210);
81: hr_utility.trace('The date earned is : ' || p_date_earned);
82: hr_utility.trace('The assign id is : ' || TO_CHAR(p_assign_id));
83: hr_utility.trace('The jurisdiction code is : ' || p_jurisdiction_code);
84:
85: l_change_date := TO_CHAR(p_date_earned, 'dd-mm-yyyy');
86:

Line 83: hr_utility.trace('The jurisdiction code is : ' || p_jurisdiction_code);

79: BEGIN
80: hr_utility.set_location('pay_get_tax_exists_pkg.assignment_tax_exists', 210);
81: hr_utility.trace('The date earned is : ' || p_date_earned);
82: hr_utility.trace('The assign id is : ' || TO_CHAR(p_assign_id));
83: hr_utility.trace('The jurisdiction code is : ' || p_jurisdiction_code);
84:
85: l_change_date := TO_CHAR(p_date_earned, 'dd-mm-yyyy');
86:
87: hr_utility.trace('The change date earned is : ' || SUBSTR(l_change_date, 7));

Line 87: hr_utility.trace('The change date earned is : ' || SUBSTR(l_change_date, 7));

83: hr_utility.trace('The jurisdiction code is : ' || p_jurisdiction_code);
84:
85: l_change_date := TO_CHAR(p_date_earned, 'dd-mm-yyyy');
86:
87: hr_utility.trace('The change date earned is : ' || SUBSTR(l_change_date, 7));
88: hr_utility.trace('The tax type passed is : ' || p_tax_type);
89:
90: IF p_tax_type = 'SDI' THEN
91:

Line 88: hr_utility.trace('The tax type passed is : ' || p_tax_type);

84:
85: l_change_date := TO_CHAR(p_date_earned, 'dd-mm-yyyy');
86:
87: hr_utility.trace('The change date earned is : ' || SUBSTR(l_change_date, 7));
88: hr_utility.trace('The tax type passed is : ' || p_tax_type);
89:
90: IF p_tax_type = 'SDI' THEN
91:
92: OPEN sdi_exempt;

Line 100: hr_utility.trace('SDI Exempt : ' || l_sdi);

96: l_sdi := 'N';
97: END IF;
98: CLOSE sdi_exempt;
99:
100: hr_utility.trace('SDI Exempt : ' || l_sdi);
101:
102: RETURN(l_sdi);
103:
104: ELSIF p_tax_type = 'SUI' THEN

Line 114: hr_utility.trace('SUI Exempt : ' || l_sui);

110: l_sui := 'N';
111: END IF;
112: CLOSE sui_exempt;
113:
114: hr_utility.trace('SUI Exempt : ' || l_sui);
115:
116: RETURN(l_sui);
117:
118: ELSIF p_tax_type = 'FUTA' THEN

Line 128: hr_utility.trace('FUTA Exempt : ' || l_futa);

124: l_futa := 'N';
125: END IF;
126: CLOSE futa_exempt;
127:
128: hr_utility.trace('FUTA Exempt : ' || l_futa);
129:
130: RETURN(l_futa);
131:
132: ELSIF p_tax_type = 'FICA' THEN

Line 142: hr_utility.trace('FICA Exempt : ' || l_fica);

138: l_fica := 'N';
139: END IF;
140: CLOSE fica_exempt;
141:
142: hr_utility.trace('FICA Exempt : ' || l_fica);
143:
144: RETURN(l_fica);
145:
146: ELSIF p_tax_type = 'MEDICARE' THEN

Line 156: hr_utility.trace('MEDI Exempt : ' || l_medi);

152: l_medi := 'N';
153: END IF;
154: CLOSE medi_exempt;
155:
156: hr_utility.trace('MEDI Exempt : ' || l_medi);
157:
158: RETURN(l_medi);
159:
160: END IF;

Line 196: -- hr_utility.trace_on(null,'TAXEXIST');

192: /*
193: * check to see if there is an override if there is then we do not check
194: * for 1st Jan else see if the default county is valid as of 1st Jan.
195: */
196: -- hr_utility.trace_on(null,'TAXEXIST');
197: hr_utility.trace('5000 START of function GET_RESIDENCE_AS_OF_1ST_JAN ');
198:
199: OPEN c_override_state_county;
200: FETCH c_override_state_county

Line 197: hr_utility.trace('5000 START of function GET_RESIDENCE_AS_OF_1ST_JAN ');

193: * check to see if there is an override if there is then we do not check
194: * for 1st Jan else see if the default county is valid as of 1st Jan.
195: */
196: -- hr_utility.trace_on(null,'TAXEXIST');
197: hr_utility.trace('5000 START of function GET_RESIDENCE_AS_OF_1ST_JAN ');
198:
199: OPEN c_override_state_county;
200: FETCH c_override_state_county
201: INTO l_rs_county_code;

Line 202: hr_utility.trace('5010 OVERRIDE County Code : '||l_rs_county_code);

198:
199: OPEN c_override_state_county;
200: FETCH c_override_state_county
201: INTO l_rs_county_code;
202: hr_utility.trace('5010 OVERRIDE County Code : '||l_rs_county_code);
203: IF c_override_state_county%NOTFOUND THEN
204: hr_utility.trace('5020 OVERRIDE County Code NOT found ');
205: /*{*/
206: /*

Line 204: hr_utility.trace('5020 OVERRIDE County Code NOT found ');

200: FETCH c_override_state_county
201: INTO l_rs_county_code;
202: hr_utility.trace('5010 OVERRIDE County Code : '||l_rs_county_code);
203: IF c_override_state_county%NOTFOUND THEN
204: hr_utility.trace('5020 OVERRIDE County Code NOT found ');
205: /*{*/
206: /*
207: * override does not exists so get the actual address / override as of
208: * 1st Jan .

Line 213: hr_utility.trace('5030 Fetching County Code for Res Jurisdiction ');

209: */
210:
211: BEGIN
212: /*{*/
213: hr_utility.trace('5030 Fetching County Code for Res Jurisdiction ');
214: SELECT puc.state_code || '-' || puc.county_code,
215: pa.date_from
216: INTO l_rs_county_code, l_res_adr_date_start
217: FROM pay_us_counties puc,

Line 232: hr_utility.trace('5040 Resident County Code Found : '||l_rs_county_code);

228: AND pus.state_abbrev = pa.region_2 --actual state
229: AND pus.state_code = '15' --for INDIANA
230: AND puc.state_code = pus.state_code
231: AND puc.county_name = pa.region_1; --actual county
232: hr_utility.trace('5040 Resident County Code Found : '||l_rs_county_code);
233: hr_utility.trace('5050 Resident County Code Eff Start Date : '
234: ||to_char(l_res_adr_date_start,'DD-MON-YYYY'));
235: /* This condition added to fix bug # 3710639 */
236: IF (l_res_adr_date_start <= TRUNC(TO_DATE(l_date_earned, 'DD-MM-YYYY'),'Y'))

Line 233: hr_utility.trace('5050 Resident County Code Eff Start Date : '

229: AND pus.state_code = '15' --for INDIANA
230: AND puc.state_code = pus.state_code
231: AND puc.county_name = pa.region_1; --actual county
232: hr_utility.trace('5040 Resident County Code Found : '||l_rs_county_code);
233: hr_utility.trace('5050 Resident County Code Eff Start Date : '
234: ||to_char(l_res_adr_date_start,'DD-MON-YYYY'));
235: /* This condition added to fix bug # 3710639 */
236: IF (l_res_adr_date_start <= TRUNC(TO_DATE(l_date_earned, 'DD-MM-YYYY'),'Y'))
237: THEN

Line 238: hr_utility.trace('5055 Resident County Eff Start Date '||

234: ||to_char(l_res_adr_date_start,'DD-MON-YYYY'));
235: /* This condition added to fix bug # 3710639 */
236: IF (l_res_adr_date_start <= TRUNC(TO_DATE(l_date_earned, 'DD-MM-YYYY'),'Y'))
237: THEN
238: hr_utility.trace('5055 Resident County Eff Start Date '||
239: to_char(l_res_adr_date_start,'DD-MON-YYYY'));
240: hr_utility.trace('5060 As of 1st Jan Date '||
241: to_char(TRUNC(TO_DATE(l_date_earned, 'DD-MM-YYYY'),'Y'),'DD-MON-YYYY'));
242: hr_utility.trace('5070 County Code Returned '||l_rs_county_code);

Line 240: hr_utility.trace('5060 As of 1st Jan Date '||

236: IF (l_res_adr_date_start <= TRUNC(TO_DATE(l_date_earned, 'DD-MM-YYYY'),'Y'))
237: THEN
238: hr_utility.trace('5055 Resident County Eff Start Date '||
239: to_char(l_res_adr_date_start,'DD-MON-YYYY'));
240: hr_utility.trace('5060 As of 1st Jan Date '||
241: to_char(TRUNC(TO_DATE(l_date_earned, 'DD-MM-YYYY'),'Y'),'DD-MON-YYYY'));
242: hr_utility.trace('5070 County Code Returned '||l_rs_county_code);
243: ELSE
244: hr_utility.trace('5075 Resident County Eff Start Date '||

Line 242: hr_utility.trace('5070 County Code Returned '||l_rs_county_code);

238: hr_utility.trace('5055 Resident County Eff Start Date '||
239: to_char(l_res_adr_date_start,'DD-MON-YYYY'));
240: hr_utility.trace('5060 As of 1st Jan Date '||
241: to_char(TRUNC(TO_DATE(l_date_earned, 'DD-MM-YYYY'),'Y'),'DD-MON-YYYY'));
242: hr_utility.trace('5070 County Code Returned '||l_rs_county_code);
243: ELSE
244: hr_utility.trace('5075 Resident County Eff Start Date '||
245: to_char(l_res_adr_date_start,'DD-MON-YYYY'));
246: hr_utility.trace('5076 As of 1st Jan Date '||

Line 244: hr_utility.trace('5075 Resident County Eff Start Date '||

240: hr_utility.trace('5060 As of 1st Jan Date '||
241: to_char(TRUNC(TO_DATE(l_date_earned, 'DD-MM-YYYY'),'Y'),'DD-MON-YYYY'));
242: hr_utility.trace('5070 County Code Returned '||l_rs_county_code);
243: ELSE
244: hr_utility.trace('5075 Resident County Eff Start Date '||
245: to_char(l_res_adr_date_start,'DD-MON-YYYY'));
246: hr_utility.trace('5076 As of 1st Jan Date '||
247: to_char(TRUNC(TO_DATE(l_date_earned, 'DD-MM-YYYY'),'Y'),'DD-MON-YYYY'));
248: hr_utility.trace('5077 Resident County Code Eff Start Date '||

Line 246: hr_utility.trace('5076 As of 1st Jan Date '||

242: hr_utility.trace('5070 County Code Returned '||l_rs_county_code);
243: ELSE
244: hr_utility.trace('5075 Resident County Eff Start Date '||
245: to_char(l_res_adr_date_start,'DD-MON-YYYY'));
246: hr_utility.trace('5076 As of 1st Jan Date '||
247: to_char(TRUNC(TO_DATE(l_date_earned, 'DD-MM-YYYY'),'Y'),'DD-MON-YYYY'));
248: hr_utility.trace('5077 Resident County Code Eff Start Date '||
249: to_char(l_res_adr_date_start,'DD-MON-YYYY'));
250: hr_utility.trace('5080 County Code Returned 00-000 ');

Line 248: hr_utility.trace('5077 Resident County Code Eff Start Date '||

244: hr_utility.trace('5075 Resident County Eff Start Date '||
245: to_char(l_res_adr_date_start,'DD-MON-YYYY'));
246: hr_utility.trace('5076 As of 1st Jan Date '||
247: to_char(TRUNC(TO_DATE(l_date_earned, 'DD-MM-YYYY'),'Y'),'DD-MON-YYYY'));
248: hr_utility.trace('5077 Resident County Code Eff Start Date '||
249: to_char(l_res_adr_date_start,'DD-MON-YYYY'));
250: hr_utility.trace('5080 County Code Returned 00-000 ');
251: l_rs_county_code := '00-000';
252: END IF;

Line 250: hr_utility.trace('5080 County Code Returned 00-000 ');

246: hr_utility.trace('5076 As of 1st Jan Date '||
247: to_char(TRUNC(TO_DATE(l_date_earned, 'DD-MM-YYYY'),'Y'),'DD-MON-YYYY'));
248: hr_utility.trace('5077 Resident County Code Eff Start Date '||
249: to_char(l_res_adr_date_start,'DD-MON-YYYY'));
250: hr_utility.trace('5080 County Code Returned 00-000 ');
251: l_rs_county_code := '00-000';
252: END IF;
253: CLOSE c_override_state_county;
254: hr_utility.trace('5090 END of function GET_RESIDENCE_AS_OF_1ST_JAN ');

Line 254: hr_utility.trace('5090 END of function GET_RESIDENCE_AS_OF_1ST_JAN ');

250: hr_utility.trace('5080 County Code Returned 00-000 ');
251: l_rs_county_code := '00-000';
252: END IF;
253: CLOSE c_override_state_county;
254: hr_utility.trace('5090 END of function GET_RESIDENCE_AS_OF_1ST_JAN ');
255: RETURN (l_rs_county_code);
256: EXCEPTION --the residence county is not in Indiana
257: WHEN others THEN
258: hr_utility.trace('5100 Exception: '||substr(sqlerrm,1,30));

Line 258: hr_utility.trace('5100 Exception: '||substr(sqlerrm,1,30));

254: hr_utility.trace('5090 END of function GET_RESIDENCE_AS_OF_1ST_JAN ');
255: RETURN (l_rs_county_code);
256: EXCEPTION --the residence county is not in Indiana
257: WHEN others THEN
258: hr_utility.trace('5100 Exception: '||substr(sqlerrm,1,30));
259: hr_utility.trace('5110 END of function GET_RESIDENCE_AS_OF_1ST_JAN ');
260: CLOSE c_override_state_county;
261: l_rs_county_code := '00-000';
262: RETURN (l_rs_county_code);

Line 259: hr_utility.trace('5110 END of function GET_RESIDENCE_AS_OF_1ST_JAN ');

255: RETURN (l_rs_county_code);
256: EXCEPTION --the residence county is not in Indiana
257: WHEN others THEN
258: hr_utility.trace('5100 Exception: '||substr(sqlerrm,1,30));
259: hr_utility.trace('5110 END of function GET_RESIDENCE_AS_OF_1ST_JAN ');
260: CLOSE c_override_state_county;
261: l_rs_county_code := '00-000';
262: RETURN (l_rs_county_code);
263: /*}*/

Line 267: hr_utility.trace('5120 OVERRIDE County Code Found ');

263: /*}*/
264: END;
265: /*}*/
266: ELSE
267: hr_utility.trace('5120 OVERRIDE County Code Found ');
268: hr_utility.trace('5130 County Code Retunred : '||l_rs_county_code);
269: END IF;
270: CLOSE c_override_state_county;
271: hr_utility.trace('5140 END of function GET_RESIDENCE_AS_OF_1ST_JAN ');

Line 268: hr_utility.trace('5130 County Code Retunred : '||l_rs_county_code);

264: END;
265: /*}*/
266: ELSE
267: hr_utility.trace('5120 OVERRIDE County Code Found ');
268: hr_utility.trace('5130 County Code Retunred : '||l_rs_county_code);
269: END IF;
270: CLOSE c_override_state_county;
271: hr_utility.trace('5140 END of function GET_RESIDENCE_AS_OF_1ST_JAN ');
272: RETURN(l_rs_county_code);

Line 271: hr_utility.trace('5140 END of function GET_RESIDENCE_AS_OF_1ST_JAN ');

267: hr_utility.trace('5120 OVERRIDE County Code Found ');
268: hr_utility.trace('5130 County Code Retunred : '||l_rs_county_code);
269: END IF;
270: CLOSE c_override_state_county;
271: hr_utility.trace('5140 END of function GET_RESIDENCE_AS_OF_1ST_JAN ');
272: RETURN(l_rs_county_code);
273: /*}*/
274: END; --function GET_RESIDENCE_AS_OF_1ST_JAN
275:

Line 338: hr_utility.trace('l_date_earned: ' || l_date_earned);

334: 1st Jan has to be picked*/
335: l_date_earned := TRUNC(TO_DATE(p_effective_date, 'DD-MM-YYYY'),'Y');
336:
337:
338: hr_utility.trace('l_date_earned: ' || l_date_earned);
339: OPEN c_override_location;
340:
341: FETCH c_override_location
342: INTO l_curr_county_code;

Line 348: hr_utility.trace('c_override_location%NOTFOUND ');

344: IF c_override_location%NOTFOUND THEN
345: /*{*/
346: BEGIN
347: /*{*/
348: hr_utility.trace('c_override_location%NOTFOUND ');
349: l_is_valid_location := FALSE ;
350: /*Bug#6768746: Check work location of this current assignment is valid
351: as of 1st January. Check all the active assignments attached with this
352: employee.*/

Line 355: hr_utility.trace('rec_multiassgn.assignment_id: '|| to_char(rec_multiassgn.assignment_id));

351: as of 1st January. Check all the active assignments attached with this
352: employee.*/
353: for rec_multiassgn in c_multiple_assignments
354: LOOP
355: hr_utility.trace('rec_multiassgn.assignment_id: '|| to_char(rec_multiassgn.assignment_id));
356: SELECT count(1)
357: INTO l_is_exist
358: FROM pay_us_counties puc,
359: pay_us_states pus,

Line 378: hr_utility.trace('l_is_exist >0');

374: AND puc.state_code = SUBSTR(p_juri_code, 1, 2)
375: AND puc.county_code = SUBSTR(p_juri_code, 4, 3);
376:
377: IF l_is_exist > 0 then
378: hr_utility.trace('l_is_exist >0');
379: l_is_valid_location := TRUE ;
380: end if;
381: end loop;
382: CLOSE c_override_location;

Line 388: hr_utility.trace('5100 Exception: '||substr(sqlerrm,1,30));

384:
385: EXCEPTION
386: WHEN others THEN
387: CLOSE c_override_location;
388: hr_utility.trace('5100 Exception: '||substr(sqlerrm,1,30));
389: RETURN (FALSE);
390: /* SELECT count(1)
391: INTO l_is_exist
392: FROM pay_us_counties puc,

Line 413: hr_utility.trace('query count: ' || to_char(l_is_exist));

409: AND puc.county_code = SUBSTR(p_juri_code, 4, 3);
410:
411: CLOSE c_override_location;
412: --RETURN (TRUE);
413: hr_utility.trace('query count: ' || to_char(l_is_exist));
414: IF l_is_exist = 0 then
415: RETURN (FALSE);
416: else
417: return(TRUE);

Line 479: hr_utility.trace('DOES_TAX_EXISTS County Tax Exists : '

475: 'SIT_RS',
476: p_called_from);
477: /*}*/
478: END IF;
479: hr_utility.trace('DOES_TAX_EXISTS County Tax Exists : '
480: || l_county_tax_exists);
481: RETURN(l_county_tax_exists);
482: /*}*/
483: ELSE

Line 485: hr_utility.trace('DOES_TAX_EXISTS County Tax Exists : '

481: RETURN(l_county_tax_exists);
482: /*}*/
483: ELSE
484: /*{*/
485: hr_utility.trace('DOES_TAX_EXISTS County Tax Exists : '
486: || l_county_tax_exists);
487: RETURN(l_county_tax_exists);
488: /*}*/
489: END IF;

Line 492: hr_utility.trace('DOES_TAX_EXISTS EXception Raised ');

488: /*}*/
489: END IF;
490: EXCEPTION
491: WHEN others THEN
492: hr_utility.trace('DOES_TAX_EXISTS EXception Raised ');
493: hr_utility.trace('DOES_TAX_EXISTS County Tax Exists : N');
494: RETURN('N');
495: /*}*/
496: END DOES_TAX_EXISTS;

Line 493: hr_utility.trace('DOES_TAX_EXISTS County Tax Exists : N');

489: END IF;
490: EXCEPTION
491: WHEN others THEN
492: hr_utility.trace('DOES_TAX_EXISTS EXception Raised ');
493: hr_utility.trace('DOES_TAX_EXISTS County Tax Exists : N');
494: RETURN('N');
495: /*}*/
496: END DOES_TAX_EXISTS;
497:

Line 556: hr_utility.set_location('pay_get_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX', 52);

552: AND hoi.org_information1 = SUBSTR(p_juri_code,1,6)||'-0000';
553: /* Bug 2934494
554: AND hoi.org_information1 = SUBSTR(p_juri_code,1,6)||' - 0000';
555: */
556: hr_utility.set_location('pay_get_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX', 52);
557: hr_utility.trace('County Income Tax Exists : '||l_local_level_tax_exists);
558: RETURN(l_local_level_tax_exists);
559:
560: EXCEPTION

Line 557: hr_utility.trace('County Income Tax Exists : '||l_local_level_tax_exists);

553: /* Bug 2934494
554: AND hoi.org_information1 = SUBSTR(p_juri_code,1,6)||' - 0000';
555: */
556: hr_utility.set_location('pay_get_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX', 52);
557: hr_utility.trace('County Income Tax Exists : '||l_local_level_tax_exists);
558: RETURN(l_local_level_tax_exists);
559:
560: EXCEPTION
561: WHEN OTHERS THEN

Line 563: hr_utility.set_location(

559:
560: EXCEPTION
561: WHEN OTHERS THEN
562: -- If there is no value then return l_state_level_tax_exists
563: hr_utility.set_location(
564: 'pay_get_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX', 53);
565: hr_utility.trace(
566: 'No rexord defined in Local Tax rules for this Locality : '
567: || l_local_level_tax_exists);

Line 565: hr_utility.trace(

561: WHEN OTHERS THEN
562: -- If there is no value then return l_state_level_tax_exists
563: hr_utility.set_location(
564: 'pay_get_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX', 53);
565: hr_utility.trace(
566: 'No rexord defined in Local Tax rules for this Locality : '
567: || l_local_level_tax_exists);
568: /*
569: * This will return Y, if ALL Localities are selected under State Tax Rules

Line 585: hr_utility.set_location('py_gt_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX',54);

581: If Employer setup for State's Resident Tax is Only Withhold Tax
582: at Work Location return No, so that Resident tax is not withhold
583: for the resident jurisdiction
584: */
585: hr_utility.set_location('py_gt_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX',54);
586: hr_utility.trace('Local Income Tax Exists : ' ||l_wh_work_localities);
587: --
588: -- This is added to tax a jurisdiction if it is tagged OR
589: -- resident jurisdiction is same Work

Line 586: hr_utility.trace('Local Income Tax Exists : ' ||l_wh_work_localities);

582: at Work Location return No, so that Resident tax is not withhold
583: for the resident jurisdiction
584: */
585: hr_utility.set_location('py_gt_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX',54);
586: hr_utility.trace('Local Income Tax Exists : ' ||l_wh_work_localities);
587: --
588: -- This is added to tax a jurisdiction if it is tagged OR
589: -- resident jurisdiction is same Work
590: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);

Line 591: hr_utility.trace('Jurisdiction Type : '||l_jd_type);

587: --
588: -- This is added to tax a jurisdiction if it is tagged OR
589: -- resident jurisdiction is same Work
590: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);
591: hr_utility.trace('Jurisdiction Type : '||l_jd_type);
592: if (nvl(l_jd_type,'NL') = 'RT' OR
593: nvl(l_jd_type,'NL') = 'RW' OR
594: nvl(l_jd_type,'NL') = 'HW' -- added to fix bug # 4463475
595: ) then

Line 597: hr_utility.trace('COUNTY Tax to be withheld : Y');

593: nvl(l_jd_type,'NL') = 'RW' OR
594: nvl(l_jd_type,'NL') = 'HW' -- added to fix bug # 4463475
595: ) then
596: --{
597: hr_utility.trace('COUNTY Tax to be withheld : Y');
598: return('Y');
599: --}
600: else
601: hr_utility.trace('County Tax to be withheld : ' || l_wh_work_localities);

Line 601: hr_utility.trace('County Tax to be withheld : ' || l_wh_work_localities);

597: hr_utility.trace('COUNTY Tax to be withheld : Y');
598: return('Y');
599: --}
600: else
601: hr_utility.trace('County Tax to be withheld : ' || l_wh_work_localities);
602: RETURN l_wh_work_localities;
603: end if;
604: --}
605: END IF;

Line 610: hr_utility.set_location('py_gt_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX', 55);

606: END;
607: EXCEPTION /* The ct has nothing at the EI level set up */
608: WHEN OTHERS THEN
609: l_local_level_tax_exists := 'Y';
610: hr_utility.set_location('py_gt_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX', 55);
611: hr_utility.trace('Local Income Tax Exists : ' || l_local_level_tax_exists);
612: RETURN l_local_level_tax_exists;
613: --}
614: END STATE_LOCAL_LEVEL_TAX;

Line 611: hr_utility.trace('Local Income Tax Exists : ' || l_local_level_tax_exists);

607: EXCEPTION /* The ct has nothing at the EI level set up */
608: WHEN OTHERS THEN
609: l_local_level_tax_exists := 'Y';
610: hr_utility.set_location('py_gt_tax_exists_pkg.STATE_LOCAL_LEVEL_TAX', 55);
611: hr_utility.trace('Local Income Tax Exists : ' || l_local_level_tax_exists);
612: RETURN l_local_level_tax_exists;
613: --}
614: END STATE_LOCAL_LEVEL_TAX;
615:

Line 646: -- hr_utility.trace_on(null,'EXIST');

642: RETURN VARCHAR2 IS
643:
644: BEGIN
645: /*{*/
646: -- hr_utility.trace_on(null,'EXIST');
647: RETURN get_tax_exists(p_juri_code,
648: p_date_earned,
649: p_tax_unit_id,
650: p_assign_id,

Line 731: l_payroll_installed := hr_utility.chk_product_install(

727: /*
728: * Check to see if US Payroll is installed
729: */
730:
731: l_payroll_installed := hr_utility.chk_product_install(
732: p_product =>'Oracle Payroll',
733: p_legislation => 'US');
734: IF l_payroll_installed THEN
735: /*{*/

Line 737: -- hr_utility.trace_on(null,'TAXEXIST');

733: p_legislation => 'US');
734: IF l_payroll_installed THEN
735: /*{*/
736:
737: -- hr_utility.trace_on(null,'TAXEXIST');
738: hr_utility.set_location('Entering pay_get_tax_exists_pkg.get_tax_exists',1);
739: hr_utility.trace('We are changing the date format, the before date is: '
740: ||p_date_earned);
741: l_date_earned := TO_CHAR(p_date_earned,'dd-mm-yyyy');

Line 738: hr_utility.set_location('Entering pay_get_tax_exists_pkg.get_tax_exists',1);

734: IF l_payroll_installed THEN
735: /*{*/
736:
737: -- hr_utility.trace_on(null,'TAXEXIST');
738: hr_utility.set_location('Entering pay_get_tax_exists_pkg.get_tax_exists',1);
739: hr_utility.trace('We are changing the date format, the before date is: '
740: ||p_date_earned);
741: l_date_earned := TO_CHAR(p_date_earned,'dd-mm-yyyy');
742:

Line 739: hr_utility.trace('We are changing the date format, the before date is: '

735: /*{*/
736:
737: -- hr_utility.trace_on(null,'TAXEXIST');
738: hr_utility.set_location('Entering pay_get_tax_exists_pkg.get_tax_exists',1);
739: hr_utility.trace('We are changing the date format, the before date is: '
740: ||p_date_earned);
741: l_date_earned := TO_CHAR(p_date_earned,'dd-mm-yyyy');
742:
743: hr_utility.trace('The tax we are determining is : '|| p_type);

Line 743: hr_utility.trace('The tax we are determining is : '|| p_type);

739: hr_utility.trace('We are changing the date format, the before date is: '
740: ||p_date_earned);
741: l_date_earned := TO_CHAR(p_date_earned,'dd-mm-yyyy');
742:
743: hr_utility.trace('The tax we are determining is : '|| p_type);
744: hr_utility.trace('The jurisdiction is : ' || p_juri_code);
745: hr_utility.trace('The date earned after change of format is : '
746: || l_date_earned);
747: hr_utility.trace('The tax unit id is : ' || p_tax_unit_id);

Line 744: hr_utility.trace('The jurisdiction is : ' || p_juri_code);

740: ||p_date_earned);
741: l_date_earned := TO_CHAR(p_date_earned,'dd-mm-yyyy');
742:
743: hr_utility.trace('The tax we are determining is : '|| p_type);
744: hr_utility.trace('The jurisdiction is : ' || p_juri_code);
745: hr_utility.trace('The date earned after change of format is : '
746: || l_date_earned);
747: hr_utility.trace('The tax unit id is : ' || p_tax_unit_id);
748: hr_utility.trace('The assignment id is : ' || p_assign_id);

Line 745: hr_utility.trace('The date earned after change of format is : '

741: l_date_earned := TO_CHAR(p_date_earned,'dd-mm-yyyy');
742:
743: hr_utility.trace('The tax we are determining is : '|| p_type);
744: hr_utility.trace('The jurisdiction is : ' || p_juri_code);
745: hr_utility.trace('The date earned after change of format is : '
746: || l_date_earned);
747: hr_utility.trace('The tax unit id is : ' || p_tax_unit_id);
748: hr_utility.trace('The assignment id is : ' || p_assign_id);
749:

Line 747: hr_utility.trace('The tax unit id is : ' || p_tax_unit_id);

743: hr_utility.trace('The tax we are determining is : '|| p_type);
744: hr_utility.trace('The jurisdiction is : ' || p_juri_code);
745: hr_utility.trace('The date earned after change of format is : '
746: || l_date_earned);
747: hr_utility.trace('The tax unit id is : ' || p_tax_unit_id);
748: hr_utility.trace('The assignment id is : ' || p_assign_id);
749:
750: /*
751: * Let's take the jurisdiction code and get a state abbrev

Line 748: hr_utility.trace('The assignment id is : ' || p_assign_id);

744: hr_utility.trace('The jurisdiction is : ' || p_juri_code);
745: hr_utility.trace('The date earned after change of format is : '
746: || l_date_earned);
747: hr_utility.trace('The tax unit id is : ' || p_tax_unit_id);
748: hr_utility.trace('The assignment id is : ' || p_assign_id);
749:
750: /*
751: * Let's take the jurisdiction code and get a state abbrev
752: */

Line 759: hr_utility.trace('The state abbrev is:' || l_state_abbrev);

755: INTO l_state_abbrev
756: FROM pay_us_states pus
757: WHERE pus.state_code = SUBSTR(p_juri_code, 1, 2);
758:
759: hr_utility.trace('The state abbrev is:' || l_state_abbrev);
760:
761:
762: /*
763: * Let's only allow the function to work if date_earned is in 1999

Line 774: hr_utility.trace('The year of the date earned is: '

770: IF SUBSTR(l_date_earned, 7) < 1999 THEN
771: /*{*/
772: BEGIN
773: /*{*/
774: hr_utility.trace('The year of the date earned is: '
775: || SUBSTR(l_date_earned, 7));
776: l_exists := 'Y';
777: hr_utility.trace('The year is before 1999 so we will say tax exists '
778: ||' =Y');

Line 777: hr_utility.trace('The year is before 1999 so we will say tax exists '

773: /*{*/
774: hr_utility.trace('The year of the date earned is: '
775: || SUBSTR(l_date_earned, 7));
776: l_exists := 'Y';
777: hr_utility.trace('The year is before 1999 so we will say tax exists '
778: ||' =Y');
779: RETURN l_exists;
780: /*}*/
781: END;

Line 785: hr_utility.trace('The year of the date earned is after 1998 so we will '

781: END;
782: /*}*/
783: ELSE
784: /*{*/
785: hr_utility.trace('The year of the date earned is after 1998 so we will '
786: || ' allow the function to calc');
787: NULL;
788: /*}*/
789: END IF;

Line 847: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',11);

843: WHERE hoi.ORG_INFORMATION_CONTEXT = 'State Tax Rules'
844: AND hoi.organization_id = p_tax_unit_id
845: AND hoi.org_information1 = l_state_abbrev;
846:
847: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',11);
848: hr_utility.trace('SIT Exists : ' || l_sit_rs_exists);
849:
850: IF l_sit_rs_exists = 'N' THEN
851:

Line 848: hr_utility.trace('SIT Exists : ' || l_sit_rs_exists);

844: AND hoi.organization_id = p_tax_unit_id
845: AND hoi.org_information1 = l_state_abbrev;
846:
847: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',11);
848: hr_utility.trace('SIT Exists : ' || l_sit_rs_exists);
849:
850: IF l_sit_rs_exists = 'N' THEN
851:
852: IF hr_us_ff_udf1.get_work_state(substr(p_juri_code, 1, 2)) = 'Y' THEN

Line 865: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',12);

861: WHEN NO_DATA_FOUND THEN
862: /*
863: * If there is no value then return the value of l_org_info2
864: */
865: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',12);
866: hr_utility.trace('SIT Exists : ' || l_org_info2);
867:
868: IF l_org_info2 = 'N' THEN
869:

Line 866: hr_utility.trace('SIT Exists : ' || l_org_info2);

862: /*
863: * If there is no value then return the value of l_org_info2
864: */
865: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',12);
866: hr_utility.trace('SIT Exists : ' || l_org_info2);
867:
868: IF l_org_info2 = 'N' THEN
869:
870: IF hr_us_ff_udf1.get_work_state(substr(p_juri_code, 1, 2)) = 'Y' THEN

Line 882: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 15);

878: END;
879: /*}*/
880: ELSE /* 2 */
881: /*{*/
882: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 15);
883: hr_utility.trace('SIT Exists : ' || l_sit_rs_exists);
884:
885: RETURN l_sit_rs_exists;
886: /*

Line 883: hr_utility.trace('SIT Exists : ' || l_sit_rs_exists);

879: /*}*/
880: ELSE /* 2 */
881: /*{*/
882: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 15);
883: hr_utility.trace('SIT Exists : ' || l_sit_rs_exists);
884:
885: RETURN l_sit_rs_exists;
886: /*
887: * jit level, this will be N, no sit for the state

Line 896: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 16);

892: EXCEPTION
893: WHEN others THEN
894:
895: l_sit_rs_exists := 'Y';
896: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 16);
897: hr_utility.trace('SIT Exists : ' || l_sit_rs_exists);
898:
899: RETURN l_sit_rs_exists;
900:

Line 897: hr_utility.trace('SIT Exists : ' || l_sit_rs_exists);

893: WHEN others THEN
894:
895: l_sit_rs_exists := 'Y';
896: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 16);
897: hr_utility.trace('SIT Exists : ' || l_sit_rs_exists);
898:
899: RETURN l_sit_rs_exists;
900:
901: /*}*/

Line 917: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 20);

913: effective_start_date AND effective_end_date;
914:
915: IF l_sit_wk_exists = 'Y' THEN /* 2 */
916: /*{*/
917: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 20);
918: hr_utility.trace('SIT_WK Exists at the jit level, '
919: ||' now we check if the NR certificate is filed');
920: IF p_call = 'F' THEN
921: /*{*/

Line 918: hr_utility.trace('SIT_WK Exists at the jit level, '

914:
915: IF l_sit_wk_exists = 'Y' THEN /* 2 */
916: /*{*/
917: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 20);
918: hr_utility.trace('SIT_WK Exists at the jit level, '
919: ||' now we check if the NR certificate is filed');
920: IF p_call = 'F' THEN
921: /*{*/
922: l_sit_wk_exists := get_tax_exists(p_juri_code,

Line 929: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',21);

925: p_assign_id,
926: p_pact_id,
927: 'NR');
928:
929: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',21);
930: hr_utility.trace('Do we take out sit based on the NR check? '
931: || l_sit_wk_exists);
932: /*}*/
933: END IF;

Line 930: hr_utility.trace('Do we take out sit based on the NR check? '

926: p_pact_id,
927: 'NR');
928:
929: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',21);
930: hr_utility.trace('Do we take out sit based on the NR check? '
931: || l_sit_wk_exists);
932: /*}*/
933: END IF;
934: /*

Line 944: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists' ,22);

940: /*{*/
941: /*
942: * jit level, this will be N, no sit for the state
943: */
944: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists' ,22);
945: hr_utility.trace('SIT_WK Exists : ' || l_sit_wk_exists);
946: RETURN l_sit_wk_exists;
947:
948: /*}*/

Line 945: hr_utility.trace('SIT_WK Exists : ' || l_sit_wk_exists);

941: /*
942: * jit level, this will be N, no sit for the state
943: */
944: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists' ,22);
945: hr_utility.trace('SIT_WK Exists : ' || l_sit_wk_exists);
946: RETURN l_sit_wk_exists;
947:
948: /*}*/
949: END IF; /* 2 */

Line 954: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);

950:
951: EXCEPTION
952: WHEN others THEN
953: l_sit_wk_exists := 'Y';
954: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);
955: hr_utility.trace('SIT_WK Exists : ' || l_sit_wk_exists);
956: RETURN l_sit_wk_exists;
957: /*}*/
958: END; /* SIT_WK */

Line 955: hr_utility.trace('SIT_WK Exists : ' || l_sit_wk_exists);

951: EXCEPTION
952: WHEN others THEN
953: l_sit_wk_exists := 'Y';
954: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);
955: hr_utility.trace('SIT_WK Exists : ' || l_sit_wk_exists);
956: RETURN l_sit_wk_exists;
957: /*}*/
958: END; /* SIT_WK */
959: /*}*/

Line 981: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists WC', 20);

977:
978:
979: IF l_wc_exists = 'Y' THEN /* 2 */
980: /*{*/
981: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists WC', 20);
982: hr_utility.trace('WC Carrier Exists at the State Tax Levels level, '
983: ||' now check if this assignment is WC exempt');
984: IF p_call = 'F' THEN
985: /*{*/

Line 982: hr_utility.trace('WC Carrier Exists at the State Tax Levels level, '

978:
979: IF l_wc_exists = 'Y' THEN /* 2 */
980: /*{*/
981: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists WC', 20);
982: hr_utility.trace('WC Carrier Exists at the State Tax Levels level, '
983: ||' now check if this assignment is WC exempt');
984: IF p_call = 'F' THEN
985: /*{*/
986:

Line 997: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists WC',21);

993: AND str.assignment_id = p_assign_id /* 5772548 */
994: AND TO_DATE(l_date_earned, 'dd-mm-yyyy') BETWEEN
995: str.effective_start_date AND str.effective_end_date;
996:
997: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists WC',21);
998: hr_utility.trace(' check for wc exemption ' || l_wc_exists);
999: /*}*/
1000: END IF;
1001: /*

Line 998: hr_utility.trace(' check for wc exemption ' || l_wc_exists);

994: AND TO_DATE(l_date_earned, 'dd-mm-yyyy') BETWEEN
995: str.effective_start_date AND str.effective_end_date;
996:
997: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists WC',21);
998: hr_utility.trace(' check for wc exemption ' || l_wc_exists);
999: /*}*/
1000: END IF;
1001: /*
1002: * if yes then NR is not checked, if no then NR is checked

Line 1011: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists wc', 23);

1007:
1008: EXCEPTION
1009: WHEN others THEN
1010: l_wc_exists := 'Y';
1011: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists wc', 23);
1012: hr_utility.trace('WC Exists : ' || l_wc_exists);
1013: RETURN l_wc_exists;
1014: /*}*/
1015: END; /* WC */

Line 1012: hr_utility.trace('WC Exists : ' || l_wc_exists);

1008: EXCEPTION
1009: WHEN others THEN
1010: l_wc_exists := 'Y';
1011: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists wc', 23);
1012: hr_utility.trace('WC Exists : ' || l_wc_exists);
1013: RETURN l_wc_exists;
1014: /*}*/
1015: END; /* WC */
1016: /*}*/

Line 1031: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 25);

1027: effective_start_date AND effective_end_date;
1028:
1029: IF l_misc1_state_tax = 'Y' THEN /* 2 */
1030: /*{*/
1031: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 25);
1032: hr_utility.trace('MISC1_TAX Exists at the jit level, '
1033: ||' now we check if the NR certificate is filed');
1034: /*Bug 4344763, For SHI(MA) NR Certificate should not be checked*/
1035: /* IF p_call = 'F' THEN

Line 1032: hr_utility.trace('MISC1_TAX Exists at the jit level, '

1028:
1029: IF l_misc1_state_tax = 'Y' THEN /* 2 */
1030: /*{*/
1031: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 25);
1032: hr_utility.trace('MISC1_TAX Exists at the jit level, '
1033: ||' now we check if the NR certificate is filed');
1034: /*Bug 4344763, For SHI(MA) NR Certificate should not be checked*/
1035: /* IF p_call = 'F' THEN
1036: l_misc1_state_tax := get_tax_exists(p_juri_code,

Line 1042: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',26);

1038: p_tax_unit_id,
1039: p_assign_id,
1040: 'NR');
1041:
1042: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',26);
1043: hr_utility.trace('Do we take out sit based on the NR check? '
1044: || l_sit_wk_exists);
1045:
1046: END IF;*/

Line 1043: hr_utility.trace('Do we take out sit based on the NR check? '

1039: p_assign_id,
1040: 'NR');
1041:
1042: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',26);
1043: hr_utility.trace('Do we take out sit based on the NR check? '
1044: || l_sit_wk_exists);
1045:
1046: END IF;*/
1047:

Line 1059: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists' ,27);

1055: /*
1056: * jit level, this will be N, no misc1 tax for the state
1057: */
1058: l_misc1_state_tax := 'N';
1059: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists' ,27);
1060: hr_utility.trace('MISC1_TAX Exists : ' || l_misc1_state_tax);
1061: RETURN l_misc1_state_tax;
1062:
1063: /*}*/

Line 1060: hr_utility.trace('MISC1_TAX Exists : ' || l_misc1_state_tax);

1056: * jit level, this will be N, no misc1 tax for the state
1057: */
1058: l_misc1_state_tax := 'N';
1059: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists' ,27);
1060: hr_utility.trace('MISC1_TAX Exists : ' || l_misc1_state_tax);
1061: RETURN l_misc1_state_tax;
1062:
1063: /*}*/
1064: END IF; /* 2 */

Line 1069: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 28);

1065:
1066: EXCEPTION
1067: WHEN others THEN
1068: l_misc1_state_tax := 'N';
1069: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 28);
1070: hr_utility.trace('MISC1_TAX Exists : ' || l_misc1_state_tax);
1071: RETURN l_misc1_state_tax;
1072: /*}*/
1073: END; /* MISC1_TAX */

Line 1070: hr_utility.trace('MISC1_TAX Exists : ' || l_misc1_state_tax);

1066: EXCEPTION
1067: WHEN others THEN
1068: l_misc1_state_tax := 'N';
1069: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 28);
1070: hr_utility.trace('MISC1_TAX Exists : ' || l_misc1_state_tax);
1071: RETURN l_misc1_state_tax;
1072: /*}*/
1073: END; /* MISC1_TAX */
1074: /*}*/

Line 1106: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 30);

1102: AND SES.session_id = USERENV('SESSIONID')
1103: AND SES.effective_date BETWEEN
1104: STATETAX.effective_start_date AND STATETAX.effective_end_date;
1105:
1106: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 30);
1107: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);
1108:
1109: IF l_sdi_ee_exists = 'N' THEN /* 2 */
1110: /*

Line 1107: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);

1103: AND SES.effective_date BETWEEN
1104: STATETAX.effective_start_date AND STATETAX.effective_end_date;
1105:
1106: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 30);
1107: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);
1108:
1109: IF l_sdi_ee_exists = 'N' THEN /* 2 */
1110: /*
1111: * see if their is a period limit

Line 1116: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1112: */
1113: /*{*/
1114: BEGIN
1115: /*{*/
1116: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1117: 31);
1118: hr_utility.trace('No SDI wage limit, check for period limit');
1119:
1120: SELECT DISTINCT DECODE(STATETAX.STA_INFORMATION1,

Line 1118: hr_utility.trace('No SDI wage limit, check for period limit');

1114: BEGIN
1115: /*{*/
1116: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1117: 31);
1118: hr_utility.trace('No SDI wage limit, check for period limit');
1119:
1120: SELECT DISTINCT DECODE(STATETAX.STA_INFORMATION1,
1121: NULL, 'N',
1122: 0, 'N',

Line 1132: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1128: AND SES.session_id = USERENV('SESSIONID')
1129: AND SES.effective_date BETWEEN
1130: STATETAX.effective_start_date AND STATETAX.effective_end_date;
1131:
1132: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1133: 32);
1134: hr_utility.trace('SDI EE Exists: ' || l_sdi_ee_exists);
1135: RETURN l_sdi_ee_exists;
1136:

Line 1134: hr_utility.trace('SDI EE Exists: ' || l_sdi_ee_exists);

1130: STATETAX.effective_start_date AND STATETAX.effective_end_date;
1131:
1132: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1133: 32);
1134: hr_utility.trace('SDI EE Exists: ' || l_sdi_ee_exists);
1135: RETURN l_sdi_ee_exists;
1136:
1137: EXCEPTION
1138: WHEN OTHERS THEN

Line 1140: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1136:
1137: EXCEPTION
1138: WHEN OTHERS THEN
1139: l_sdi_ee_exists := 'N';
1140: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1141: 33);
1142: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);
1143: RETURN l_sdi_ee_exists;
1144:

Line 1142: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);

1138: WHEN OTHERS THEN
1139: l_sdi_ee_exists := 'N';
1140: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1141: 33);
1142: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);
1143: RETURN l_sdi_ee_exists;
1144:
1145: /*}*/
1146: END;

Line 1150: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1146: END;
1147: /*}*/
1148: ELSE /* 2 */
1149: /*{*/
1150: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1151: 34);
1152: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);
1153: RETURN l_sdi_ee_exists;
1154: /*}*/

Line 1152: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);

1148: ELSE /* 2 */
1149: /*{*/
1150: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1151: 34);
1152: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);
1153: RETURN l_sdi_ee_exists;
1154: /*}*/
1155: END IF; /* 2 */
1156:

Line 1160: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1156:
1157: EXCEPTION
1158: WHEN OTHERS THEN
1159: l_sdi_ee_exists := 'Y';
1160: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1161: 35);
1162: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);
1163: RETURN l_sdi_ee_exists;
1164: /*}*/

Line 1162: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);

1158: WHEN OTHERS THEN
1159: l_sdi_ee_exists := 'Y';
1160: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1161: 35);
1162: hr_utility.trace('SDI EE Exists : ' || l_sdi_ee_exists);
1163: RETURN l_sdi_ee_exists;
1164: /*}*/
1165: END; /* p_type = SDI_EE */
1166: /*}*/

Line 1193: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 40);

1189: AND SES.session_id = USERENV('SESSIONID')
1190: AND SES.effective_date BETWEEN
1191: STATETAX.effective_start_date AND STATETAX.effective_end_date;
1192:
1193: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 40);
1194: hr_utility.trace('SDI ER Exists : ' || l_sdi_er_exists);
1195:
1196: RETURN l_sdi_er_exists;
1197:

Line 1194: hr_utility.trace('SDI ER Exists : ' || l_sdi_er_exists);

1190: AND SES.effective_date BETWEEN
1191: STATETAX.effective_start_date AND STATETAX.effective_end_date;
1192:
1193: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 40);
1194: hr_utility.trace('SDI ER Exists : ' || l_sdi_er_exists);
1195:
1196: RETURN l_sdi_er_exists;
1197:
1198: /*}*/

Line 1212: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);

1208: WHERE state_code = SUBSTR(p_juri_code, 1, 2)
1209: AND TO_DATE(l_date_earned, 'dd-mm-yyyy') BETWEEN
1210: effective_start_date AND effective_end_date;
1211:
1212: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);
1213: hr_utility.trace('STEIC Exists : ' || l_eic_rs_exists);
1214:
1215: RETURN l_eic_rs_exists;
1216:

Line 1213: hr_utility.trace('STEIC Exists : ' || l_eic_rs_exists);

1209: AND TO_DATE(l_date_earned, 'dd-mm-yyyy') BETWEEN
1210: effective_start_date AND effective_end_date;
1211:
1212: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);
1213: hr_utility.trace('STEIC Exists : ' || l_eic_rs_exists);
1214:
1215: RETURN l_eic_rs_exists;
1216:
1217: EXCEPTION

Line 1220: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);

1216:
1217: EXCEPTION
1218: WHEN others THEN
1219: l_eic_rs_exists := 'N';
1220: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);
1221: hr_utility.trace('STEIC Exists : ' || l_eic_rs_exists);
1222:
1223: RETURN l_eic_rs_exists;
1224:

Line 1221: hr_utility.trace('STEIC Exists : ' || l_eic_rs_exists);

1217: EXCEPTION
1218: WHEN others THEN
1219: l_eic_rs_exists := 'N';
1220: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);
1221: hr_utility.trace('STEIC Exists : ' || l_eic_rs_exists);
1222:
1223: RETURN l_eic_rs_exists;
1224:
1225: /*}*/

Line 1239: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);

1235: WHERE state_code = SUBSTR(p_juri_code, 1, 2)
1236: AND TO_DATE(l_date_earned, 'dd-mm-yyyy') BETWEEN
1237: effective_start_date AND effective_end_date;
1238:
1239: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);
1240: hr_utility.trace('STEIC Exists : ' || l_eic_wk_exists);
1241:
1242: RETURN l_eic_wk_exists;
1243:

Line 1240: hr_utility.trace('STEIC Exists : ' || l_eic_wk_exists);

1236: AND TO_DATE(l_date_earned, 'dd-mm-yyyy') BETWEEN
1237: effective_start_date AND effective_end_date;
1238:
1239: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);
1240: hr_utility.trace('STEIC Exists : ' || l_eic_wk_exists);
1241:
1242: RETURN l_eic_wk_exists;
1243:
1244: EXCEPTION

Line 1247: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);

1243:
1244: EXCEPTION
1245: WHEN others THEN
1246: l_eic_wk_exists := 'N';
1247: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);
1248: hr_utility.trace('STEIC Exists : ' || l_eic_wk_exists);
1249:
1250: RETURN l_eic_wk_exists;
1251:

Line 1248: hr_utility.trace('STEIC Exists : ' || l_eic_wk_exists);

1244: EXCEPTION
1245: WHEN others THEN
1246: l_eic_wk_exists := 'N';
1247: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 23);
1248: hr_utility.trace('STEIC Exists : ' || l_eic_wk_exists);
1249:
1250: RETURN l_eic_wk_exists;
1251:
1252: /*}*/

Line 1259: hr_utility.trace('BEGIN TAX TYPE COUNTY_RS');

1255: ELSIF p_type = 'COUNTY_RS' THEN /* 1 */
1256:
1257: BEGIN
1258:
1259: hr_utility.trace('BEGIN TAX TYPE COUNTY_RS');
1260:
1261: IF SUBSTR(p_juri_code, 1, 2) = '15' THEN /* check for Indiana state */
1262:
1263: if p_pact_id is not null then

Line 1268: hr_utility.trace('l_indiana_override '||l_indiana_override);

1264:
1265: open override_state;
1266: fetch override_state into l_indiana_override;
1267:
1268: hr_utility.trace('l_indiana_override '||l_indiana_override);
1269: if override_state%found then
1270:
1271: l_across_years := hr_us_ff_udf1.across_calendar_years(p_pact_id);
1272:

Line 1273: hr_utility.trace('l_across_years '||l_across_years);

1269: if override_state%found then
1270:
1271: l_across_years := hr_us_ff_udf1.across_calendar_years(p_pact_id);
1272:
1273: hr_utility.trace('l_across_years '||l_across_years);
1274: if (l_indiana_override = 'IN' and
1275: l_across_years = 'Y') then
1276:
1277: select to_char(effective_date,'dd-mm-yyyy')

Line 1282: hr_utility.trace('l_date '||to_char(l_date));

1278: into l_date
1279: from pay_payroll_actions
1280: where payroll_action_id = p_pact_id;
1281:
1282: hr_utility.trace('l_date '||to_char(l_date));
1283: else
1284: l_date := l_date_earned;
1285: end if;
1286:

Line 1297: hr_utility.trace('Resident State is Indiana Jurisdiction '||p_juri_code);

1293: else
1294: l_date := l_date_earned;
1295: end if;
1296:
1297: hr_utility.trace('Resident State is Indiana Jurisdiction '||p_juri_code);
1298:
1299: l_rs_county_as_of_1st_jan := get_residence_as_of_1st_jan(p_assign_id,
1300: l_date);
1301:

Line 1302: hr_utility.trace('Resident JD Code as of 1st Jan '||

1298:
1299: l_rs_county_as_of_1st_jan := get_residence_as_of_1st_jan(p_assign_id,
1300: l_date);
1301:
1302: hr_utility.trace('Resident JD Code as of 1st Jan '||
1303: l_rs_county_as_of_1st_jan);
1304: IF l_rs_county_as_of_1st_jan = SUBSTR(p_juri_code, 1, 6) THEN
1305: /* 1st Jan */
1306: hr_utility.trace('Resident JD Code as of 1st Jan = Primary JD code as of date');

Line 1306: hr_utility.trace('Resident JD Code as of 1st Jan = Primary JD code as of date');

1302: hr_utility.trace('Resident JD Code as of 1st Jan '||
1303: l_rs_county_as_of_1st_jan);
1304: IF l_rs_county_as_of_1st_jan = SUBSTR(p_juri_code, 1, 6) THEN
1305: /* 1st Jan */
1306: hr_utility.trace('Resident JD Code as of 1st Jan = Primary JD code as of date');
1307: l_county_tax_exists := does_tax_exists(p_juri_code,
1308: l_date,
1309: p_tax_unit_id,
1310: p_assign_id,

Line 1313: hr_utility.trace('County Tax exist for JD code '||l_county_tax_exists);

1309: p_tax_unit_id,
1310: p_assign_id,
1311: p_pact_id,
1312: 'COUNTY_RS');
1313: hr_utility.trace('County Tax exist for JD code '||l_county_tax_exists);
1314: IF l_county_tax_exists = 'Y' THEN /* tax exists */
1315: /*{*/
1316: l_state_local_level_tax := state_local_level_tax(p_tax_unit_id,
1317: l_state_abbrev,

Line 1329: hr_utility.trace('Resident JD Code as of 1st Jan <> Primary JD code as of date');

1325: END IF; /* tax exists */
1326: /*}*/
1327: ELSE /* 1st Jan */
1328: /*{*/
1329: hr_utility.trace('Resident JD Code as of 1st Jan <> Primary JD code as of date');
1330: hr_utility.trace('COUNTY_RS Tax Withheld = NO ');
1331: RETURN('N'); /* the county is not as of 1st Jan */
1332: /*}*/
1333: END IF; /* 1st Jan */

Line 1330: hr_utility.trace('COUNTY_RS Tax Withheld = NO ');

1326: /*}*/
1327: ELSE /* 1st Jan */
1328: /*{*/
1329: hr_utility.trace('Resident JD Code as of 1st Jan <> Primary JD code as of date');
1330: hr_utility.trace('COUNTY_RS Tax Withheld = NO ');
1331: RETURN('N'); /* the county is not as of 1st Jan */
1332: /*}*/
1333: END IF; /* 1st Jan */
1334: /*} END Indiana State Check */

Line 1349: hr_utility.trace('COUNTY_RS Tax Withheld = '||l_state_local_level_tax);

1345: /*{*/
1346: l_state_local_level_tax := state_local_level_tax(p_tax_unit_id,
1347: l_state_abbrev,
1348: p_juri_code);
1349: hr_utility.trace('COUNTY_RS Tax Withheld = '||l_state_local_level_tax);
1350: RETURN(l_state_local_level_tax);
1351:
1352: ELSE /* tax does not exists */
1353:

Line 1354: hr_utility.trace('COUNTY_RS Tax Withheld = NO ');

1350: RETURN(l_state_local_level_tax);
1351:
1352: ELSE /* tax does not exists */
1353:
1354: hr_utility.trace('COUNTY_RS Tax Withheld = NO ');
1355: RETURN('N');
1356:
1357: END IF; /* tax exists */
1358:

Line 1379: hr_utility.trace('5300 BEGIN TAX TYPE COUNTY_WK');

1375: * please sure that all the conditions are satisfied.
1376: */
1377: ELSIF p_type = 'COUNTY_WK' THEN /* 1 */
1378: /*{*/
1379: hr_utility.trace('5300 BEGIN TAX TYPE COUNTY_WK');
1380: BEGIN
1381: /*{*/
1382: hr_utility.trace('5310 COUNTY_WK P_JURI_CODE ' || p_juri_code);
1383: IF SUBSTR(p_juri_code, 1, 2) = '15' THEN /* check for Indiana state */

Line 1382: hr_utility.trace('5310 COUNTY_WK P_JURI_CODE ' || p_juri_code);

1378: /*{*/
1379: hr_utility.trace('5300 BEGIN TAX TYPE COUNTY_WK');
1380: BEGIN
1381: /*{*/
1382: hr_utility.trace('5310 COUNTY_WK P_JURI_CODE ' || p_juri_code);
1383: IF SUBSTR(p_juri_code, 1, 2) = '15' THEN /* check for Indiana state */
1384: /*{ Changed for Bug 1366176 */
1385: /*
1386: * get RS county and check taxes exists there or no

Line 1388: hr_utility.trace('5320 COUNTY_WK COUNTY IS in State of Indiana ');

1384: /*{ Changed for Bug 1366176 */
1385: /*
1386: * get RS county and check taxes exists there or no
1387: */
1388: hr_utility.trace('5320 COUNTY_WK COUNTY IS in State of Indiana ');
1389: l_rs_county_as_of_1st_jan := get_residence_as_of_1st_jan(p_assign_id,
1390: l_date_earned);
1391: hr_utility.trace('5330 COUNTY_WK Residence as of 1st Jan '|| l_rs_county_as_of_1st_jan);
1392: /*

Line 1391: hr_utility.trace('5330 COUNTY_WK Residence as of 1st Jan '|| l_rs_county_as_of_1st_jan);

1387: */
1388: hr_utility.trace('5320 COUNTY_WK COUNTY IS in State of Indiana ');
1389: l_rs_county_as_of_1st_jan := get_residence_as_of_1st_jan(p_assign_id,
1390: l_date_earned);
1391: hr_utility.trace('5330 COUNTY_WK Residence as of 1st Jan '|| l_rs_county_as_of_1st_jan);
1392: /*
1393: * we need to check if residence state - county is same as
1394: * work state - county. If yes then we calculate taxes at work else we
1395: * need to check the following.

Line 1399: hr_utility.trace('5340 Work County_Code = Resident County_Code as of 1st Jan');

1395: * need to check the following.
1396: */
1397: IF SUBSTR(p_juri_code, 1, 6) = l_rs_county_as_of_1st_jan THEN
1398: /*{*/
1399: hr_utility.trace('5340 Work County_Code = Resident County_Code as of 1st Jan');
1400: IF l_rs_county_as_of_1st_jan <> '00-000' THEN
1401: /*{*/
1402: hr_utility.trace('5350 COUNTY_WK RS County_Code as of 1st Jan '||l_rs_county_as_of_1st_jan);
1403: l_does_tax_exists := does_tax_exists(l_rs_county_as_of_1st_jan,

Line 1402: hr_utility.trace('5350 COUNTY_WK RS County_Code as of 1st Jan '||l_rs_county_as_of_1st_jan);

1398: /*{*/
1399: hr_utility.trace('5340 Work County_Code = Resident County_Code as of 1st Jan');
1400: IF l_rs_county_as_of_1st_jan <> '00-000' THEN
1401: /*{*/
1402: hr_utility.trace('5350 COUNTY_WK RS County_Code as of 1st Jan '||l_rs_county_as_of_1st_jan);
1403: l_does_tax_exists := does_tax_exists(l_rs_county_as_of_1st_jan,
1404: l_date_earned,
1405: p_tax_unit_id,
1406: p_assign_id,

Line 1409: hr_utility.trace('5360 COUNTY_WK Does tax exist for COUNTY RS '

1405: p_tax_unit_id,
1406: p_assign_id,
1407: p_pact_id,
1408: 'COUNTY_RS');
1409: hr_utility.trace('5360 COUNTY_WK Does tax exist for COUNTY RS '
1410: || l_does_tax_exists);
1411: /*
1412: * If residence county has tax, which is same as work county in
1413: * this case. So we will withhold taxes at work county itself

Line 1436: hr_utility.trace('5370 COUNTY_WK COUNTY CODE as of 1st-Jan 00-000');

1432: * that is it is not an Indiana county as of 1st Jan
1433: * so we have to withhold work county taxes.
1434: */
1435: /*{*/
1436: hr_utility.trace('5370 COUNTY_WK COUNTY CODE as of 1st-Jan 00-000');
1437: hr_utility.trace('5380 COUNTY_WK Does tax exist for COUNTY RS '
1438: || l_does_tax_exists);
1439:
1440: RETURN('Y') ;

Line 1437: hr_utility.trace('5380 COUNTY_WK Does tax exist for COUNTY RS '

1433: * so we have to withhold work county taxes.
1434: */
1435: /*{*/
1436: hr_utility.trace('5370 COUNTY_WK COUNTY CODE as of 1st-Jan 00-000');
1437: hr_utility.trace('5380 COUNTY_WK Does tax exist for COUNTY RS '
1438: || l_does_tax_exists);
1439:
1440: RETURN('Y') ;
1441: /*}*/

Line 1446: hr_utility.trace('5390 Work County_Code <> Resident County_Code as of 1st Jan');

1442: END IF; /* l_rs_county_as_of_1st_jan < > '00-000' */
1443: /*}*/
1444: ELSE /* if substr(p_juri_code,1,6) <> l_rs_county_as_of_1st_jan */
1445: /*{*/
1446: hr_utility.trace('5390 Work County_Code <> Resident County_Code as of 1st Jan');
1447: /*Bug#6742101: If payroll period ends in one calendar year and
1448: the check date is in the next following year then date paid should be
1449: used. */
1450: if p_pact_id is not null then

Line 1454: hr_utility.trace('l_across_years '||l_across_years);

1450: if p_pact_id is not null then
1451:
1452: l_across_years := hr_us_ff_udf1.across_calendar_years(p_pact_id);
1453:
1454: hr_utility.trace('l_across_years '||l_across_years);
1455: if (l_across_years = 'Y') then
1456:
1457: select to_char(effective_date,'dd-mm-yyyy')
1458: into l_date

Line 1462: hr_utility.trace('l_date '||to_char(l_date));

1458: into l_date
1459: from pay_payroll_actions
1460: where payroll_action_id = p_pact_id;
1461:
1462: hr_utility.trace('l_date '||to_char(l_date));
1463: else
1464: l_date := l_date_earned;
1465: end if;
1466:

Line 1476: hr_utility.trace('5390 COUNTY_WK Work Location as of 1st Jan '|| p_juri_code);

1472: l_date_earned,
1473: l_date, --l_date_earned,
1474: p_juri_code) THEN
1475: /*Bug#6742101: Changes ends here */
1476: hr_utility.trace('5390 COUNTY_WK Work Location as of 1st Jan '|| p_juri_code);
1477: /*{*/
1478: /*
1479: * Indiana county as of 1st Jan
1480: */

Line 1488: hr_utility.trace('5400 COUNTY_WK returned '

1484: p_assign_id,
1485: p_pact_id,
1486: 'COUNTY_WK' );
1487:
1488: hr_utility.trace('5400 COUNTY_WK returned '
1489: || l_does_tax_exists);
1490: IF l_does_tax_exists = 'Y' THEN
1491: /*{*/
1492: /* get RS county and check taxes exists there or no

Line 1513: hr_utility.trace('5410 COUNTY_WK returned '

1509: p_tax_unit_id,
1510: p_assign_id,
1511: p_pact_id,
1512: 'COUNTY_RS');
1513: hr_utility.trace('5410 COUNTY_WK returned '
1514: || l_does_tax_exists);
1515: /*
1516: * if the residence county has tax then return flase to work
1517: * county because we will withhold tax at residence and not at

Line 1524: hr_utility.trace('5420 COUNTY_WK County Tax Exist Returned ');

1520: * work.
1521: */
1522: IF l_does_tax_exists = 'N' THEN
1523: /*{*/
1524: hr_utility.trace('5420 COUNTY_WK County Tax Exist Returned ');
1525: RETURN('Y');
1526: /*}*/
1527: ELSE
1528: /*{*/

Line 1529: hr_utility.trace('5430 COUNTY_WK County Tax Exist Returned ');

1525: RETURN('Y');
1526: /*}*/
1527: ELSE
1528: /*{*/
1529: hr_utility.trace('5430 COUNTY_WK County Tax Exist Returned ');
1530: RETURN('N');
1531: /*}*/
1532: END IF;
1533: /*}*/

Line 1540: hr_utility.trace('5440 COUNTY_WK As CountyCode 00-000 Tax Exist returned ');

1536: /*
1537: * that is it is not an Indiana county as of 1st Jan
1538: * so we have to withhold work county taxes.
1539: */
1540: hr_utility.trace('5440 COUNTY_WK As CountyCode 00-000 Tax Exist returned ');
1541: RETURN('Y') ;
1542: /*}*/
1543: END IF; /* l_rs_county_as_of_1st_jan '00-000' */
1544: /*}*/

Line 1550: hr_utility.trace('5450 COUNTY_WK There are No Work County Tax So Tax Exist returned '

1546: /*{*/
1547: /*
1548: * there are no work county taxes
1549: */
1550: hr_utility.trace('5450 COUNTY_WK There are No Work County Tax So Tax Exist returned '
1551: ||l_does_tax_exists );
1552: RETURN(l_does_tax_exists);
1553: /*}*/
1554: END IF; /* l_does_tax_exists = 'Y' */

Line 1562: hr_utility.trace('5460 COUNTY_WK As WorkCounty As of 1st Jan is Not-Taxable Tax Exist returned ');

1558: /*
1559: * this is not the county as of 1st Jan so return false to
1560: * COUNTY_WK
1561: */
1562: hr_utility.trace('5460 COUNTY_WK As WorkCounty As of 1st Jan is Not-Taxable Tax Exist returned ');
1563: l_county_wk_exists := 'N';
1564: RETURN l_county_wk_exists;
1565: /*}*/
1566: END IF; /* Indiana county as of 1st Jan */

Line 1572: hr_utility.trace('5470 COUNTY_WK County is not in Indiana ');

1568: END IF; /* substr(p_juri_code,1,6) = l_rs_county_as_of_1st_jan */
1569: /*}*/
1570: ELSE /* check for state Other than Indiana */
1571: /*{*/
1572: hr_utility.trace('5470 COUNTY_WK County is not in Indiana ');
1573: l_county_wk_exists := does_tax_exists(p_juri_code,
1574: l_date_earned,
1575: p_tax_unit_id,
1576: p_assign_id,

Line 1579: hr_utility.trace('5480 COUNTY_WK returned '

1575: p_tax_unit_id,
1576: p_assign_id,
1577: p_pact_id,
1578: 'COUNTY_WK');
1579: hr_utility.trace('5480 COUNTY_WK returned '
1580: ||l_county_wk_exists);
1581: RETURN (l_county_wk_exists);
1582: /*}*/
1583: END IF; /* check for Indiana state */

Line 1587: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 65);

1583: END IF; /* check for Indiana state */
1584: EXCEPTION
1585: WHEN OTHERS THEN
1586: l_county_wk_exists := 'N';
1587: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 65);
1588: hr_utility.trace('5500 COUNTY_WK County Income Tax Exists : ' || l_county_wk_exists);
1589: RETURN l_county_wk_exists;
1590: /*}*/
1591: END; /* COUNTY_WK */

Line 1588: hr_utility.trace('5500 COUNTY_WK County Income Tax Exists : ' || l_county_wk_exists);

1584: EXCEPTION
1585: WHEN OTHERS THEN
1586: l_county_wk_exists := 'N';
1587: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 65);
1588: hr_utility.trace('5500 COUNTY_WK County Income Tax Exists : ' || l_county_wk_exists);
1589: RETURN l_county_wk_exists;
1590: /*}*/
1591: END; /* COUNTY_WK */
1592: /*}*/

Line 1621: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1617: IF l_city_rs_exists = 'Y' THEN /* 2 jit level */
1618: --{
1619: BEGIN /* see if the state has taxes in the ct setup */
1620: --{
1621: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1622: 70);
1623: hr_utility.trace('determining if the state is set up by the ct');
1624: l_city_rs_exists := get_tax_exists(p_juri_code,
1625: p_date_earned,

Line 1623: hr_utility.trace('determining if the state is set up by the ct');

1619: BEGIN /* see if the state has taxes in the ct setup */
1620: --{
1621: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1622: 70);
1623: hr_utility.trace('determining if the state is set up by the ct');
1624: l_city_rs_exists := get_tax_exists(p_juri_code,
1625: p_date_earned,
1626: p_tax_unit_id,
1627: p_assign_id,

Line 1630: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1626: p_tax_unit_id,
1627: p_assign_id,
1628: p_pact_id,
1629: 'SIT_RS');
1630: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1631: 71);
1632: hr_utility.trace('Is the state withholding taxes ? '
1633: ||l_city_rs_exists);
1634: IF l_city_rs_exists = 'Y' THEN /* 3 */

Line 1632: hr_utility.trace('Is the state withholding taxes ? '

1628: p_pact_id,
1629: 'SIT_RS');
1630: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1631: 71);
1632: hr_utility.trace('Is the state withholding taxes ? '
1633: ||l_city_rs_exists);
1634: IF l_city_rs_exists = 'Y' THEN /* 3 */
1635: --
1636: -- The state is taking taxes

Line 1680: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists'

1676: FROM HR_ORGANIZATION_INFORMATION hoi
1677: WHERE hoi.ORG_INFORMATION_CONTEXT = 'Local Tax Rules'
1678: AND hoi.organization_id = p_tax_unit_id
1679: AND hoi.org_information1 = p_juri_code;
1680: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists'
1681: , 72);
1682: hr_utility.trace('City Income Tax Exists : ' ||
1683: l_city_rs_exists);
1684: RETURN l_city_rs_exists;

Line 1682: hr_utility.trace('City Income Tax Exists : ' ||

1678: AND hoi.organization_id = p_tax_unit_id
1679: AND hoi.org_information1 = p_juri_code;
1680: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists'
1681: , 72);
1682: hr_utility.trace('City Income Tax Exists : ' ||
1683: l_city_rs_exists);
1684: RETURN l_city_rs_exists;
1685: EXCEPTION
1686: WHEN OTHERS THEN

Line 1690: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists'

1686: WHEN OTHERS THEN
1687: /*
1688: * If there is no value then return l_city_rs_exists = 'Y'
1689: */
1690: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists'
1691: , 73);
1692: -- added for Bug # 4711572
1693: if l_local_tax_rules_type = 'LOCALITIES'
1694: then

Line 1696: hr_utility.trace('CITY_RS Jurisdiction Type : '||l_jd_type);

1692: -- added for Bug # 4711572
1693: if l_local_tax_rules_type = 'LOCALITIES'
1694: then
1695: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);
1696: hr_utility.trace('CITY_RS Jurisdiction Type : '||l_jd_type);
1697: -- if (nvl(l_jd_type,'NL') = 'RW')
1698: /*Modified for bug 7353397 to include Work at home scenario
1699: for caluclating taxes when 'Only Locatlites Under Local Tax Rules'
1700: is selected at GRE level */

Line 1703: hr_utility.trace('CITY_RS City Income Tax Exists set to withhold Tax: Y');

1699: for caluclating taxes when 'Only Locatlites Under Local Tax Rules'
1700: is selected at GRE level */
1701: if (nvl(l_jd_type,'NL') = 'RW' or nvl(l_jd_type,'NL') = 'HW' )
1702: then
1703: hr_utility.trace('CITY_RS City Income Tax Exists set to withhold Tax: Y');
1704: return('Y');
1705: else
1706: hr_utility.trace('CITY_RS City Income Tax Exists : ' ||
1707: l_wh_work_localities);

Line 1706: hr_utility.trace('CITY_RS City Income Tax Exists : ' ||

1702: then
1703: hr_utility.trace('CITY_RS City Income Tax Exists set to withhold Tax: Y');
1704: return('Y');
1705: else
1706: hr_utility.trace('CITY_RS City Income Tax Exists : ' ||
1707: l_wh_work_localities);
1708: RETURN l_org_info19;
1709: end if;
1710: else

Line 1711: hr_utility.trace('City Income Tax Exists : ' || l_org_info19);

1707: l_wh_work_localities);
1708: RETURN l_org_info19;
1709: end if;
1710: else
1711: hr_utility.trace('City Income Tax Exists : ' || l_org_info19);
1712: RETURN l_org_info19;
1713: end if;
1714: --}
1715: END; /* end check for locality exemption */

Line 1720: hr_utility.set_location(

1716: ELSE /* 3.1 */
1717: /* If Employer setup for State's Resident Tax is Only Withhold Tax at Work Location
1718: return No, so that Resident tax is not withhold for the resident jurisdiction
1719: */
1720: hr_utility.set_location(
1721: 'py_gt_tax_exists_pkg.get_tax_exists', 75);
1722: -- This is added to tax a jurisdiction if it is tagged OR
1723: -- resident jurisdiction is same Work
1724: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);

Line 1725: hr_utility.trace('CITY_RS Jurisdiction Type : '||l_jd_type);

1721: 'py_gt_tax_exists_pkg.get_tax_exists', 75);
1722: -- This is added to tax a jurisdiction if it is tagged OR
1723: -- resident jurisdiction is same Work
1724: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);
1725: hr_utility.trace('CITY_RS Jurisdiction Type : '||l_jd_type);
1726: if (nvl(l_jd_type,'NL') = 'RT' OR
1727: nvl(l_jd_type,'NL') = 'RW' OR
1728: nvl(l_jd_type,'NL') = 'HW' )then -- added for Bug # 4463475
1729: hr_utility.trace('CITY_RS City Income Tax Exists set to withhold Tax: Y');

Line 1729: hr_utility.trace('CITY_RS City Income Tax Exists set to withhold Tax: Y');

1725: hr_utility.trace('CITY_RS Jurisdiction Type : '||l_jd_type);
1726: if (nvl(l_jd_type,'NL') = 'RT' OR
1727: nvl(l_jd_type,'NL') = 'RW' OR
1728: nvl(l_jd_type,'NL') = 'HW' )then -- added for Bug # 4463475
1729: hr_utility.trace('CITY_RS City Income Tax Exists set to withhold Tax: Y');
1730: return('Y');
1731: else
1732: hr_utility.trace('CITY_RS City Income Tax Exists : ' ||
1733: l_wh_work_localities);

Line 1732: hr_utility.trace('CITY_RS City Income Tax Exists : ' ||

1728: nvl(l_jd_type,'NL') = 'HW' )then -- added for Bug # 4463475
1729: hr_utility.trace('CITY_RS City Income Tax Exists set to withhold Tax: Y');
1730: return('Y');
1731: else
1732: hr_utility.trace('CITY_RS City Income Tax Exists : ' ||
1733: l_wh_work_localities);
1734: RETURN l_wh_work_localities;
1735: end if;
1736: END IF; /* 3.1 */

Line 1741: hr_utility.set_location(

1737: END;
1738: EXCEPTION /* The ct has nothing at the EI level set up */
1739: WHEN OTHERS THEN
1740: l_city_rs_exists := 'Y';
1741: hr_utility.set_location(
1742: 'py_gt_tax_exists_pkg.get_tax_exists', 76);
1743: hr_utility.trace(
1744: 'City Income Tax Exists : ' || l_city_rs_exists);
1745: RETURN l_city_rs_exists;

Line 1743: hr_utility.trace(

1739: WHEN OTHERS THEN
1740: l_city_rs_exists := 'Y';
1741: hr_utility.set_location(
1742: 'py_gt_tax_exists_pkg.get_tax_exists', 76);
1743: hr_utility.trace(
1744: 'City Income Tax Exists : ' || l_city_rs_exists);
1745: RETURN l_city_rs_exists;
1746: --}
1747: END; /* end for city_exists = Y */

Line 1754: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1750: /*
1751: * The state is not withholding or is not setup no city tax
1752: */
1753: --{
1754: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1755: 77);
1756: hr_utility.trace('City Income Tax Exists : ' ||
1757: l_city_rs_exists);
1758: RETURN l_city_rs_exists;

Line 1756: hr_utility.trace('City Income Tax Exists : ' ||

1752: */
1753: --{
1754: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1755: 77);
1756: hr_utility.trace('City Income Tax Exists : ' ||
1757: l_city_rs_exists);
1758: RETURN l_city_rs_exists;
1759: --}
1760: END IF; /* 3 */

Line 1772: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 78);

1768: END IF; /* 2 jit level */
1769: EXCEPTION /* No rows in the city jit table */
1770: WHEN OTHERS THEN
1771: l_city_rs_exists := 'N';
1772: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 78);
1773: hr_utility.trace('City Income Tax Exists : ' || l_city_rs_exists);
1774: RETURN l_city_rs_exists;
1775: --}
1776: END; /* CITY_RS */

Line 1773: hr_utility.trace('City Income Tax Exists : ' || l_city_rs_exists);

1769: EXCEPTION /* No rows in the city jit table */
1770: WHEN OTHERS THEN
1771: l_city_rs_exists := 'N';
1772: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 78);
1773: hr_utility.trace('City Income Tax Exists : ' || l_city_rs_exists);
1774: RETURN l_city_rs_exists;
1775: --}
1776: END; /* CITY_RS */
1777: --}

Line 1802: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1798: IF l_ht_wk_exists = 'Y' THEN /* 2 jit level */
1799: /*{*/
1800: BEGIN /* see if the state has taxes in the ct setup */
1801: /*{*/
1802: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1803: 180);
1804: hr_utility.trace('determining if the state is set up by the ct');
1805:
1806: l_ht_wk_exists := get_tax_exists(p_juri_code,

Line 1804: hr_utility.trace('determining if the state is set up by the ct');

1800: BEGIN /* see if the state has taxes in the ct setup */
1801: /*{*/
1802: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1803: 180);
1804: hr_utility.trace('determining if the state is set up by the ct');
1805:
1806: l_ht_wk_exists := get_tax_exists(p_juri_code,
1807: p_date_earned,
1808: p_tax_unit_id,

Line 1813: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1809: p_assign_id,
1810: p_pact_id,
1811: 'SIT_WK');
1812:
1813: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1814: 181);
1815: hr_utility.trace('Is the state withholding taxes ? '||
1816: l_ht_wk_exists);
1817:

Line 1815: hr_utility.trace('Is the state withholding taxes ? '||

1811: 'SIT_WK');
1812:
1813: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1814: 181);
1815: hr_utility.trace('Is the state withholding taxes ? '||
1816: l_ht_wk_exists);
1817:
1818: IF l_ht_wk_exists = 'Y' THEN /* 3 The state is taking taxes */
1819: /*{*/

Line 1820: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1816: l_ht_wk_exists);
1817:
1818: IF l_ht_wk_exists = 'Y' THEN /* 3 The state is taking taxes */
1819: /*{*/
1820: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1821: 182);
1822: hr_utility.trace('Head Tax Exists : ' || l_ht_wk_exists);
1823: RETURN l_ht_wk_exists;
1824: /*}*/

Line 1822: hr_utility.trace('Head Tax Exists : ' || l_ht_wk_exists);

1818: IF l_ht_wk_exists = 'Y' THEN /* 3 The state is taking taxes */
1819: /*{*/
1820: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1821: 182);
1822: hr_utility.trace('Head Tax Exists : ' || l_ht_wk_exists);
1823: RETURN l_ht_wk_exists;
1824: /*}*/
1825: ELSE /* 3 */
1826: /*

Line 1830: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1826: /*
1827: * The state is not withholding or is not setup no head tax
1828: */
1829: /*{*/
1830: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1831: 183);
1832: hr_utility.trace('Head Tax Exists : ' || l_ht_wk_exists);
1833:
1834: RETURN l_ht_wk_exists;

Line 1832: hr_utility.trace('Head Tax Exists : ' || l_ht_wk_exists);

1828: */
1829: /*{*/
1830: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1831: 183);
1832: hr_utility.trace('Head Tax Exists : ' || l_ht_wk_exists);
1833:
1834: RETURN l_ht_wk_exists;
1835: /*}*/
1836: END IF; /* 3 */

Line 1848: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 184);

1844: END IF; /* 2 jit level */
1845: EXCEPTION /* No rows in the city jit table */
1846: WHEN OTHERS THEN
1847: l_ht_wk_exists := 'N';
1848: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 184);
1849: hr_utility.trace('Head Tax Exists : ' || l_ht_wk_exists);
1850: RETURN l_ht_wk_exists;
1851: /*}*/
1852: END; /* HT_WK */

Line 1849: hr_utility.trace('Head Tax Exists : ' || l_ht_wk_exists);

1845: EXCEPTION /* No rows in the city jit table */
1846: WHEN OTHERS THEN
1847: l_ht_wk_exists := 'N';
1848: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 184);
1849: hr_utility.trace('Head Tax Exists : ' || l_ht_wk_exists);
1850: RETURN l_ht_wk_exists;
1851: /*}*/
1852: END; /* HT_WK */
1853: /*}*/

Line 1877: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1873: IF l_city_wk_exists = 'Y' THEN /* 2 jit level */
1874: /*{*/
1875: BEGIN /* see if the state has taxes in the ct setup */
1876: /*{*/
1877: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1878: 80);
1879: hr_utility.trace('determining if the state is set up by the ct');
1880:
1881: l_city_wk_exists := get_tax_exists(p_juri_code,

Line 1879: hr_utility.trace('determining if the state is set up by the ct');

1875: BEGIN /* see if the state has taxes in the ct setup */
1876: /*{*/
1877: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1878: 80);
1879: hr_utility.trace('determining if the state is set up by the ct');
1880:
1881: l_city_wk_exists := get_tax_exists(p_juri_code,
1882: p_date_earned,
1883: p_tax_unit_id,

Line 1889: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1885: p_pact_id,
1886: 'SIT_WK',
1887: 'CITY_WK');
1888:
1889: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1890: 81);
1891: hr_utility.trace('Is the state withholding taxes ? '
1892: ||l_city_wk_exists);
1893:

Line 1891: hr_utility.trace('Is the state withholding taxes ? '

1887: 'CITY_WK');
1888:
1889: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1890: 81);
1891: hr_utility.trace('Is the state withholding taxes ? '
1892: ||l_city_wk_exists);
1893:
1894: IF l_city_wk_exists = 'Y' THEN /* 3 */
1895: /*

Line 1899: hr_utility.set_location('py_get_tax_exists_pkg.get_tax_exists',

1895: /*
1896: * The state is taking taxes
1897: */
1898: /*{*/
1899: hr_utility.set_location('py_get_tax_exists_pkg.get_tax_exists',
1900: 82);
1901: hr_utility.trace('City Income Tax Exists : ' ||
1902: l_city_wk_exists);
1903: RETURN l_city_wk_exists;

Line 1901: hr_utility.trace('City Income Tax Exists : ' ||

1897: */
1898: /*{*/
1899: hr_utility.set_location('py_get_tax_exists_pkg.get_tax_exists',
1900: 82);
1901: hr_utility.trace('City Income Tax Exists : ' ||
1902: l_city_wk_exists);
1903: RETURN l_city_wk_exists;
1904:
1905: /*}*/

Line 1911: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists',

1907: /*
1908: * The state is not withholding or is not setup no city tax
1909: */
1910: /*{*/
1911: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists',
1912: 83);
1913: hr_utility.trace('City Income Tax Exists : '
1914: || l_city_wk_exists);
1915:

Line 1913: hr_utility.trace('City Income Tax Exists : '

1909: */
1910: /*{*/
1911: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists',
1912: 83);
1913: hr_utility.trace('City Income Tax Exists : '
1914: || l_city_wk_exists);
1915:
1916: RETURN l_city_wk_exists;
1917:

Line 1931: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists', 84);

1927: END IF; /* 2 jit level */
1928: EXCEPTION /* No rows in the city jit table */
1929: WHEN OTHERS THEN
1930: l_city_wk_exists := 'N';
1931: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists', 84);
1932: hr_utility.trace('City Income Tax Exists : ' || l_city_wk_exists);
1933: RETURN l_city_wk_exists;
1934: /*}*/
1935: END; /* CITY_WK */

Line 1932: hr_utility.trace('City Income Tax Exists : ' || l_city_wk_exists);

1928: EXCEPTION /* No rows in the city jit table */
1929: WHEN OTHERS THEN
1930: l_city_wk_exists := 'N';
1931: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists', 84);
1932: hr_utility.trace('City Income Tax Exists : ' || l_city_wk_exists);
1933: RETURN l_city_wk_exists;
1934: /*}*/
1935: END; /* CITY_WK */
1936: /*}*/

Line 1960: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',

1956: /*
1957: * we do not withhold, have to switch this to N for return to SIT
1958: */
1959: /*{*/
1960: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1961: 90);
1962: hr_utility.trace('NR Exists before need to return opp. to SIT : '
1963: ||l_nr_exists);
1964: l_sit_rs_exists := 'N';

Line 1962: hr_utility.trace('NR Exists before need to return opp. to SIT : '

1958: */
1959: /*{*/
1960: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists',
1961: 90);
1962: hr_utility.trace('NR Exists before need to return opp. to SIT : '
1963: ||l_nr_exists);
1964: l_sit_rs_exists := 'N';
1965:
1966: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists', 91);

Line 1966: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists', 91);

1962: hr_utility.trace('NR Exists before need to return opp. to SIT : '
1963: ||l_nr_exists);
1964: l_sit_rs_exists := 'N';
1965:
1966: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists', 91);
1967: hr_utility.trace('SIT Exists after switched the return from NR : '
1968: ||l_sit_rs_exists);
1969:
1970: RETURN l_sit_rs_exists;

Line 1967: hr_utility.trace('SIT Exists after switched the return from NR : '

1963: ||l_nr_exists);
1964: l_sit_rs_exists := 'N';
1965:
1966: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists', 91);
1967: hr_utility.trace('SIT Exists after switched the return from NR : '
1968: ||l_sit_rs_exists);
1969:
1970: RETURN l_sit_rs_exists;
1971:

Line 1978: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists', 92);

1974: /*
1975: * the nr cert is not checked, the value stored is N in the table
1976: */
1977: /*{*/
1978: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists', 92);
1979: hr_utility.trace('NR Exist before need to return opp. to SIT: '
1980: ||l_nr_exists);
1981:
1982: l_sit_rs_exists := 'Y';

Line 1979: hr_utility.trace('NR Exist before need to return opp. to SIT: '

1975: * the nr cert is not checked, the value stored is N in the table
1976: */
1977: /*{*/
1978: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists', 92);
1979: hr_utility.trace('NR Exist before need to return opp. to SIT: '
1980: ||l_nr_exists);
1981:
1982: l_sit_rs_exists := 'Y';
1983:

Line 1984: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists', 93);

1980: ||l_nr_exists);
1981:
1982: l_sit_rs_exists := 'Y';
1983:
1984: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists', 93);
1985: hr_utility.trace('SIT Exists after we switched the ret. from NR: '
1986: ||l_sit_rs_exists);
1987:
1988: RETURN l_sit_rs_exists;

Line 1985: hr_utility.trace('SIT Exists after we switched the ret. from NR: '

1981:
1982: l_sit_rs_exists := 'Y';
1983:
1984: hr_utility.set_location('py_gt_tx_exists_pkg.get_tax_exists', 93);
1985: hr_utility.trace('SIT Exists after we switched the ret. from NR: '
1986: ||l_sit_rs_exists);
1987:
1988: RETURN l_sit_rs_exists;
1989:

Line 1995: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists', 94);

1991: END IF; /* 2 */
1992: EXCEPTION
1993: WHEN OTHERS THEN
1994: l_nr_exists := 'N';
1995: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists', 94);
1996: hr_utility.trace('NR Exists before need to return opp. to SIT: '
1997: ||l_nr_exists);
1998:
1999: l_sit_rs_exists := 'Y';

Line 1996: hr_utility.trace('NR Exists before need to return opp. to SIT: '

1992: EXCEPTION
1993: WHEN OTHERS THEN
1994: l_nr_exists := 'N';
1995: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists', 94);
1996: hr_utility.trace('NR Exists before need to return opp. to SIT: '
1997: ||l_nr_exists);
1998:
1999: l_sit_rs_exists := 'Y';
2000:

Line 2001: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists', 95);

1997: ||l_nr_exists);
1998:
1999: l_sit_rs_exists := 'Y';
2000:
2001: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists', 95);
2002: hr_utility.trace('SIT Exists after we switched the ret. from NR : '
2003: ||l_sit_rs_exists);
2004:
2005: RETURN l_sit_rs_exists;

Line 2002: hr_utility.trace('SIT Exists after we switched the ret. from NR : '

1998:
1999: l_sit_rs_exists := 'Y';
2000:
2001: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists', 95);
2002: hr_utility.trace('SIT Exists after we switched the ret. from NR : '
2003: ||l_sit_rs_exists);
2004:
2005: RETURN l_sit_rs_exists;
2006: /*}*/

Line 2036: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists',

2032: AND hoi.org_information2 IS NOT NULL;
2033:
2034: IF l_sui_exists = 'N' THEN /* 2 */
2035: /*{*/
2036: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists',
2037: 100);
2038: hr_utility.trace('SUI EE Exists : ' || l_sui_exists);
2039:
2040: RETURN l_sui_exists;

Line 2038: hr_utility.trace('SUI EE Exists : ' || l_sui_exists);

2034: IF l_sui_exists = 'N' THEN /* 2 */
2035: /*{*/
2036: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists',
2037: 100);
2038: hr_utility.trace('SUI EE Exists : ' || l_sui_exists);
2039:
2040: RETURN l_sui_exists;
2041: /*}*/
2042: ELSE /* 2 */

Line 2045: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists',

2041: /*}*/
2042: ELSE /* 2 */
2043: /*{*/
2044: l_sui_exists := 'Y';
2045: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists',
2046: 101);
2047: hr_utility.trace('SUI EE Exists : ' || l_sui_exists);
2048:
2049: RETURN l_sui_exists;

Line 2047: hr_utility.trace('SUI EE Exists : ' || l_sui_exists);

2043: /*{*/
2044: l_sui_exists := 'Y';
2045: hr_utility.set_location('py_gt_tax_exists_pkg.get_tax_exists',
2046: 101);
2047: hr_utility.trace('SUI EE Exists : ' || l_sui_exists);
2048:
2049: RETURN l_sui_exists;
2050:
2051: /*}*/

Line 2056: hr_utility.set_location('py_get_tax_exists_pkg.get_tax_exists',

2052: END IF; /* 2 */
2053: EXCEPTION
2054: WHEN NO_DATA_FOUND THEN
2055: l_sui_exists := 'Y';
2056: hr_utility.set_location('py_get_tax_exists_pkg.get_tax_exists',
2057: 102);
2058: hr_utility.trace('SUI EE Exists : ' || l_sui_exists);
2059: RETURN l_sui_exists;
2060: /*}*/

Line 2058: hr_utility.trace('SUI EE Exists : ' || l_sui_exists);

2054: WHEN NO_DATA_FOUND THEN
2055: l_sui_exists := 'Y';
2056: hr_utility.set_location('py_get_tax_exists_pkg.get_tax_exists',
2057: 102);
2058: hr_utility.trace('SUI EE Exists : ' || l_sui_exists);
2059: RETURN l_sui_exists;
2060: /*}*/
2061: END;
2062: /*}*/

Line 2081: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 110);

2077: END IF; /* chk_product_install */
2078: EXCEPTION
2079: WHEN OTHERS THEN
2080: l_exists := 'Y';
2081: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 110);
2082: hr_utility.trace('The main Exception handler was called and returns '
2083: ||'tax exists: '||l_exists);
2084: RETURN l_exists;
2085: -- hr_utility.trace_off;

Line 2082: hr_utility.trace('The main Exception handler was called and returns '

2078: EXCEPTION
2079: WHEN OTHERS THEN
2080: l_exists := 'Y';
2081: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 110);
2082: hr_utility.trace('The main Exception handler was called and returns '
2083: ||'tax exists: '||l_exists);
2084: RETURN l_exists;
2085: -- hr_utility.trace_off;
2086: /*}*/

Line 2085: -- hr_utility.trace_off;

2081: hr_utility.set_location('pay_get_tax_exists_pkg.get_tax_exists', 110);
2082: hr_utility.trace('The main Exception handler was called and returns '
2083: ||'tax exists: '||l_exists);
2084: RETURN l_exists;
2085: -- hr_utility.trace_off;
2086: /*}*/
2087: END get_tax_exists;
2088:
2089:

Line 2215: hr_utility.trace('The tax type : '|| p_type);

2211: l_jit8_rule_nobypass := 'NOBYPASS'; /* Do not bypass the tax - pass JIT
2212: 08 along with earnings to Vertex */
2213: l_date_earned := to_char(p_date_earned,'DD-MM-YYYY');
2214:
2215: hr_utility.trace('The tax type : '|| p_type);
2216: hr_utility.trace('The jurisdiction : '|| p_juri_code);
2217: hr_utility.trace('The date earned : '|| l_date_earned);
2218: hr_utility.trace('The tax unit id : '|| to_char(p_tax_unit_id));
2219: hr_utility.trace('The assignment id : '|| to_char(p_assign_id));

Line 2216: hr_utility.trace('The jurisdiction : '|| p_juri_code);

2212: 08 along with earnings to Vertex */
2213: l_date_earned := to_char(p_date_earned,'DD-MM-YYYY');
2214:
2215: hr_utility.trace('The tax type : '|| p_type);
2216: hr_utility.trace('The jurisdiction : '|| p_juri_code);
2217: hr_utility.trace('The date earned : '|| l_date_earned);
2218: hr_utility.trace('The tax unit id : '|| to_char(p_tax_unit_id));
2219: hr_utility.trace('The assignment id : '|| to_char(p_assign_id));
2220:

Line 2217: hr_utility.trace('The date earned : '|| l_date_earned);

2213: l_date_earned := to_char(p_date_earned,'DD-MM-YYYY');
2214:
2215: hr_utility.trace('The tax type : '|| p_type);
2216: hr_utility.trace('The jurisdiction : '|| p_juri_code);
2217: hr_utility.trace('The date earned : '|| l_date_earned);
2218: hr_utility.trace('The tax unit id : '|| to_char(p_tax_unit_id));
2219: hr_utility.trace('The assignment id : '|| to_char(p_assign_id));
2220:
2221: SELECT DISTINCT pus.state_abbrev

Line 2218: hr_utility.trace('The tax unit id : '|| to_char(p_tax_unit_id));

2214:
2215: hr_utility.trace('The tax type : '|| p_type);
2216: hr_utility.trace('The jurisdiction : '|| p_juri_code);
2217: hr_utility.trace('The date earned : '|| l_date_earned);
2218: hr_utility.trace('The tax unit id : '|| to_char(p_tax_unit_id));
2219: hr_utility.trace('The assignment id : '|| to_char(p_assign_id));
2220:
2221: SELECT DISTINCT pus.state_abbrev
2222: INTO l_state_abbrev

Line 2219: hr_utility.trace('The assignment id : '|| to_char(p_assign_id));

2215: hr_utility.trace('The tax type : '|| p_type);
2216: hr_utility.trace('The jurisdiction : '|| p_juri_code);
2217: hr_utility.trace('The date earned : '|| l_date_earned);
2218: hr_utility.trace('The tax unit id : '|| to_char(p_tax_unit_id));
2219: hr_utility.trace('The assignment id : '|| to_char(p_assign_id));
2220:
2221: SELECT DISTINCT pus.state_abbrev
2222: INTO l_state_abbrev
2223: FROM pay_us_states pus

Line 2226: hr_utility.trace('The state abbrev is:' || l_state_abbrev);

2222: INTO l_state_abbrev
2223: FROM pay_us_states pus
2224: WHERE pus.state_code = SUBSTR(p_juri_code, 1, 2);
2225:
2226: hr_utility.trace('The state abbrev is:' || l_state_abbrev);
2227:
2228: IF p_type = 'SIT_RS' THEN
2229: BEGIN
2230:

Line 2328: hr_utility.trace('Jurisdiction Type : '||l_jd_type);

2324: CLOSE local_rule;
2325: IF l_state_rule_for_local = 'L' THEN
2326:
2327: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);
2328: hr_utility.trace('Jurisdiction Type : '||l_jd_type);
2329:
2330: IF (nvl(l_jd_type,'NL') = 'RT' OR
2331: nvl(l_jd_type,'NL') = 'RW' OR
2332: nvl(l_jd_type,'NL') = 'HW' OR

Line 2359: hr_utility.trace('Jurisdiction Type : '||l_jd_type);

2355:
2356: IF l_local_rule = 'Y' THEN
2357:
2358: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);
2359: hr_utility.trace('Jurisdiction Type : '||l_jd_type);
2360:
2361: IF (nvl(l_jd_type,'NL') = 'RT' OR
2362: nvl(l_jd_type,'NL') = 'RW' OR
2363: nvl(l_jd_type,'NL') = 'HW' OR

Line 2405: hr_utility.trace('Jurisdiction Type : '||l_jd_type);

2401:
2402: IF l_local_rule = 'Y' THEN
2403:
2404: l_jd_type := hr_us_ff_udf1.get_jurisdiction_type(p_juri_code);
2405: hr_utility.trace('Jurisdiction Type : '||l_jd_type);
2406:
2407: IF (nvl(l_jd_type,'NL') = 'RT' OR
2408: nvl(l_jd_type,'NL') = 'RW' OR
2409: nvl(l_jd_type,'NL') = 'HW' OR

Line 2457: hr_utility.trace('l_indiana_override '||l_indiana_override);

2453:
2454: OPEN override_state;
2455: FETCH override_state INTO l_indiana_override;
2456:
2457: hr_utility.trace('l_indiana_override '||l_indiana_override);
2458: IF override_state%found THEN
2459:
2460: l_across_years := hr_us_ff_udf1.across_calendar_years(p_pact_id);
2461:

Line 2462: hr_utility.trace('l_across_years '||l_across_years);

2458: IF override_state%found THEN
2459:
2460: l_across_years := hr_us_ff_udf1.across_calendar_years(p_pact_id);
2461:
2462: hr_utility.trace('l_across_years '||l_across_years);
2463: IF (l_indiana_override = 'IN' AND
2464: l_across_years = 'Y') THEN
2465:
2466: SELECT to_char(effective_date,'dd-mm-yyyy')

Line 2471: hr_utility.trace('l_date '||to_char(l_date));

2467: INTO l_date
2468: FROM pay_payroll_actions
2469: WHERE payroll_action_id = p_pact_id;
2470:
2471: hr_utility.trace('l_date '||to_char(l_date));
2472: ELSE
2473: l_date := l_date_earned;
2474: END IF;
2475:

Line 2489: hr_utility.trace('Resident State is Indiana Jurisdiction '||p_juri_code);

2485:
2486: l_rs_coty_1st_jan := get_residence_as_of_1st_jan(p_assign_id,
2487: l_date);
2488:
2489: hr_utility.trace('Resident State is Indiana Jurisdiction '||p_juri_code);
2490: hr_utility.trace('Resident JD Code as of 1st Jan '|| l_rs_coty_1st_jan);
2491:
2492: IF l_rs_coty_1st_jan = SUBSTR(p_juri_code, 1, 6) THEN
2493:

Line 2490: hr_utility.trace('Resident JD Code as of 1st Jan '|| l_rs_coty_1st_jan);

2486: l_rs_coty_1st_jan := get_residence_as_of_1st_jan(p_assign_id,
2487: l_date);
2488:
2489: hr_utility.trace('Resident State is Indiana Jurisdiction '||p_juri_code);
2490: hr_utility.trace('Resident JD Code as of 1st Jan '|| l_rs_coty_1st_jan);
2491:
2492: IF l_rs_coty_1st_jan = SUBSTR(p_juri_code, 1, 6) THEN
2493:
2494: OPEN county_exists;

Line 2515: hr_utility.trace('Resident JD Code as of 1st Jan <> Primary JD code as of date');

2511: END IF;
2512:
2513: ELSE /* 1st Jan */
2514:
2515: hr_utility.trace('Resident JD Code as of 1st Jan <> Primary JD code as of date');
2516:
2517: RETURN l_jit8_rule; /* the county is not as of 1st Jan */
2518:
2519: END IF; /* 1st Jan */

Line 2677: hr_utility.trace('Endering get_wage_accumulation_flag');

2673: WHERE parameter_name = 'WAGE_ACCUMULATION_YEAR';
2674:
2675: BEGIN
2676:
2677: hr_utility.trace('Endering get_wage_accumulation_flag');
2678:
2679: OPEN get_wage_acc_flag;
2680: FETCH get_wage_acc_flag INTO l_wage_accumulation_flag;
2681:

Line 2684: hr_utility.trace('get_wage_acc_flag%NOTFOUND');

2680: FETCH get_wage_acc_flag INTO l_wage_accumulation_flag;
2681:
2682: IF get_wage_acc_flag%NOTFOUND THEN
2683:
2684: hr_utility.trace('get_wage_acc_flag%NOTFOUND');
2685:
2686: l_wage_accumulation_flag := 'N';
2687: ELSE
2688: hr_utility.trace('get_wage_acc_flag%FOUND');

Line 2688: hr_utility.trace('get_wage_acc_flag%FOUND');

2684: hr_utility.trace('get_wage_acc_flag%NOTFOUND');
2685:
2686: l_wage_accumulation_flag := 'N';
2687: ELSE
2688: hr_utility.trace('get_wage_acc_flag%FOUND');
2689: IF l_wage_accumulation_flag = 'Y' THEN
2690:
2691: hr_utility.trace('l_wage_accumulation_flag = Y');
2692: hr_utility.trace('Need to check if WAGE_ACCUMULATION_YEAR IS SET AND COMPARE');

Line 2691: hr_utility.trace('l_wage_accumulation_flag = Y');

2687: ELSE
2688: hr_utility.trace('get_wage_acc_flag%FOUND');
2689: IF l_wage_accumulation_flag = 'Y' THEN
2690:
2691: hr_utility.trace('l_wage_accumulation_flag = Y');
2692: hr_utility.trace('Need to check if WAGE_ACCUMULATION_YEAR IS SET AND COMPARE');
2693:
2694: OPEN get_wage_acc_year;
2695: FETCH get_wage_acc_year INTO l_wa_year;

Line 2692: hr_utility.trace('Need to check if WAGE_ACCUMULATION_YEAR IS SET AND COMPARE');

2688: hr_utility.trace('get_wage_acc_flag%FOUND');
2689: IF l_wage_accumulation_flag = 'Y' THEN
2690:
2691: hr_utility.trace('l_wage_accumulation_flag = Y');
2692: hr_utility.trace('Need to check if WAGE_ACCUMULATION_YEAR IS SET AND COMPARE');
2693:
2694: OPEN get_wage_acc_year;
2695: FETCH get_wage_acc_year INTO l_wa_year;
2696:

Line 2699: hr_utility.trace('get_wage_acc_year%NOTFOUND no change to l_wage_accumulation_flag');

2695: FETCH get_wage_acc_year INTO l_wa_year;
2696:
2697: IF get_wage_acc_year%NOTFOUND THEN
2698:
2699: hr_utility.trace('get_wage_acc_year%NOTFOUND no change to l_wage_accumulation_flag');
2700:
2701: ELSE
2702:
2703: hr_utility.trace('get_wage_acc_year%FOUND compare to payroll effective date ');

Line 2703: hr_utility.trace('get_wage_acc_year%FOUND compare to payroll effective date ');

2699: hr_utility.trace('get_wage_acc_year%NOTFOUND no change to l_wage_accumulation_flag');
2700:
2701: ELSE
2702:
2703: hr_utility.trace('get_wage_acc_year%FOUND compare to payroll effective date ');
2704:
2705: l_wa_date := to_date('01-01-' || l_wa_year, 'dd-mm-yyyy');
2706:
2707: hr_utility.trace('l_wa_date = ' || to_char(l_wa_date, 'dd-mon-yyyy') );

Line 2707: hr_utility.trace('l_wa_date = ' || to_char(l_wa_date, 'dd-mon-yyyy') );

2703: hr_utility.trace('get_wage_acc_year%FOUND compare to payroll effective date ');
2704:
2705: l_wa_date := to_date('01-01-' || l_wa_year, 'dd-mm-yyyy');
2706:
2707: hr_utility.trace('l_wa_date = ' || to_char(l_wa_date, 'dd-mon-yyyy') );
2708:
2709: SELECT effective_date
2710: INTO l_effective_date
2711: FROM pay_payroll_actions

Line 2714: hr_utility.trace('l_effective_date = ' || to_char(l_effective_date,

2710: INTO l_effective_date
2711: FROM pay_payroll_actions
2712: WHERE payroll_action_id = p_pact_id;
2713:
2714: hr_utility.trace('l_effective_date = ' || to_char(l_effective_date,
2715: 'dd-mon-yyyy') );
2716:
2717: IF l_effective_date >= l_wa_date THEN
2718: hr_utility.trace('l_effective_date >= l_wa_date ' );

Line 2718: hr_utility.trace('l_effective_date >= l_wa_date ' );

2714: hr_utility.trace('l_effective_date = ' || to_char(l_effective_date,
2715: 'dd-mon-yyyy') );
2716:
2717: IF l_effective_date >= l_wa_date THEN
2718: hr_utility.trace('l_effective_date >= l_wa_date ' );
2719: l_wage_accumulation_flag := 'Y';
2720: ELSE
2721: hr_utility.trace('l_effective_date < l_wa_date ' );
2722:

Line 2721: hr_utility.trace('l_effective_date < l_wa_date ' );

2717: IF l_effective_date >= l_wa_date THEN
2718: hr_utility.trace('l_effective_date >= l_wa_date ' );
2719: l_wage_accumulation_flag := 'Y';
2720: ELSE
2721: hr_utility.trace('l_effective_date < l_wa_date ' );
2722:
2723: l_wage_accumulation_flag := 'N';
2724: END IF;
2725:

Line 2737: hr_utility.trace('l_wage_accumulation_flag = ' || l_wage_accumulation_flag );

2733: IF get_wage_acc_year%ISOPEN THEN
2734: CLOSE get_wage_acc_year;
2735: END IF;
2736:
2737: hr_utility.trace('l_wage_accumulation_flag = ' || l_wage_accumulation_flag );
2738:
2739: return l_wage_accumulation_flag;
2740:
2741: END get_wage_accumulation_flag;

Line 2877: hr_utility.trace('l_imputed_redns ='||l_imputed_redns);

2873: in the US_TAX_VERTEX_WORK formual does not include Imputed earnings */
2874:
2875: IF (p_location = 'RS' ) THEN
2876: l_imputed_redns := nvl(p_reduced_subj, 0);
2877: hr_utility.trace('l_imputed_redns ='||l_imputed_redns);
2878: END IF;
2879:
2880: IF tax_balances.COUNT > 0 THEN
2881:

Line 3017: hr_utility.trace('p_location ='||p_location);

3013: p_gross := tax_balances(i).amount;
3014:
3015: ELSIF (p_location = 'RS') THEN
3016:
3017: hr_utility.trace('p_location ='||p_location);
3018: hr_utility.trace('p_tax_type ='||p_tax_type);
3019: hr_utility.trace('l_subj_reduced ='||l_subj_reduced);
3020: hr_utility.trace('p_subj='||p_subj);
3021:

Line 3018: hr_utility.trace('p_tax_type ='||p_tax_type);

3014:
3015: ELSIF (p_location = 'RS') THEN
3016:
3017: hr_utility.trace('p_location ='||p_location);
3018: hr_utility.trace('p_tax_type ='||p_tax_type);
3019: hr_utility.trace('l_subj_reduced ='||l_subj_reduced);
3020: hr_utility.trace('p_subj='||p_subj);
3021:
3022: IF l_subj_reduced > 0 THEN

Line 3019: hr_utility.trace('l_subj_reduced ='||l_subj_reduced);

3015: ELSIF (p_location = 'RS') THEN
3016:
3017: hr_utility.trace('p_location ='||p_location);
3018: hr_utility.trace('p_tax_type ='||p_tax_type);
3019: hr_utility.trace('l_subj_reduced ='||l_subj_reduced);
3020: hr_utility.trace('p_subj='||p_subj);
3021:
3022: IF l_subj_reduced > 0 THEN
3023:

Line 3020: hr_utility.trace('p_subj='||p_subj);

3016:
3017: hr_utility.trace('p_location ='||p_location);
3018: hr_utility.trace('p_tax_type ='||p_tax_type);
3019: hr_utility.trace('l_subj_reduced ='||l_subj_reduced);
3020: hr_utility.trace('p_subj='||p_subj);
3021:
3022: IF l_subj_reduced > 0 THEN
3023:
3024: if l_subj_reduced - l_imputed_redns > 0 THEN

Line 3066: hr_utility.trace('p_gross ='||p_gross);

3062: get_stored_balance(p_juri_code,
3063: p_tax_type||'_125_REDNS',
3064: p_location)) );
3065:
3066: hr_utility.trace('p_gross ='||p_gross);
3067: hr_utility.trace('l_ratio ='||l_ratio);
3068:
3069: END IF;
3070:

Line 3067: hr_utility.trace('l_ratio ='||l_ratio);

3063: p_tax_type||'_125_REDNS',
3064: p_location)) );
3065:
3066: hr_utility.trace('p_gross ='||p_gross);
3067: hr_utility.trace('l_ratio ='||l_ratio);
3068:
3069: END IF;
3070:
3071: END IF;