APPS.PAY_US_TAX_BAL_SUMMARY_PKG dependencies on PAY_US_TAXBAL_VIEW_PKG

Line 183: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

179: hr_utility.set_location(l_package||l_procedure, 10);
180: --hr_utility.trace_on(null,'tax_bal_summary');
181: for fed_taxes_rec in c_fed_cur loop
182: p_fed_taxes_tab(l_cnt).prompt := fed_taxes_rec.prompt;
183: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
184: p_tax_balance_category => fed_taxes_rec.balance_category_code,
185: p_tax_type => fed_taxes_rec.tax_type_code,
186: p_ee_or_er => p_ee_er,
187: p_time_type => 'YTD',

Line 198: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

194: p_fed_taxes_tab(l_cnt).ytd_val := l_bal_val;
195: hr_utility.set_location(l_package||l_procedure, 20);
196: hr_utility.trace('YTD value = '||l_bal_val);
197:
198: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
199: p_tax_balance_category => fed_taxes_rec.balance_category_code,
200: p_tax_type => fed_taxes_rec.tax_type_code,
201: p_ee_or_er => p_ee_er,
202: p_time_type => 'PTD',

Line 213: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

209: p_fed_taxes_tab(l_cnt).ptd_val := l_bal_val;
210: hr_utility.set_location(l_package||l_procedure, 30);
211: hr_utility.trace('PTD value = '||l_bal_val);
212:
213: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
214: p_tax_balance_category => fed_taxes_rec.balance_category_code,
215: p_tax_type => fed_taxes_rec.tax_type_code,
216: p_ee_or_er => p_ee_er,
217: p_time_type => 'MONTH',

Line 228: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

224: p_fed_taxes_tab(l_cnt).mtd_val := l_bal_val;
225: hr_utility.set_location(l_package||l_procedure, 40);
226: hr_utility.trace('MTD value = '||l_bal_val);
227:
228: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
229: p_tax_balance_category => fed_taxes_rec.balance_category_code,
230: p_tax_type => fed_taxes_rec.tax_type_code,
231: p_ee_or_er => p_ee_er,
232: p_time_type => 'QTD',

Line 457: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

453: if p_ee_er = 'EE' then
454: for state_dt in c_state_dt loop
455: for state_ee in c_state_ee (state_dt.effective_date, state_dt.jurisdiction_code) loop
456: p_state_taxes_tab(l_cnt).prompt := state_ee.prompt;
457: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
458: p_tax_balance_category => state_ee.balance_category_code,
459: p_tax_type => state_ee.tax_type_code,
460: p_ee_or_er => p_ee_er,
461: p_time_type => 'YTD',

Line 472: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

468: p_state_taxes_tab(l_cnt).ytd_val := l_bal_val;
469: hr_utility.set_location(l_package||l_procedure, 20);
470: hr_utility.trace('YTD value = '||l_bal_val);
471:
472: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
473: p_tax_balance_category => state_ee.balance_category_code,
474: p_tax_type => state_ee.tax_type_code,
475: p_ee_or_er => p_ee_er,
476: p_time_type => 'PTD',

Line 487: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

483: p_state_taxes_tab(l_cnt).ptd_val := l_bal_val;
484: hr_utility.set_location(l_package||l_procedure, 30);
485: hr_utility.trace('PTD value = '||l_bal_val);
486:
487: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
488: p_tax_balance_category => state_ee.balance_category_code,
489: p_tax_type => state_ee.tax_type_code,
490: p_ee_or_er => p_ee_er,
491: p_time_type => 'MONTH',

Line 502: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

498: p_state_taxes_tab(l_cnt).mtd_val := l_bal_val;
499: hr_utility.set_location(l_package||l_procedure, 40);
500: hr_utility.trace('MTD value = '||l_bal_val);
501:
502: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
503: p_tax_balance_category => state_ee.balance_category_code,
504: p_tax_type => state_ee.tax_type_code,
505: p_ee_or_er => p_ee_er,
506: p_time_type => 'QTD',

Line 523: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

519: end loop;
520: else
521: for state_er in c_state_er (p_state_code) loop
522: p_state_taxes_tab(l_cnt).prompt := state_er.prompt;
523: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
524: p_tax_balance_category => state_er.balance_category_code,
525: p_tax_type => state_er.tax_type_code,
526: p_ee_or_er => p_ee_er,
527: p_time_type => 'YTD',

Line 538: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

534: p_state_taxes_tab(l_cnt).ytd_val := l_bal_val;
535: hr_utility.set_location(l_package||l_procedure, 60);
536: hr_utility.trace('YTD value = '||l_bal_val);
537:
538: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
539: p_tax_balance_category => state_er.balance_category_code,
540: p_tax_type => state_er.tax_type_code,
541: p_ee_or_er => p_ee_er,
542: p_time_type => 'PTD',

Line 553: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

549: p_state_taxes_tab(l_cnt).ptd_val := l_bal_val;
550: hr_utility.set_location(l_package||l_procedure, 70);
551: hr_utility.trace('PTD value = '||l_bal_val);
552:
553: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
554: p_tax_balance_category => state_er.balance_category_code,
555: p_tax_type => state_er.tax_type_code,
556: p_ee_or_er => p_ee_er,
557: p_time_type => 'MONTH',

Line 568: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

564: p_state_taxes_tab(l_cnt).mtd_val := l_bal_val;
565: hr_utility.set_location(l_package||l_procedure, 80);
566: hr_utility.trace('MTD value = '||l_bal_val);
567:
568: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
569: p_tax_balance_category => state_er.balance_category_code,
570: p_tax_type => state_er.tax_type_code,
571: p_ee_or_er => p_ee_er,
572: p_time_type => 'QTD',

Line 1151: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

1147: l_procedure varchar2(30) := 'get_local_balances';
1148: BEGIN
1149: hr_utility.set_location(l_package||l_procedure, 130);
1150: p_local_taxes_tab(l_cnt).prompt := p_prompt;
1151: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
1152: p_tax_balance_category => p_balance_category_code,
1153: p_tax_type => p_tax_type_code,
1154: p_ee_or_er => p_ee_er,
1155: p_time_type => 'YTD',

Line 1166: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

1162: p_local_taxes_tab(l_cnt).ytd_val := l_bal_val;
1163: hr_utility.set_location(l_package||l_procedure, 140);
1164: hr_utility.trace('YTD value = '||l_bal_val);
1165:
1166: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
1167: p_tax_balance_category => p_balance_category_code,
1168: p_tax_type => p_tax_type_code,
1169: p_ee_or_er => p_ee_er,
1170: p_time_type => 'PTD',

Line 1181: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

1177: p_local_taxes_tab(l_cnt).ptd_val := l_bal_val;
1178: hr_utility.set_location(l_package||l_procedure, 150);
1179: hr_utility.trace('PTD value = '||l_bal_val);
1180:
1181: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
1182: p_tax_balance_category => p_balance_category_code,
1183: p_tax_type => p_tax_type_code,
1184: p_ee_or_er => p_ee_er,
1185: p_time_type => 'MONTH',

Line 1196: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

1192: p_local_taxes_tab(l_cnt).mtd_val := l_bal_val;
1193: hr_utility.set_location(l_package||l_procedure, 160);
1194: hr_utility.trace('MTD value = '||l_bal_val);
1195:
1196: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
1197: p_tax_balance_category => p_balance_category_code,
1198: p_tax_type => p_tax_type_code,
1199: p_ee_or_er => p_ee_er,
1200: p_time_type => 'QTD',