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_SE_TAX_DECL dependencies on PAY_BALANCE_PKG

Line 229: nvl(pay_balance_pkg.get_value(get_defined_balance_id

225: ou.Name Organization_Name,
226: hoi2.org_information2 Organization_Number,
227: TO_CHAR(TO_DATE(hoi4.org_information1,'MM'),'MONTH') Month,
228: hoi4.org_information2 Year,
229: nvl(pay_balance_pkg.get_value(get_defined_balance_id
230: ('Gross Pay','_LE_MONTH'),NULL,l_legal_employer_id,
231: NULL,NULL,NULL,l_effective_date),0) Gross_Pay,
232: nvl(pay_balance_pkg.get_value(get_defined_balance_id
233: ('Employer Taxable Benefits in Kind','_LE_MONTH'),NULL,l_legal_employer_id,

Line 232: nvl(pay_balance_pkg.get_value(get_defined_balance_id

228: hoi4.org_information2 Year,
229: nvl(pay_balance_pkg.get_value(get_defined_balance_id
230: ('Gross Pay','_LE_MONTH'),NULL,l_legal_employer_id,
231: NULL,NULL,NULL,l_effective_date),0) Gross_Pay,
232: nvl(pay_balance_pkg.get_value(get_defined_balance_id
233: ('Employer Taxable Benefits in Kind','_LE_MONTH'),NULL,l_legal_employer_id,
234: NULL,NULL,NULL,l_effective_date),0) Benefit,
235: --hoi4.org_information3 Reduction,
236: nvl(pay_balance_pkg.get_value(get_defined_balance_id

Line 236: nvl(pay_balance_pkg.get_value(get_defined_balance_id

232: nvl(pay_balance_pkg.get_value(get_defined_balance_id
233: ('Employer Taxable Benefits in Kind','_LE_MONTH'),NULL,l_legal_employer_id,
234: NULL,NULL,NULL,l_effective_date),0) Benefit,
235: --hoi4.org_information3 Reduction,
236: nvl(pay_balance_pkg.get_value(get_defined_balance_id
237: ('Cost Reduction','_LE_MONTH'),NULL,l_legal_employer_id,
238: NULL,NULL,NULL,l_effective_date),0) Reduction,
239: nvl(pay_balance_pkg.get_value(get_defined_balance_id
240: ('Regular Employer Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,

Line 239: nvl(pay_balance_pkg.get_value(get_defined_balance_id

235: --hoi4.org_information3 Reduction,
236: nvl(pay_balance_pkg.get_value(get_defined_balance_id
237: ('Cost Reduction','_LE_MONTH'),NULL,l_legal_employer_id,
238: NULL,NULL,NULL,l_effective_date),0) Reduction,
239: nvl(pay_balance_pkg.get_value(get_defined_balance_id
240: ('Regular Employer Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,
241: NULL,NULL,NULL,l_effective_date),0) Regular_Taxable_Base,
242: nvl(pay_balance_pkg.get_value(get_defined_balance_id
243: ('Regular Employer Tax','_LE_MONTH'),NULL,l_legal_employer_id,

Line 242: nvl(pay_balance_pkg.get_value(get_defined_balance_id

238: NULL,NULL,NULL,l_effective_date),0) Reduction,
239: nvl(pay_balance_pkg.get_value(get_defined_balance_id
240: ('Regular Employer Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,
241: NULL,NULL,NULL,l_effective_date),0) Regular_Taxable_Base,
242: nvl(pay_balance_pkg.get_value(get_defined_balance_id
243: ('Regular Employer Tax','_LE_MONTH'),NULL,l_legal_employer_id,
244: NULL,NULL,NULL,l_effective_date),0) Regular_Tax,
245: nvl(pay_balance_pkg.get_value(get_defined_balance_id
246: ('Special Taxation Age 65 Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,

Line 245: nvl(pay_balance_pkg.get_value(get_defined_balance_id

241: NULL,NULL,NULL,l_effective_date),0) Regular_Taxable_Base,
242: nvl(pay_balance_pkg.get_value(get_defined_balance_id
243: ('Regular Employer Tax','_LE_MONTH'),NULL,l_legal_employer_id,
244: NULL,NULL,NULL,l_effective_date),0) Regular_Tax,
245: nvl(pay_balance_pkg.get_value(get_defined_balance_id
246: ('Special Taxation Age 65 Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,
247: NULL,NULL,NULL,l_effective_date),0) Special_65_Taxable_Base,
248: nvl(pay_balance_pkg.get_value(get_defined_balance_id
249: ('Special Taxation Age 65 Tax','_LE_MONTH'),NULL,l_legal_employer_id,

Line 248: nvl(pay_balance_pkg.get_value(get_defined_balance_id

244: NULL,NULL,NULL,l_effective_date),0) Regular_Tax,
245: nvl(pay_balance_pkg.get_value(get_defined_balance_id
246: ('Special Taxation Age 65 Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,
247: NULL,NULL,NULL,l_effective_date),0) Special_65_Taxable_Base,
248: nvl(pay_balance_pkg.get_value(get_defined_balance_id
249: ('Special Taxation Age 65 Tax','_LE_MONTH'),NULL,l_legal_employer_id,
250: NULL,NULL,NULL,l_effective_date),0) Special_65_Tax,
251: nvl(pay_balance_pkg.get_value(get_defined_balance_id
252: ('Special Taxation Year 1937 Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,

Line 251: nvl(pay_balance_pkg.get_value(get_defined_balance_id

247: NULL,NULL,NULL,l_effective_date),0) Special_65_Taxable_Base,
248: nvl(pay_balance_pkg.get_value(get_defined_balance_id
249: ('Special Taxation Age 65 Tax','_LE_MONTH'),NULL,l_legal_employer_id,
250: NULL,NULL,NULL,l_effective_date),0) Special_65_Tax,
251: nvl(pay_balance_pkg.get_value(get_defined_balance_id
252: ('Special Taxation Year 1937 Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,
253: NULL,NULL,NULL,l_effective_date),0) Special_1937_Taxable_Base,
254: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
255: ('Special Taxation Year 1937 Tax','_LE_MONTH'),NULL,l_legal_employer_id,

Line 254: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id

250: NULL,NULL,NULL,l_effective_date),0) Special_65_Tax,
251: nvl(pay_balance_pkg.get_value(get_defined_balance_id
252: ('Special Taxation Year 1937 Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,
253: NULL,NULL,NULL,l_effective_date),0) Special_1937_Taxable_Base,
254: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
255: ('Special Taxation Year 1937 Tax','_LE_MONTH'),NULL,l_legal_employer_id,
256: NULL,NULL,NULL,l_effective_date),0) Special_1937_Tax,
257: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
258: ('Foreigners Below 65 Employer Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,

Line 257: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id

253: NULL,NULL,NULL,l_effective_date),0) Special_1937_Taxable_Base,
254: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
255: ('Special Taxation Year 1937 Tax','_LE_MONTH'),NULL,l_legal_employer_id,
256: NULL,NULL,NULL,l_effective_date),0) Special_1937_Tax,
257: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
258: ('Foreigners Below 65 Employer Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,
259: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu,
260: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
261: ('Foreigners Below 65 Employer Tax','_LE_MONTH'),NULL,l_legal_employer_id,

Line 260: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id

256: NULL,NULL,NULL,l_effective_date),0) Special_1937_Tax,
257: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
258: ('Foreigners Below 65 Employer Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,
259: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu,
260: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
261: ('Foreigners Below 65 Employer Tax','_LE_MONTH'),NULL,l_legal_employer_id,
262: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_29,
263: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
264: ('Foreigners Below 25 Employer Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,

Line 263: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id

259: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu,
260: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
261: ('Foreigners Below 65 Employer Tax','_LE_MONTH'),NULL,l_legal_employer_id,
262: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_29,
263: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
264: ('Foreigners Below 25 Employer Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,
265: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_25_Below,
266: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
267: ('Foreigners Below 25 Employer Tax','_LE_MONTH'),NULL,l_legal_employer_id,

Line 266: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id

262: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_29,
263: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
264: ('Foreigners Below 25 Employer Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,
265: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_25_Below,
266: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
267: ('Foreigners Below 25 Employer Tax','_LE_MONTH'),NULL,l_legal_employer_id,
268: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_29_25_below,
269: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
270: ('Foreigners Above 65 Employer Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,

Line 269: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id

265: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_25_Below,
266: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
267: ('Foreigners Below 25 Employer Tax','_LE_MONTH'),NULL,l_legal_employer_id,
268: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_29_25_below,
269: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
270: ('Foreigners Above 65 Employer Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,
271: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_65_above,
272: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
273: ('Foreigners Above 65 Employer Tax','_LE_MONTH'),NULL,l_legal_employer_id,

Line 272: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id

268: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_29_25_below,
269: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
270: ('Foreigners Above 65 Employer Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,
271: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_65_above,
272: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
273: ('Foreigners Above 65 Employer Tax','_LE_MONTH'),NULL,l_legal_employer_id,
274: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_29_65_above,
275: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
276: ('Special Taxation Age 25 below Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,

Line 275: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id

271: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_65_above,
272: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
273: ('Foreigners Above 65 Employer Tax','_LE_MONTH'),NULL,l_legal_employer_id,
274: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_29_65_above,
275: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
276: ('Special Taxation Age 25 below Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,
277: NULL,NULL,NULL,l_effective_date),0) Special_25_below_Taxable_Base,
278: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
279: ('Special Taxation Age 25 below Tax','_LE_MONTH'),NULL,l_legal_employer_id,

Line 278: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id

274: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_29_65_above,
275: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
276: ('Special Taxation Age 25 below Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,
277: NULL,NULL,NULL,l_effective_date),0) Special_25_below_Taxable_Base,
278: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
279: ('Special Taxation Age 25 below Tax','_LE_MONTH'),NULL,l_legal_employer_id,
280: NULL,NULL,NULL,l_effective_date),0) Special_25_below_Tax,
281: nvl(hoi4.org_information4,0) Certain_Insurances,
282: nvl(hoi4.org_information5,0) Certain_Insurances_29,

Line 292: nvl(pay_balance_pkg.get_value(get_defined_balance_id

288: -- nvl(hoi4.org_information10,0) Comp_Support_5, --EOY 2008
289: nvl(hoi4.org_information11,0) Ext_Comp_Support,
290: nvl(hoi4.org_information12,0) Ext_Comp_Support_10,
291: --
292: nvl(pay_balance_pkg.get_value(get_defined_balance_id
293: ('Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,
294: NULL,NULL,NULL,l_effective_date),0)
295: Taxable_Base,
296: nvl(pay_balance_pkg.get_value(get_defined_balance_id

Line 296: nvl(pay_balance_pkg.get_value(get_defined_balance_id

292: nvl(pay_balance_pkg.get_value(get_defined_balance_id
293: ('Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,
294: NULL,NULL,NULL,l_effective_date),0)
295: Taxable_Base,
296: nvl(pay_balance_pkg.get_value(get_defined_balance_id
297: ('Employee Tax','_LE_MONTH'),NULL,l_legal_employer_id,
298: NULL,NULL,NULL,l_effective_date),0) Employee_Tax,
299: nvl(hoi4.org_information13,0) Pension,
300: nvl(hoi4.org_information14,0) Ded_Pension,

Line 381: pay_balance_pkg.set_context('TAX_UNIT_ID',l_legal_employer_id);

377: -- archive Report Details only if no record exists
378: IF (l_count < 1) THEN
379: BEGIN
380:
381: pay_balance_pkg.set_context('TAX_UNIT_ID',l_legal_employer_id);
382:
383: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_effective_date)
384: );
385: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);

Line 383: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_effective_date)

379: BEGIN
380:
381: pay_balance_pkg.set_context('TAX_UNIT_ID',l_legal_employer_id);
382:
383: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_effective_date)
384: );
385: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
386: pay_balance_pkg.set_context('SOURCE_ID',NULL);
387: pay_balance_pkg.set_context('TAX_GROUP',NULL);

Line 385: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);

381: pay_balance_pkg.set_context('TAX_UNIT_ID',l_legal_employer_id);
382:
383: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_effective_date)
384: );
385: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
386: pay_balance_pkg.set_context('SOURCE_ID',NULL);
387: pay_balance_pkg.set_context('TAX_GROUP',NULL);
388: END;
389:

Line 386: pay_balance_pkg.set_context('SOURCE_ID',NULL);

382:
383: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_effective_date)
384: );
385: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
386: pay_balance_pkg.set_context('SOURCE_ID',NULL);
387: pay_balance_pkg.set_context('TAX_GROUP',NULL);
388: END;
389:
390:

Line 387: pay_balance_pkg.set_context('TAX_GROUP',NULL);

383: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_effective_date)
384: );
385: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
386: pay_balance_pkg.set_context('SOURCE_ID',NULL);
387: pay_balance_pkg.set_context('TAX_GROUP',NULL);
388: END;
389:
390:
391: