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_NL_WAGE_REPORT_PKG dependencies on STANDARD

Line 264: g_nom_bal_def_table(l_index).balance_name := 'Standard Taxable Income'; --1

260: --
261: g_nom_bal_def_table.delete;
262: l_index := 1;
263: --
264: g_nom_bal_def_table(l_index).balance_name := 'Standard Taxable Income'; --1
265: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_ptd;
266: g_nom_bal_def_table(l_index).context := NULL;
267: g_nom_bal_def_table(l_index).context_val := NULL;
268: l_index := l_index + 1;

Line 270: g_nom_bal_def_table(l_index).balance_name := 'Retro Standard Taxable Income Current Quarter';

266: g_nom_bal_def_table(l_index).context := NULL;
267: g_nom_bal_def_table(l_index).context_val := NULL;
268: l_index := l_index + 1;
269: --
270: g_nom_bal_def_table(l_index).balance_name := 'Retro Standard Taxable Income Current Quarter';
271: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_corr_ptd;
272: g_nom_bal_def_table(l_index).context := NULL;
273: g_nom_bal_def_table(l_index).context_val := NULL;
274: l_index := l_index + 1;

Line 276: g_nom_bal_def_table(l_index).balance_name := 'Retro Standard Taxable Income Current Quarter';

272: g_nom_bal_def_table(l_index).context := NULL;
273: g_nom_bal_def_table(l_index).context_val := NULL;
274: l_index := l_index + 1;
275: --
276: g_nom_bal_def_table(l_index).balance_name := 'Retro Standard Taxable Income Current Quarter';
277: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_adj_ptd;
278: g_nom_bal_def_table(l_index).context := NULL;
279: g_nom_bal_def_table(l_index).context_val := NULL;
280: l_index := l_index + 1;

Line 282: g_nom_bal_def_table(l_index).balance_name := 'SI Income Standard Tax';

278: g_nom_bal_def_table(l_index).context := NULL;
279: g_nom_bal_def_table(l_index).context_val := NULL;
280: l_index := l_index + 1;
281: --
282: g_nom_bal_def_table(l_index).balance_name := 'SI Income Standard Tax';
283: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_ptd;
284: g_nom_bal_def_table(l_index).context := NULL;
285: g_nom_bal_def_table(l_index).context_val := NULL;
286: l_index := l_index + 1;

Line 288: g_nom_bal_def_table(l_index).balance_name := 'Retro SI Income Standard Tax'; --5

284: g_nom_bal_def_table(l_index).context := NULL;
285: g_nom_bal_def_table(l_index).context_val := NULL;
286: l_index := l_index + 1;
287: --
288: g_nom_bal_def_table(l_index).balance_name := 'Retro SI Income Standard Tax'; --5
289: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_corr_ptd;
290: g_nom_bal_def_table(l_index).context := NULL;
291: g_nom_bal_def_table(l_index).context_val := NULL;
292: l_index := l_index + 1;

Line 294: g_nom_bal_def_table(l_index).balance_name := 'Retro SI Income Standard Tax';

290: g_nom_bal_def_table(l_index).context := NULL;
291: g_nom_bal_def_table(l_index).context_val := NULL;
292: l_index := l_index + 1;
293: --
294: g_nom_bal_def_table(l_index).balance_name := 'Retro SI Income Standard Tax';
295: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_adj_ptd;
296: g_nom_bal_def_table(l_index).context := NULL;
297: g_nom_bal_def_table(l_index).context_val := NULL;
298: l_index := l_index + 1;

Line 378: g_nom_bal_def_table(l_index).balance_name := 'Wage In Money Standard Tax SI'; --20

374: g_nom_bal_def_table(l_index).context := NULL;
375: g_nom_bal_def_table(l_index).context_val := NULL;
376: l_index := l_index + 1;
377: --
378: g_nom_bal_def_table(l_index).balance_name := 'Wage In Money Standard Tax SI'; --20
379: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_ptd;
380: g_nom_bal_def_table(l_index).context := NULL;
381: g_nom_bal_def_table(l_index).context_val := NULL;
382: l_index := l_index + 1;

Line 384: g_nom_bal_def_table(l_index).balance_name := 'Retro Wage In Money Standard Tax SI';

380: g_nom_bal_def_table(l_index).context := NULL;
381: g_nom_bal_def_table(l_index).context_val := NULL;
382: l_index := l_index + 1;
383: --
384: g_nom_bal_def_table(l_index).balance_name := 'Retro Wage In Money Standard Tax SI';
385: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_corr_ptd;
386: g_nom_bal_def_table(l_index).context := NULL;
387: g_nom_bal_def_table(l_index).context_val := NULL;
388: l_index := l_index + 1;

Line 390: g_nom_bal_def_table(l_index).balance_name := 'Retro Wage In Money Standard Tax SI';

386: g_nom_bal_def_table(l_index).context := NULL;
387: g_nom_bal_def_table(l_index).context_val := NULL;
388: l_index := l_index + 1;
389: --
390: g_nom_bal_def_table(l_index).balance_name := 'Retro Wage In Money Standard Tax SI';
391: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_adj_ptd;
392: g_nom_bal_def_table(l_index).context := NULL;
393: g_nom_bal_def_table(l_index).context_val := NULL;
394: l_index := l_index + 1;

Line 414: g_nom_bal_def_table(l_index).balance_name := 'Wage In Kind Standard Tax SI';

410: g_nom_bal_def_table(l_index).context := NULL;
411: g_nom_bal_def_table(l_index).context_val := NULL;
412: l_index := l_index + 1;
413: --
414: g_nom_bal_def_table(l_index).balance_name := 'Wage In Kind Standard Tax SI';
415: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_ptd;
416: g_nom_bal_def_table(l_index).context := NULL;
417: g_nom_bal_def_table(l_index).context_val := NULL;
418: l_index := l_index + 1;

Line 420: g_nom_bal_def_table(l_index).balance_name := 'Retro Wage In Kind Standard Tax SI';

416: g_nom_bal_def_table(l_index).context := NULL;
417: g_nom_bal_def_table(l_index).context_val := NULL;
418: l_index := l_index + 1;
419: --
420: g_nom_bal_def_table(l_index).balance_name := 'Retro Wage In Kind Standard Tax SI';
421: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_corr_ptd;
422: g_nom_bal_def_table(l_index).context := NULL;
423: g_nom_bal_def_table(l_index).context_val := NULL;
424: l_index := l_index + 1;

Line 426: g_nom_bal_def_table(l_index).balance_name := 'Retro Wage In Kind Standard Tax SI';

422: g_nom_bal_def_table(l_index).context := NULL;
423: g_nom_bal_def_table(l_index).context_val := NULL;
424: l_index := l_index + 1;
425: --
426: g_nom_bal_def_table(l_index).balance_name := 'Retro Wage In Kind Standard Tax SI';
427: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_adj_ptd;
428: g_nom_bal_def_table(l_index).context := NULL;
429: g_nom_bal_def_table(l_index).context_val := NULL;
430: l_index := l_index + 1;

Line 450: g_nom_bal_def_table(l_index).balance_name := 'Tips and Fund Payments Standard Tax SI';

446: g_nom_bal_def_table(l_index).context := NULL;
447: g_nom_bal_def_table(l_index).context_val := NULL;
448: l_index := l_index + 1;
449: --
450: g_nom_bal_def_table(l_index).balance_name := 'Tips and Fund Payments Standard Tax SI';
451: g_nom_bal_def_table(l_index).database_item_suffix := NULL;
452: g_nom_bal_def_table(l_index).context := NULL;
453: g_nom_bal_def_table(l_index).context_val := NULL;
454: l_index := l_index + 1;

Line 456: g_nom_bal_def_table(l_index).balance_name := 'Retro Tips and Fund Payments Standard Tax SI';

452: g_nom_bal_def_table(l_index).context := NULL;
453: g_nom_bal_def_table(l_index).context_val := NULL;
454: l_index := l_index + 1;
455: --
456: g_nom_bal_def_table(l_index).balance_name := 'Retro Tips and Fund Payments Standard Tax SI';
457: g_nom_bal_def_table(l_index).database_item_suffix := NULL;
458: g_nom_bal_def_table(l_index).context := NULL;
459: g_nom_bal_def_table(l_index).context_val := NULL;
460: l_index := l_index + 1;

Line 462: g_nom_bal_def_table(l_index).balance_name := 'Retro Tips and Fund Payments Standard Tax SI';

458: g_nom_bal_def_table(l_index).context := NULL;
459: g_nom_bal_def_table(l_index).context_val := NULL;
460: l_index := l_index + 1;
461: --
462: g_nom_bal_def_table(l_index).balance_name := 'Retro Tips and Fund Payments Standard Tax SI';
463: g_nom_bal_def_table(l_index).database_item_suffix := NULL;
464: g_nom_bal_def_table(l_index).context := NULL;
465: g_nom_bal_def_table(l_index).context_val := NULL;
466: l_index := l_index + 1;

Line 492: g_nom_bal_def_table(l_index).balance_name := 'Standard Tax Deduction';

488: g_nom_bal_def_table(l_index).context := NULL;
489: g_nom_bal_def_table(l_index).context_val := NULL;
490: l_index := l_index + 1;
491: --
492: g_nom_bal_def_table(l_index).balance_name := 'Standard Tax Deduction';
493: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_ptd;
494: g_nom_bal_def_table(l_index).context := NULL;
495: g_nom_bal_def_table(l_index).context_val := NULL;
496: l_index := l_index + 1;

Line 498: g_nom_bal_def_table(l_index).balance_name := 'Retro Standard Tax Deduction Current Quarter'; --40

494: g_nom_bal_def_table(l_index).context := NULL;
495: g_nom_bal_def_table(l_index).context_val := NULL;
496: l_index := l_index + 1;
497: --
498: g_nom_bal_def_table(l_index).balance_name := 'Retro Standard Tax Deduction Current Quarter'; --40
499: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_corr_ptd;
500: g_nom_bal_def_table(l_index).context := NULL;
501: g_nom_bal_def_table(l_index).context_val := NULL;
502: l_index := l_index + 1;

Line 504: g_nom_bal_def_table(l_index).balance_name := 'Retro Standard Tax Deduction Current Quarter';

500: g_nom_bal_def_table(l_index).context := NULL;
501: g_nom_bal_def_table(l_index).context_val := NULL;
502: l_index := l_index + 1;
503: --
504: g_nom_bal_def_table(l_index).balance_name := 'Retro Standard Tax Deduction Current Quarter';
505: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_adj_ptd;
506: g_nom_bal_def_table(l_index).context := NULL;
507: g_nom_bal_def_table(l_index).context_val := NULL;
508: l_index := l_index + 1;

Line 774: g_nom_bal_def_table(l_index).balance_name := 'Employer ZVW Contribution Standard Tax';

770: g_nom_bal_def_table(l_index).context := 'SOURCE_TEXT';
771: g_nom_bal_def_table(l_index).context_val := 'ZVW';
772: l_index := l_index + 1;
773: --
774: g_nom_bal_def_table(l_index).balance_name := 'Employer ZVW Contribution Standard Tax';
775: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_ptd;
776: g_nom_bal_def_table(l_index).context := 'SOURCE_TEXT';
777: g_nom_bal_def_table(l_index).context_val := 'ZVW';
778: l_index := l_index + 1;

Line 780: g_nom_bal_def_table(l_index).balance_name := 'Retro Employer ZVW Contribution Standard Tax'; -- 87

776: g_nom_bal_def_table(l_index).context := 'SOURCE_TEXT';
777: g_nom_bal_def_table(l_index).context_val := 'ZVW';
778: l_index := l_index + 1;
779: --
780: g_nom_bal_def_table(l_index).balance_name := 'Retro Employer ZVW Contribution Standard Tax'; -- 87
781: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_corr_ptd;
782: g_nom_bal_def_table(l_index).context := 'SOURCE_TEXT';
783: g_nom_bal_def_table(l_index).context_val := 'ZVW';
784: l_index := l_index + 1;

Line 786: g_nom_bal_def_table(l_index).balance_name := 'Retro Employer ZVW Contribution Standard Tax';

782: g_nom_bal_def_table(l_index).context := 'SOURCE_TEXT';
783: g_nom_bal_def_table(l_index).context_val := 'ZVW';
784: l_index := l_index + 1;
785: --
786: g_nom_bal_def_table(l_index).balance_name := 'Retro Employer ZVW Contribution Standard Tax';
787: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_adj_ptd;
788: g_nom_bal_def_table(l_index).context := 'SOURCE_TEXT';
789: g_nom_bal_def_table(l_index).context_val := 'ZVW';
790: l_index := l_index + 1;

Line 810: g_nom_bal_def_table(l_index).balance_name := 'Retro Standard Taxable Income'; -- 92

806: g_nom_bal_def_table(l_index).context := 'SOURCE_TEXT';
807: g_nom_bal_def_table(l_index).context_val := 'ZVW';
808: l_index := l_index + 1;
809: --
810: g_nom_bal_def_table(l_index).balance_name := 'Retro Standard Taxable Income'; -- 92
811: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_corr_ptd;
812: g_nom_bal_def_table(l_index).context := NULL;
813: g_nom_bal_def_table(l_index).context_val := NULL;
814: l_index := l_index + 1;

Line 816: g_nom_bal_def_table(l_index).balance_name := 'Retro Standard Taxable Income';

812: g_nom_bal_def_table(l_index).context := NULL;
813: g_nom_bal_def_table(l_index).context_val := NULL;
814: l_index := l_index + 1;
815: --
816: g_nom_bal_def_table(l_index).balance_name := 'Retro Standard Taxable Income';
817: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_adj_ptd;
818: g_nom_bal_def_table(l_index).context := NULL;
819: g_nom_bal_def_table(l_index).context_val := NULL;
820: l_index := l_index + 1;

Line 822: g_nom_bal_def_table(l_index).balance_name := 'Retro Standard Tax Deduction'; -- 94

818: g_nom_bal_def_table(l_index).context := NULL;
819: g_nom_bal_def_table(l_index).context_val := NULL;
820: l_index := l_index + 1;
821: --
822: g_nom_bal_def_table(l_index).balance_name := 'Retro Standard Tax Deduction'; -- 94
823: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_corr_ptd;
824: g_nom_bal_def_table(l_index).context := NULL;
825: g_nom_bal_def_table(l_index).context_val := NULL;
826: l_index := l_index + 1;

Line 828: g_nom_bal_def_table(l_index).balance_name := 'Retro Standard Tax Deduction'; -- 95

824: g_nom_bal_def_table(l_index).context := NULL;
825: g_nom_bal_def_table(l_index).context_val := NULL;
826: l_index := l_index + 1;
827: --
828: g_nom_bal_def_table(l_index).balance_name := 'Retro Standard Tax Deduction'; -- 95
829: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_adj_ptd;
830: g_nom_bal_def_table(l_index).context := NULL;
831: g_nom_bal_def_table(l_index).context_val := NULL;
832: l_index := l_index + 1;

Line 834: g_nom_bal_def_table(l_index).balance_name := 'Wage In Money Standard Tax Only'; --96

830: g_nom_bal_def_table(l_index).context := NULL;
831: g_nom_bal_def_table(l_index).context_val := NULL;
832: l_index := l_index + 1;
833: -- Wage In Money
834: g_nom_bal_def_table(l_index).balance_name := 'Wage In Money Standard Tax Only'; --96
835: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_ptd;
836: g_nom_bal_def_table(l_index).context := NULL;
837: g_nom_bal_def_table(l_index).context_val := NULL;
838: l_index := l_index + 1;

Line 839: g_nom_bal_def_table(l_index).balance_name := 'Retro Wage In Money Standard Tax Only'; -- 97

835: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_ptd;
836: g_nom_bal_def_table(l_index).context := NULL;
837: g_nom_bal_def_table(l_index).context_val := NULL;
838: l_index := l_index + 1;
839: g_nom_bal_def_table(l_index).balance_name := 'Retro Wage In Money Standard Tax Only'; -- 97
840: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_corr_ptd;
841: g_nom_bal_def_table(l_index).context := NULL;
842: g_nom_bal_def_table(l_index).context_val := NULL;
843: l_index := l_index + 1;

Line 844: g_nom_bal_def_table(l_index).balance_name := 'Retro Wage In Money Standard Tax Only';

840: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_corr_ptd;
841: g_nom_bal_def_table(l_index).context := NULL;
842: g_nom_bal_def_table(l_index).context_val := NULL;
843: l_index := l_index + 1;
844: g_nom_bal_def_table(l_index).balance_name := 'Retro Wage In Money Standard Tax Only';
845: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_adj_ptd;
846: g_nom_bal_def_table(l_index).context := NULL;
847: g_nom_bal_def_table(l_index).context_val := NULL;
848: l_index := l_index + 1;

Line 866: g_nom_bal_def_table(l_index).balance_name := 'Wage In Kind Standard Tax Only'; -- 102

862: g_nom_bal_def_table(l_index).context := NULL;
863: g_nom_bal_def_table(l_index).context_val := NULL;
864: l_index := l_index + 1;
865: -- Wage In Kind
866: g_nom_bal_def_table(l_index).balance_name := 'Wage In Kind Standard Tax Only'; -- 102
867: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_ptd;
868: g_nom_bal_def_table(l_index).context := NULL;
869: g_nom_bal_def_table(l_index).context_val := NULL;
870: l_index := l_index + 1;

Line 871: g_nom_bal_def_table(l_index).balance_name := 'Retro Wage In Kind Standard Tax Only';

867: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_ptd;
868: g_nom_bal_def_table(l_index).context := NULL;
869: g_nom_bal_def_table(l_index).context_val := NULL;
870: l_index := l_index + 1;
871: g_nom_bal_def_table(l_index).balance_name := 'Retro Wage In Kind Standard Tax Only';
872: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_corr_ptd;
873: g_nom_bal_def_table(l_index).context := NULL;
874: g_nom_bal_def_table(l_index).context_val := NULL;
875: l_index := l_index + 1;

Line 876: g_nom_bal_def_table(l_index).balance_name := 'Retro Wage In Kind Standard Tax Only';

872: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_corr_ptd;
873: g_nom_bal_def_table(l_index).context := NULL;
874: g_nom_bal_def_table(l_index).context_val := NULL;
875: l_index := l_index + 1;
876: g_nom_bal_def_table(l_index).balance_name := 'Retro Wage In Kind Standard Tax Only';
877: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_adj_ptd;
878: g_nom_bal_def_table(l_index).context := NULL;
879: g_nom_bal_def_table(l_index).context_val := NULL;
880: l_index := l_index + 1;

Line 929: g_nom_bal_def_table(l_index).balance_name := 'Standard Tax Correction'; -- 114

925: g_nom_bal_def_table(l_index).context := NULL;
926: g_nom_bal_def_table(l_index).context_val := NULL;
927: l_index := l_index + 1;
928: --
929: g_nom_bal_def_table(l_index).balance_name := 'Standard Tax Correction'; -- 114
930: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_ptd;
931: g_nom_bal_def_table(l_index).context := NULL;
932: g_nom_bal_def_table(l_index).context_val := NULL;
933: l_index := l_index + 1;

Line 1451: g_col_bal_def_table(x).balance_name := 'Standard Taxable Income'; --1

1447: --
1448: --Fnd_file.put_line(FND_FILE.LOG,' Populating Balanace Table for Collective Report');
1449: g_col_bal_def_table.delete;
1450: x:=1;
1451: g_col_bal_def_table(x).balance_name := 'Standard Taxable Income'; --1
1452: g_col_bal_def_table(x).database_item_suffix := l_tu_payroll_ptd;
1453: g_col_bal_def_table(x).database_item_suffix2 := NULL;
1454: g_col_bal_def_table(x).context := NULL;
1455: g_col_bal_def_table(x).context_val := NULL;

Line 1457: g_col_bal_def_table(x).balance_name := 'Retro Standard Taxable Income Current Quarter';

1453: g_col_bal_def_table(x).database_item_suffix2 := NULL;
1454: g_col_bal_def_table(x).context := NULL;
1455: g_col_bal_def_table(x).context_val := NULL;
1456: x := x+1;
1457: g_col_bal_def_table(x).balance_name := 'Retro Standard Taxable Income Current Quarter';
1458: g_col_bal_def_table(x).database_item_suffix := l_tu_payroll_adj_ptd;
1459: g_col_bal_def_table(x).database_item_suffix2 := l_tu_payroll_corr_ptd;
1460: g_col_bal_def_table(x).context := NULL;
1461: g_col_bal_def_table(x).context_val := NULL;

Line 1475: g_col_bal_def_table(x).balance_name := 'Retro Standard Taxable Income'; --5

1471: g_col_bal_def_table(x).database_item_suffix2 := l_tu_payroll_corr_ptd;
1472: g_col_bal_def_table(x).context := NULL;
1473: g_col_bal_def_table(x).context_val := NULL;
1474: x := x+1;
1475: g_col_bal_def_table(x).balance_name := 'Retro Standard Taxable Income'; --5
1476: g_col_bal_def_table(x).database_item_suffix := l_tu_payroll_adj_ptd;
1477: g_col_bal_def_table(x).database_item_suffix2 := l_tu_payroll_corr_ptd;
1478: g_col_bal_def_table(x).context := NULL;
1479: g_col_bal_def_table(x).context_val := NULL;

Line 1481: g_col_bal_def_table(x).balance_name := 'SI Income Standard Tax'; --6

1477: g_col_bal_def_table(x).database_item_suffix2 := l_tu_payroll_corr_ptd;
1478: g_col_bal_def_table(x).context := NULL;
1479: g_col_bal_def_table(x).context_val := NULL;
1480: x := x+1;
1481: g_col_bal_def_table(x).balance_name := 'SI Income Standard Tax'; --6
1482: g_col_bal_def_table(x).database_item_suffix := l_tu_payroll_ptd;
1483: g_col_bal_def_table(x).database_item_suffix2 := NULL;
1484: g_col_bal_def_table(x).context := NULL;
1485: g_col_bal_def_table(x).context_val := NULL;

Line 1487: g_col_bal_def_table(x).balance_name := 'Retro SI Income Standard Tax';

1483: g_col_bal_def_table(x).database_item_suffix2 := NULL;
1484: g_col_bal_def_table(x).context := NULL;
1485: g_col_bal_def_table(x).context_val := NULL;
1486: x := x+1;
1487: g_col_bal_def_table(x).balance_name := 'Retro SI Income Standard Tax';
1488: g_col_bal_def_table(x).database_item_suffix := l_tu_payroll_adj_ptd;
1489: g_col_bal_def_table(x).database_item_suffix2 := l_tu_payroll_corr_ptd;
1490: g_col_bal_def_table(x).context := NULL;
1491: g_col_bal_def_table(x).context_val := NULL;

Line 1565: g_col_bal_def_table(x).balance_name := 'Employer ZVW Contribution Standard Tax';

1561: g_col_bal_def_table(x).database_item_suffix2 := l_tu_sit_payroll_corr_ptd;
1562: g_col_bal_def_table(x).context := 'SOURCE_TEXT';
1563: g_col_bal_def_table(x).context_val := 'UFO' ;
1564: x := x+1;
1565: g_col_bal_def_table(x).balance_name := 'Employer ZVW Contribution Standard Tax';
1566: g_col_bal_def_table(x).database_item_suffix := l_tu_payroll_ptd;
1567: g_col_bal_def_table(x).database_item_suffix2 := NULL;
1568: g_col_bal_def_table(x).context := 'SOURCE_TEXT';
1569: g_col_bal_def_table(x).context_val := 'ZVW' ; --20

Line 1589: g_col_bal_def_table(x).balance_name := 'Retro Employer ZVW Contribution Standard Tax';

1585: g_col_bal_def_table(x).database_item_suffix2 := NULL;
1586: g_col_bal_def_table(x).context := 'SOURCE_TEXT';
1587: g_col_bal_def_table(x).context_val := 'ZVW' ;
1588: x := x+1;
1589: g_col_bal_def_table(x).balance_name := 'Retro Employer ZVW Contribution Standard Tax';
1590: g_col_bal_def_table(x).database_item_suffix := l_tu_payroll_adj_ptd;
1591: g_col_bal_def_table(x).database_item_suffix2 := l_tu_payroll_corr_ptd;
1592: g_col_bal_def_table(x).context := 'SOURCE_TEXT';
1593: g_col_bal_def_table(x).context_val := 'ZVW' ;

Line 1613: g_col_bal_def_table(x).balance_name := 'Standard Tax Deduction'; --28

1609: g_col_bal_def_table(x).database_item_suffix2 := l_tu_sit_payroll_corr_ptd;
1610: g_col_bal_def_table(x).context := 'SOURCE_TEXT';
1611: g_col_bal_def_table(x).context_val := 'ZVW' ; --27
1612: x := x+1;
1613: g_col_bal_def_table(x).balance_name := 'Standard Tax Deduction'; --28
1614: g_col_bal_def_table(x).database_item_suffix := l_tu_payroll_ptd;
1615: g_col_bal_def_table(x).database_item_suffix2 := NULL;
1616: g_col_bal_def_table(x).context := NULL;
1617: g_col_bal_def_table(x).context_val := NULL;

Line 1619: g_col_bal_def_table(x).balance_name := 'Retro Standard Tax Deduction Current Quarter';

1615: g_col_bal_def_table(x).database_item_suffix2 := NULL;
1616: g_col_bal_def_table(x).context := NULL;
1617: g_col_bal_def_table(x).context_val := NULL;
1618: x := x+1;
1619: g_col_bal_def_table(x).balance_name := 'Retro Standard Tax Deduction Current Quarter';
1620: g_col_bal_def_table(x).database_item_suffix := l_tu_payroll_adj_ptd;
1621: g_col_bal_def_table(x).database_item_suffix2 := l_tu_payroll_corr_ptd;
1622: g_col_bal_def_table(x).context := NULL;
1623: g_col_bal_def_table(x).context_val := NULL ;

Line 1637: g_col_bal_def_table(x).balance_name := 'Retro Standard Tax Deduction'; --32

1633: g_col_bal_def_table(x).database_item_suffix2 := l_tu_payroll_corr_ptd;
1634: g_col_bal_def_table(x).context := NULL;
1635: g_col_bal_def_table(x).context_val := NULL ;
1636: x := x+1;
1637: g_col_bal_def_table(x).balance_name := 'Retro Standard Tax Deduction'; --32
1638: g_col_bal_def_table(x).database_item_suffix := l_tu_payroll_adj_ptd;
1639: g_col_bal_def_table(x).database_item_suffix2 := l_tu_payroll_corr_ptd;
1640: g_col_bal_def_table(x).context := NULL;
1641: g_col_bal_def_table(x).context_val := NULL ;

Line 1929: g_col_bal_def_table(x).balance_name := 'Standard Tax Correction'; --78

1925: g_col_bal_def_table(x).database_item_suffix2 := l_tu_payroll_corr_ptd;
1926: g_col_bal_def_table(x).context := NULL;
1927: g_col_bal_def_table(x).context_val := NULL;
1928: x := x+1;
1929: g_col_bal_def_table(x).balance_name := 'Standard Tax Correction'; --78
1930: g_col_bal_def_table(x).database_item_suffix := l_tu_payroll_ptd;
1931: g_col_bal_def_table(x).database_item_suffix2 := NULL;
1932: g_col_bal_def_table(x).context := NULL;
1933: g_col_bal_def_table(x).context_val := NULL;

Line 7449: AND rc.short_name = 'Standard'

7445: AND esu.retro_component_usage_id = rcu.retro_component_usage_id
7446: AND rcu.creator_type = 'ET' -- check
7447: AND rcu.retro_component_id = rc.retro_component_id
7448: AND rc.legislation_code = 'NL'
7449: AND rc.short_name = 'Standard'
7450: AND ppa.effective_date between pee1.effective_start_date and pee1.effective_end_date
7451: AND paa1.payroll_action_id = ppa1.payroll_action_id
7452: AND ptp.payroll_id = ppa1.payroll_id
7453: AND rr1.start_date BETWEEN ptp.start_date and ptp.end_date

Line 9755: AND rc.short_name = 'Standard'

9751: AND rr2.element_entry_id = pee2.element_entry_id
9752: AND pee2.element_entry_id = pre.element_entry_id
9753: AND pre.retro_component_id = rc.retro_component_id
9754: AND rc.legislation_code = 'NL'
9755: AND rc.short_name = 'Standard'
9756: AND c_effective_date between pee1.effective_start_date and pee1.effective_end_date
9757: AND c_effective_date between pee2.effective_start_date and pee2.effective_end_date;*/
9758: --
9759: CURSOR csr_get_corr_retro_periods(c_assignment_action_id NUMBER

Line 9780: AND rc.short_name = 'Standard'

9776: AND esu.retro_component_usage_id = rcu.retro_component_usage_id
9777: AND rcu.creator_type = 'ET' -- check
9778: AND rcu.retro_component_id = rc.retro_component_id
9779: AND rc.legislation_code = 'NL'
9780: AND rc.short_name = 'Standard'
9781: AND c_effective_date between pee1.effective_start_date and pee1.effective_end_date
9782: AND paa.payroll_action_id = ppa.payroll_action_id
9783: AND ptp.payroll_id = ppa.payroll_id
9784: AND rr1.start_date BETWEEN ptp.start_date and ptp.end_date

Line 9798: AND rc.short_name = 'Standard';*/

9794: AND rr.element_type_id = esu.retro_element_type_id
9795: AND esu.retro_component_usage_id = rcu.retro_component_usage_id
9796: AND rcu.retro_component_id = rc.retro_component_id
9797: AND rc.legislation_code = 'NL'
9798: AND rc.short_name = 'Standard';*/
9799: --
9800: CURSOR csr_get_assignment_action_id(c_assignment_id NUMBER
9801: ,c_date DATE) IS
9802: SELECT max(paa.assignment_action_id) assignment_action_id

Line 14728: AND rc.short_name = 'Standard'

14724: AND esu.retro_component_usage_id = rcu.retro_component_usage_id
14725: AND rcu.creator_type = 'ET' -- check
14726: AND rcu.retro_component_id = rc.retro_component_id
14727: AND rc.legislation_code = 'NL'
14728: AND rc.short_name = 'Standard'
14729: AND ppa.effective_date between pee1.effective_start_date and pee1.effective_end_date
14730: AND paa1.payroll_action_id = ppa1.payroll_action_id
14731: AND ptp.payroll_id = ppa1.payroll_id
14732: AND rr1.start_date BETWEEN ptp.start_date and ptp.end_date

Line 14762: AND rc.short_name = 'Standard'

14758: AND esu.retro_component_usage_id = rcu.retro_component_usage_id
14759: AND rcu.creator_type = 'ET'
14760: AND rcu.retro_component_id = rc.retro_component_id
14761: AND rc.legislation_code = 'NL'
14762: AND rc.short_name = 'Standard'
14763: AND c_effective_date between pee1.effective_start_date and pee1.effective_end_date
14764: AND paa.payroll_action_id = ppa.payroll_action_id
14765: AND ptp.payroll_id = ppa.payroll_id
14766: AND rr1.start_date BETWEEN ptp.start_date and ptp.end_date