eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_TAX_BAL_SUMMARY_PKG dependencies on PAY_US_TAXBAL_VIEW_PKG

Line 186: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

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

Line 201: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

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

Line 216: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

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

Line 231: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

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

Line 260: pay_us_taxbal_view_pkg.us_named_balance(

256:
257: l_bal_val := 0;
258:
259: l_bal_val :=
260: pay_us_taxbal_view_pkg.us_named_balance(
261: p_balance_name => 'FUTA CREDIT',
262: p_dimension_suffix => p_emp_asg_ctx || '_GRE_YTD',
263: p_assignment_action_id => p_asact_id,
264: p_assignment_id => p_assg_id,

Line 283: pay_us_taxbal_view_pkg.us_named_balance(

279: -- WE don't fetch the PTD balance when the emp_asg_ctx is PER
280: IF p_emp_asg_ctx <> 'PER' THEN
281:
282: l_bal_val :=
283: pay_us_taxbal_view_pkg.us_named_balance(
284: p_balance_name => 'FUTA CREDIT',
285: p_dimension_suffix => p_emp_asg_ctx || '_GRE_PTD',
286: p_assignment_action_id => p_asact_id,
287: p_assignment_id => p_assg_id,

Line 310: pay_us_taxbal_view_pkg.us_named_balance(

306: -- GET Month Value:
307: l_bal_val := 0;
308:
309: l_bal_val :=
310: pay_us_taxbal_view_pkg.us_named_balance(
311: p_balance_name => 'FUTA CREDIT',
312: p_dimension_suffix => p_emp_asg_ctx || '_GRE_MONTH',
313: p_assignment_action_id => p_asact_id,
314: p_assignment_id => p_assg_id,

Line 331: pay_us_taxbal_view_pkg.us_named_balance(

327:
328: l_bal_val := 0;
329:
330: l_bal_val :=
331: pay_us_taxbal_view_pkg.us_named_balance(
332: p_balance_name => 'FUTA CREDIT',
333: p_dimension_suffix => p_emp_asg_ctx || '_GRE_QTD',
334: p_assignment_action_id => p_asact_id,
335: p_assignment_id => p_assg_id,

Line 560: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

556: if p_ee_er = 'EE' then
557: for state_dt in c_state_dt loop
558: for state_ee in c_state_ee (state_dt.effective_date, state_dt.jurisdiction_code) loop
559: p_state_taxes_tab(l_cnt).prompt := state_ee.prompt;
560: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
561: p_tax_balance_category => state_ee.balance_category_code,
562: p_tax_type => state_ee.tax_type_code,
563: p_ee_or_er => p_ee_er,
564: p_time_type => 'YTD',

Line 575: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

571: p_state_taxes_tab(l_cnt).ytd_val := l_bal_val;
572: hr_utility.set_location(l_package||l_procedure, 20);
573: hr_utility.trace('YTD value = '||l_bal_val);
574:
575: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
576: p_tax_balance_category => state_ee.balance_category_code,
577: p_tax_type => state_ee.tax_type_code,
578: p_ee_or_er => p_ee_er,
579: p_time_type => 'PTD',

Line 590: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

586: p_state_taxes_tab(l_cnt).ptd_val := l_bal_val;
587: hr_utility.set_location(l_package||l_procedure, 30);
588: hr_utility.trace('PTD value = '||l_bal_val);
589:
590: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
591: p_tax_balance_category => state_ee.balance_category_code,
592: p_tax_type => state_ee.tax_type_code,
593: p_ee_or_er => p_ee_er,
594: p_time_type => 'MONTH',

Line 605: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

601: p_state_taxes_tab(l_cnt).mtd_val := l_bal_val;
602: hr_utility.set_location(l_package||l_procedure, 40);
603: hr_utility.trace('MTD value = '||l_bal_val);
604:
605: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
606: p_tax_balance_category => state_ee.balance_category_code,
607: p_tax_type => state_ee.tax_type_code,
608: p_ee_or_er => p_ee_er,
609: p_time_type => 'QTD',

Line 626: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

622: end loop;
623: else
624: for state_er in c_state_er (p_state_code) loop
625: p_state_taxes_tab(l_cnt).prompt := state_er.prompt;
626: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
627: p_tax_balance_category => state_er.balance_category_code,
628: p_tax_type => state_er.tax_type_code,
629: p_ee_or_er => p_ee_er,
630: p_time_type => 'YTD',

Line 641: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

637: p_state_taxes_tab(l_cnt).ytd_val := l_bal_val;
638: hr_utility.set_location(l_package||l_procedure, 60);
639: hr_utility.trace('YTD value = '||l_bal_val);
640:
641: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
642: p_tax_balance_category => state_er.balance_category_code,
643: p_tax_type => state_er.tax_type_code,
644: p_ee_or_er => p_ee_er,
645: p_time_type => 'PTD',

Line 656: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

652: p_state_taxes_tab(l_cnt).ptd_val := l_bal_val;
653: hr_utility.set_location(l_package||l_procedure, 70);
654: hr_utility.trace('PTD value = '||l_bal_val);
655:
656: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
657: p_tax_balance_category => state_er.balance_category_code,
658: p_tax_type => state_er.tax_type_code,
659: p_ee_or_er => p_ee_er,
660: p_time_type => 'MONTH',

Line 671: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

667: p_state_taxes_tab(l_cnt).mtd_val := l_bal_val;
668: hr_utility.set_location(l_package||l_procedure, 80);
669: hr_utility.trace('MTD value = '||l_bal_val);
670:
671: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
672: p_tax_balance_category => state_er.balance_category_code,
673: p_tax_type => state_er.tax_type_code,
674: p_ee_or_er => p_ee_er,
675: p_time_type => 'QTD',

Line 1254: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

1250: l_procedure varchar2(30) := 'get_local_balances';
1251: BEGIN
1252: hr_utility.set_location(l_package||l_procedure, 130);
1253: p_local_taxes_tab(l_cnt).prompt := p_prompt;
1254: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
1255: p_tax_balance_category => p_balance_category_code,
1256: p_tax_type => p_tax_type_code,
1257: p_ee_or_er => p_ee_er,
1258: p_time_type => 'YTD',

Line 1269: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

1265: p_local_taxes_tab(l_cnt).ytd_val := l_bal_val;
1266: hr_utility.set_location(l_package||l_procedure, 140);
1267: hr_utility.trace('YTD value = '||l_bal_val);
1268:
1269: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
1270: p_tax_balance_category => p_balance_category_code,
1271: p_tax_type => p_tax_type_code,
1272: p_ee_or_er => p_ee_er,
1273: p_time_type => 'PTD',

Line 1284: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

1280: p_local_taxes_tab(l_cnt).ptd_val := l_bal_val;
1281: hr_utility.set_location(l_package||l_procedure, 150);
1282: hr_utility.trace('PTD value = '||l_bal_val);
1283:
1284: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
1285: p_tax_balance_category => p_balance_category_code,
1286: p_tax_type => p_tax_type_code,
1287: p_ee_or_er => p_ee_er,
1288: p_time_type => 'MONTH',

Line 1299: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(

1295: p_local_taxes_tab(l_cnt).mtd_val := l_bal_val;
1296: hr_utility.set_location(l_package||l_procedure, 160);
1297: hr_utility.trace('MTD value = '||l_bal_val);
1298:
1299: l_bal_val := pay_us_taxbal_view_pkg.us_tax_balance_vm(
1300: p_tax_balance_category => p_balance_category_code,
1301: p_tax_type => p_tax_type_code,
1302: p_ee_or_er => p_ee_er,
1303: p_time_type => 'QTD',