APPS.PAY_NL_WAGE_REPORT_PKG dependencies on STANDARD

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

173: --
174: g_nom_bal_def_table.delete;
175: l_index := 1;
176: --
177: g_nom_bal_def_table(l_index).balance_name := 'Standard Taxable Income'; --1
178: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_ptd;
179: g_nom_bal_def_table(l_index).context := NULL;
180: g_nom_bal_def_table(l_index).context_val := NULL;
181: l_index := l_index + 1;

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

179: g_nom_bal_def_table(l_index).context := NULL;
180: g_nom_bal_def_table(l_index).context_val := NULL;
181: l_index := l_index + 1;
182: --
183: g_nom_bal_def_table(l_index).balance_name := 'Retro Standard Taxable Income Current Quarter';
184: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_corr_ptd;
185: g_nom_bal_def_table(l_index).context := NULL;
186: g_nom_bal_def_table(l_index).context_val := NULL;
187: l_index := l_index + 1;

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

185: g_nom_bal_def_table(l_index).context := NULL;
186: g_nom_bal_def_table(l_index).context_val := NULL;
187: l_index := l_index + 1;
188: --
189: g_nom_bal_def_table(l_index).balance_name := 'Retro Standard Taxable Income Current Quarter';
190: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_adj_ptd;
191: g_nom_bal_def_table(l_index).context := NULL;
192: g_nom_bal_def_table(l_index).context_val := NULL;
193: l_index := l_index + 1;

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

191: g_nom_bal_def_table(l_index).context := NULL;
192: g_nom_bal_def_table(l_index).context_val := NULL;
193: l_index := l_index + 1;
194: --
195: g_nom_bal_def_table(l_index).balance_name := 'SI Income Standard Tax';
196: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_ptd;
197: g_nom_bal_def_table(l_index).context := NULL;
198: g_nom_bal_def_table(l_index).context_val := NULL;
199: l_index := l_index + 1;

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

197: g_nom_bal_def_table(l_index).context := NULL;
198: g_nom_bal_def_table(l_index).context_val := NULL;
199: l_index := l_index + 1;
200: --
201: g_nom_bal_def_table(l_index).balance_name := 'Retro SI Income Standard Tax'; --5
202: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_corr_ptd;
203: g_nom_bal_def_table(l_index).context := NULL;
204: g_nom_bal_def_table(l_index).context_val := NULL;
205: l_index := l_index + 1;

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

203: g_nom_bal_def_table(l_index).context := NULL;
204: g_nom_bal_def_table(l_index).context_val := NULL;
205: l_index := l_index + 1;
206: --
207: g_nom_bal_def_table(l_index).balance_name := 'Retro SI Income Standard Tax';
208: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_adj_ptd;
209: g_nom_bal_def_table(l_index).context := NULL;
210: g_nom_bal_def_table(l_index).context_val := NULL;
211: l_index := l_index + 1;

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

287: g_nom_bal_def_table(l_index).context := NULL;
288: g_nom_bal_def_table(l_index).context_val := NULL;
289: l_index := l_index + 1;
290: --
291: g_nom_bal_def_table(l_index).balance_name := 'Wage In Money Standard Tax SI'; --20
292: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_ptd;
293: g_nom_bal_def_table(l_index).context := NULL;
294: g_nom_bal_def_table(l_index).context_val := NULL;
295: l_index := l_index + 1;

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

293: g_nom_bal_def_table(l_index).context := NULL;
294: g_nom_bal_def_table(l_index).context_val := NULL;
295: l_index := l_index + 1;
296: --
297: g_nom_bal_def_table(l_index).balance_name := 'Retro Wage In Money Standard Tax SI';
298: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_corr_ptd;
299: g_nom_bal_def_table(l_index).context := NULL;
300: g_nom_bal_def_table(l_index).context_val := NULL;
301: l_index := l_index + 1;

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

299: g_nom_bal_def_table(l_index).context := NULL;
300: g_nom_bal_def_table(l_index).context_val := NULL;
301: l_index := l_index + 1;
302: --
303: g_nom_bal_def_table(l_index).balance_name := 'Retro Wage In Money Standard Tax SI';
304: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_adj_ptd;
305: g_nom_bal_def_table(l_index).context := NULL;
306: g_nom_bal_def_table(l_index).context_val := NULL;
307: l_index := l_index + 1;

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

323: g_nom_bal_def_table(l_index).context := NULL;
324: g_nom_bal_def_table(l_index).context_val := NULL;
325: l_index := l_index + 1;
326: --
327: g_nom_bal_def_table(l_index).balance_name := 'Wage In Kind Standard Tax SI';
328: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_ptd;
329: g_nom_bal_def_table(l_index).context := NULL;
330: g_nom_bal_def_table(l_index).context_val := NULL;
331: l_index := l_index + 1;

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

329: g_nom_bal_def_table(l_index).context := NULL;
330: g_nom_bal_def_table(l_index).context_val := NULL;
331: l_index := l_index + 1;
332: --
333: g_nom_bal_def_table(l_index).balance_name := 'Retro Wage In Kind Standard Tax SI';
334: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_corr_ptd;
335: g_nom_bal_def_table(l_index).context := NULL;
336: g_nom_bal_def_table(l_index).context_val := NULL;
337: l_index := l_index + 1;

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

335: g_nom_bal_def_table(l_index).context := NULL;
336: g_nom_bal_def_table(l_index).context_val := NULL;
337: l_index := l_index + 1;
338: --
339: g_nom_bal_def_table(l_index).balance_name := 'Retro Wage In Kind Standard Tax SI';
340: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_adj_ptd;
341: g_nom_bal_def_table(l_index).context := NULL;
342: g_nom_bal_def_table(l_index).context_val := NULL;
343: l_index := l_index + 1;

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

359: g_nom_bal_def_table(l_index).context := NULL;
360: g_nom_bal_def_table(l_index).context_val := NULL;
361: l_index := l_index + 1;
362: --
363: g_nom_bal_def_table(l_index).balance_name := 'Tips and Fund Payments Standard Tax SI';
364: g_nom_bal_def_table(l_index).database_item_suffix := NULL;
365: g_nom_bal_def_table(l_index).context := NULL;
366: g_nom_bal_def_table(l_index).context_val := NULL;
367: l_index := l_index + 1;

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

365: g_nom_bal_def_table(l_index).context := NULL;
366: g_nom_bal_def_table(l_index).context_val := NULL;
367: l_index := l_index + 1;
368: --
369: g_nom_bal_def_table(l_index).balance_name := 'Retro Tips and Fund Payments Standard Tax SI';
370: g_nom_bal_def_table(l_index).database_item_suffix := NULL;
371: g_nom_bal_def_table(l_index).context := NULL;
372: g_nom_bal_def_table(l_index).context_val := NULL;
373: l_index := l_index + 1;

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

371: g_nom_bal_def_table(l_index).context := NULL;
372: g_nom_bal_def_table(l_index).context_val := NULL;
373: l_index := l_index + 1;
374: --
375: g_nom_bal_def_table(l_index).balance_name := 'Retro Tips and Fund Payments Standard Tax SI';
376: g_nom_bal_def_table(l_index).database_item_suffix := NULL;
377: g_nom_bal_def_table(l_index).context := NULL;
378: g_nom_bal_def_table(l_index).context_val := NULL;
379: l_index := l_index + 1;

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

401: g_nom_bal_def_table(l_index).context := NULL;
402: g_nom_bal_def_table(l_index).context_val := NULL;
403: l_index := l_index + 1;
404: --
405: g_nom_bal_def_table(l_index).balance_name := 'Standard Tax Deduction';
406: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_ptd;
407: g_nom_bal_def_table(l_index).context := NULL;
408: g_nom_bal_def_table(l_index).context_val := NULL;
409: l_index := l_index + 1;

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

407: g_nom_bal_def_table(l_index).context := NULL;
408: g_nom_bal_def_table(l_index).context_val := NULL;
409: l_index := l_index + 1;
410: --
411: g_nom_bal_def_table(l_index).balance_name := 'Retro Standard Tax Deduction Current Quarter'; --40
412: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_corr_ptd;
413: g_nom_bal_def_table(l_index).context := NULL;
414: g_nom_bal_def_table(l_index).context_val := NULL;
415: l_index := l_index + 1;

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

413: g_nom_bal_def_table(l_index).context := NULL;
414: g_nom_bal_def_table(l_index).context_val := NULL;
415: l_index := l_index + 1;
416: --
417: g_nom_bal_def_table(l_index).balance_name := 'Retro Standard Tax Deduction Current Quarter';
418: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_adj_ptd;
419: g_nom_bal_def_table(l_index).context := NULL;
420: g_nom_bal_def_table(l_index).context_val := NULL;
421: l_index := l_index + 1;

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

683: g_nom_bal_def_table(l_index).context := 'SOURCE_TEXT';
684: g_nom_bal_def_table(l_index).context_val := 'ZVW';
685: l_index := l_index + 1;
686: --
687: g_nom_bal_def_table(l_index).balance_name := 'Employer ZVW Contribution Standard Tax';
688: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_ptd;
689: g_nom_bal_def_table(l_index).context := 'SOURCE_TEXT';
690: g_nom_bal_def_table(l_index).context_val := 'ZVW';
691: l_index := l_index + 1;

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

689: g_nom_bal_def_table(l_index).context := 'SOURCE_TEXT';
690: g_nom_bal_def_table(l_index).context_val := 'ZVW';
691: l_index := l_index + 1;
692: --
693: g_nom_bal_def_table(l_index).balance_name := 'Retro Employer ZVW Contribution Standard Tax'; -- 87
694: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_corr_ptd;
695: g_nom_bal_def_table(l_index).context := 'SOURCE_TEXT';
696: g_nom_bal_def_table(l_index).context_val := 'ZVW';
697: l_index := l_index + 1;

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

695: g_nom_bal_def_table(l_index).context := 'SOURCE_TEXT';
696: g_nom_bal_def_table(l_index).context_val := 'ZVW';
697: l_index := l_index + 1;
698: --
699: g_nom_bal_def_table(l_index).balance_name := 'Retro Employer ZVW Contribution Standard Tax';
700: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_adj_ptd;
701: g_nom_bal_def_table(l_index).context := 'SOURCE_TEXT';
702: g_nom_bal_def_table(l_index).context_val := 'ZVW';
703: l_index := l_index + 1;

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

719: g_nom_bal_def_table(l_index).context := 'SOURCE_TEXT';
720: g_nom_bal_def_table(l_index).context_val := 'ZVW';
721: l_index := l_index + 1;
722: --
723: g_nom_bal_def_table(l_index).balance_name := 'Retro Standard Taxable Income'; -- 92
724: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_corr_ptd;
725: g_nom_bal_def_table(l_index).context := NULL;
726: g_nom_bal_def_table(l_index).context_val := NULL;
727: l_index := l_index + 1;

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

725: g_nom_bal_def_table(l_index).context := NULL;
726: g_nom_bal_def_table(l_index).context_val := NULL;
727: l_index := l_index + 1;
728: --
729: g_nom_bal_def_table(l_index).balance_name := 'Retro Standard Taxable Income';
730: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_adj_ptd;
731: g_nom_bal_def_table(l_index).context := NULL;
732: g_nom_bal_def_table(l_index).context_val := NULL;
733: l_index := l_index + 1;

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

731: g_nom_bal_def_table(l_index).context := NULL;
732: g_nom_bal_def_table(l_index).context_val := NULL;
733: l_index := l_index + 1;
734: --
735: g_nom_bal_def_table(l_index).balance_name := 'Retro Standard Tax Deduction'; -- 94
736: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_corr_ptd;
737: g_nom_bal_def_table(l_index).context := NULL;
738: g_nom_bal_def_table(l_index).context_val := NULL;
739: l_index := l_index + 1;

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

737: g_nom_bal_def_table(l_index).context := NULL;
738: g_nom_bal_def_table(l_index).context_val := NULL;
739: l_index := l_index + 1;
740: --
741: g_nom_bal_def_table(l_index).balance_name := 'Retro Standard Tax Deduction'; -- 95
742: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_adj_ptd;
743: g_nom_bal_def_table(l_index).context := NULL;
744: g_nom_bal_def_table(l_index).context_val := NULL;
745: l_index := l_index + 1;

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

743: g_nom_bal_def_table(l_index).context := NULL;
744: g_nom_bal_def_table(l_index).context_val := NULL;
745: l_index := l_index + 1;
746: -- Wage In Money
747: g_nom_bal_def_table(l_index).balance_name := 'Wage In Money Standard Tax Only'; --96
748: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_ptd;
749: g_nom_bal_def_table(l_index).context := NULL;
750: g_nom_bal_def_table(l_index).context_val := NULL;
751: l_index := l_index + 1;

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

748: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_ptd;
749: g_nom_bal_def_table(l_index).context := NULL;
750: g_nom_bal_def_table(l_index).context_val := NULL;
751: l_index := l_index + 1;
752: g_nom_bal_def_table(l_index).balance_name := 'Retro Wage In Money Standard Tax Only'; -- 97
753: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_corr_ptd;
754: g_nom_bal_def_table(l_index).context := NULL;
755: g_nom_bal_def_table(l_index).context_val := NULL;
756: l_index := l_index + 1;

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

753: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_corr_ptd;
754: g_nom_bal_def_table(l_index).context := NULL;
755: g_nom_bal_def_table(l_index).context_val := NULL;
756: l_index := l_index + 1;
757: g_nom_bal_def_table(l_index).balance_name := 'Retro Wage In Money Standard Tax Only';
758: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_adj_ptd;
759: g_nom_bal_def_table(l_index).context := NULL;
760: g_nom_bal_def_table(l_index).context_val := NULL;
761: l_index := l_index + 1;

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

775: g_nom_bal_def_table(l_index).context := NULL;
776: g_nom_bal_def_table(l_index).context_val := NULL;
777: l_index := l_index + 1;
778: -- Wage In Kind
779: g_nom_bal_def_table(l_index).balance_name := 'Wage In Kind Standard Tax Only'; -- 102
780: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_ptd;
781: g_nom_bal_def_table(l_index).context := NULL;
782: g_nom_bal_def_table(l_index).context_val := NULL;
783: l_index := l_index + 1;

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

780: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_ptd;
781: g_nom_bal_def_table(l_index).context := NULL;
782: g_nom_bal_def_table(l_index).context_val := NULL;
783: l_index := l_index + 1;
784: g_nom_bal_def_table(l_index).balance_name := 'Retro Wage In Kind Standard Tax Only';
785: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_corr_ptd;
786: g_nom_bal_def_table(l_index).context := NULL;
787: g_nom_bal_def_table(l_index).context_val := NULL;
788: l_index := l_index + 1;

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

785: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_corr_ptd;
786: g_nom_bal_def_table(l_index).context := NULL;
787: g_nom_bal_def_table(l_index).context_val := NULL;
788: l_index := l_index + 1;
789: g_nom_bal_def_table(l_index).balance_name := 'Retro Wage In Kind Standard Tax Only';
790: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_adj_ptd;
791: g_nom_bal_def_table(l_index).context := NULL;
792: g_nom_bal_def_table(l_index).context_val := NULL;
793: l_index := l_index + 1;

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

838: g_nom_bal_def_table(l_index).context := NULL;
839: g_nom_bal_def_table(l_index).context_val := NULL;
840: l_index := l_index + 1;
841: --
842: g_nom_bal_def_table(l_index).balance_name := 'Standard Tax Correction'; -- 114
843: g_nom_bal_def_table(l_index).database_item_suffix := l_asg_ptd;
844: g_nom_bal_def_table(l_index).context := NULL;
845: g_nom_bal_def_table(l_index).context_val := NULL;
846: l_index := l_index + 1;

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

1158: --
1159: --Fnd_file.put_line(FND_FILE.LOG,' Populating Balanace Table for Collective Report');
1160: g_col_bal_def_table.delete;
1161: x:=1;
1162: g_col_bal_def_table(x).balance_name := 'Standard Taxable Income'; --1
1163: g_col_bal_def_table(x).database_item_suffix := l_tu_payroll_ptd;
1164: g_col_bal_def_table(x).database_item_suffix2 := NULL;
1165: g_col_bal_def_table(x).context := NULL;
1166: g_col_bal_def_table(x).context_val := NULL;

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

1164: g_col_bal_def_table(x).database_item_suffix2 := NULL;
1165: g_col_bal_def_table(x).context := NULL;
1166: g_col_bal_def_table(x).context_val := NULL;
1167: x := x+1;
1168: g_col_bal_def_table(x).balance_name := 'Retro Standard Taxable Income Current Quarter';
1169: g_col_bal_def_table(x).database_item_suffix := l_tu_payroll_adj_ptd;
1170: g_col_bal_def_table(x).database_item_suffix2 := l_tu_payroll_corr_ptd;
1171: g_col_bal_def_table(x).context := NULL;
1172: g_col_bal_def_table(x).context_val := NULL;

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

1182: g_col_bal_def_table(x).database_item_suffix2 := l_tu_payroll_corr_ptd;
1183: g_col_bal_def_table(x).context := NULL;
1184: g_col_bal_def_table(x).context_val := NULL;
1185: x := x+1;
1186: g_col_bal_def_table(x).balance_name := 'Retro Standard Taxable Income'; --5
1187: g_col_bal_def_table(x).database_item_suffix := l_tu_payroll_adj_ptd;
1188: g_col_bal_def_table(x).database_item_suffix2 := l_tu_payroll_corr_ptd;
1189: g_col_bal_def_table(x).context := NULL;
1190: g_col_bal_def_table(x).context_val := NULL;

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

1188: g_col_bal_def_table(x).database_item_suffix2 := l_tu_payroll_corr_ptd;
1189: g_col_bal_def_table(x).context := NULL;
1190: g_col_bal_def_table(x).context_val := NULL;
1191: x := x+1;
1192: g_col_bal_def_table(x).balance_name := 'SI Income Standard Tax'; --6
1193: g_col_bal_def_table(x).database_item_suffix := l_tu_payroll_ptd;
1194: g_col_bal_def_table(x).database_item_suffix2 := NULL;
1195: g_col_bal_def_table(x).context := NULL;
1196: g_col_bal_def_table(x).context_val := NULL;

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

1194: g_col_bal_def_table(x).database_item_suffix2 := NULL;
1195: g_col_bal_def_table(x).context := NULL;
1196: g_col_bal_def_table(x).context_val := NULL;
1197: x := x+1;
1198: g_col_bal_def_table(x).balance_name := 'Retro SI Income Standard Tax';
1199: g_col_bal_def_table(x).database_item_suffix := l_tu_payroll_adj_ptd;
1200: g_col_bal_def_table(x).database_item_suffix2 := l_tu_payroll_corr_ptd;
1201: g_col_bal_def_table(x).context := NULL;
1202: g_col_bal_def_table(x).context_val := NULL;

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

1272: g_col_bal_def_table(x).database_item_suffix2 := l_tu_sit_payroll_corr_ptd;
1273: g_col_bal_def_table(x).context := 'SOURCE_TEXT';
1274: g_col_bal_def_table(x).context_val := 'UFO' ;
1275: x := x+1;
1276: g_col_bal_def_table(x).balance_name := 'Employer ZVW Contribution Standard Tax';
1277: g_col_bal_def_table(x).database_item_suffix := l_tu_payroll_ptd;
1278: g_col_bal_def_table(x).database_item_suffix2 := NULL;
1279: g_col_bal_def_table(x).context := 'SOURCE_TEXT';
1280: g_col_bal_def_table(x).context_val := 'ZVW' ; --20

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

1296: g_col_bal_def_table(x).database_item_suffix2 := NULL;
1297: g_col_bal_def_table(x).context := 'SOURCE_TEXT';
1298: g_col_bal_def_table(x).context_val := 'ZVW' ;
1299: x := x+1;
1300: g_col_bal_def_table(x).balance_name := 'Retro Employer ZVW Contribution Standard Tax';
1301: g_col_bal_def_table(x).database_item_suffix := l_tu_payroll_adj_ptd;
1302: g_col_bal_def_table(x).database_item_suffix2 := l_tu_payroll_corr_ptd;
1303: g_col_bal_def_table(x).context := 'SOURCE_TEXT';
1304: g_col_bal_def_table(x).context_val := 'ZVW' ;

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

1320: g_col_bal_def_table(x).database_item_suffix2 := l_tu_sit_payroll_corr_ptd;
1321: g_col_bal_def_table(x).context := 'SOURCE_TEXT';
1322: g_col_bal_def_table(x).context_val := 'ZVW' ; --27
1323: x := x+1;
1324: g_col_bal_def_table(x).balance_name := 'Standard Tax Deduction'; --28
1325: g_col_bal_def_table(x).database_item_suffix := l_tu_payroll_ptd;
1326: g_col_bal_def_table(x).database_item_suffix2 := NULL;
1327: g_col_bal_def_table(x).context := NULL;
1328: g_col_bal_def_table(x).context_val := NULL;

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

1326: g_col_bal_def_table(x).database_item_suffix2 := NULL;
1327: g_col_bal_def_table(x).context := NULL;
1328: g_col_bal_def_table(x).context_val := NULL;
1329: x := x+1;
1330: g_col_bal_def_table(x).balance_name := 'Retro Standard Tax Deduction Current Quarter';
1331: g_col_bal_def_table(x).database_item_suffix := l_tu_payroll_adj_ptd;
1332: g_col_bal_def_table(x).database_item_suffix2 := l_tu_payroll_corr_ptd;
1333: g_col_bal_def_table(x).context := NULL;
1334: g_col_bal_def_table(x).context_val := NULL ;

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

1344: g_col_bal_def_table(x).database_item_suffix2 := l_tu_payroll_corr_ptd;
1345: g_col_bal_def_table(x).context := NULL;
1346: g_col_bal_def_table(x).context_val := NULL ;
1347: x := x+1;
1348: g_col_bal_def_table(x).balance_name := 'Retro Standard Tax Deduction'; --32
1349: g_col_bal_def_table(x).database_item_suffix := l_tu_payroll_adj_ptd;
1350: g_col_bal_def_table(x).database_item_suffix2 := l_tu_payroll_corr_ptd;
1351: g_col_bal_def_table(x).context := NULL;
1352: g_col_bal_def_table(x).context_val := NULL ;

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

1636: g_col_bal_def_table(x).database_item_suffix2 := l_tu_payroll_corr_ptd;
1637: g_col_bal_def_table(x).context := NULL;
1638: g_col_bal_def_table(x).context_val := NULL;
1639: x := x+1;
1640: g_col_bal_def_table(x).balance_name := 'Standard Tax Correction'; --78
1641: g_col_bal_def_table(x).database_item_suffix := l_tu_payroll_ptd;
1642: g_col_bal_def_table(x).database_item_suffix2 := NULL;
1643: g_col_bal_def_table(x).context := NULL;
1644: g_col_bal_def_table(x).context_val := NULL;

Line 6087: AND rc.short_name = 'Standard'

6083: AND rr2.element_entry_id = pee2.element_entry_id
6084: AND pee2.element_entry_id = pre.element_entry_id
6085: AND pre.retro_component_id = rc.retro_component_id
6086: AND rc.legislation_code = 'NL'
6087: AND rc.short_name = 'Standard'
6088: AND c_effective_date between pee1.effective_start_date and pee1.effective_end_date
6089: AND c_effective_date between pee2.effective_start_date and pee2.effective_end_date;*/
6090: --
6091: CURSOR csr_get_corr_retro_periods(c_assignment_action_id NUMBER

Line 6112: AND rc.short_name = 'Standard'

6108: AND esu.retro_component_usage_id = rcu.retro_component_usage_id
6109: AND rcu.creator_type = 'ET' -- check
6110: AND rcu.retro_component_id = rc.retro_component_id
6111: AND rc.legislation_code = 'NL'
6112: AND rc.short_name = 'Standard'
6113: AND c_effective_date between pee1.effective_start_date and pee1.effective_end_date
6114: AND paa.payroll_action_id = ppa.payroll_action_id
6115: AND ptp.payroll_id = ppa.payroll_id
6116: AND rr1.start_date BETWEEN ptp.start_date and ptp.end_date

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

6126: AND rr.element_type_id = esu.retro_element_type_id
6127: AND esu.retro_component_usage_id = rcu.retro_component_usage_id
6128: AND rcu.retro_component_id = rc.retro_component_id
6129: AND rc.legislation_code = 'NL'
6130: AND rc.short_name = 'Standard';*/
6131: --
6132: CURSOR csr_get_assignment_action_id(c_assignment_id NUMBER
6133: ,c_date DATE) IS
6134: SELECT max(paa.assignment_action_id) assignment_action_id