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_FI_PAYLIST dependencies on FND_NUMBER

Line 98: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information4))

94:
95: CURSOR csr_total (csr_v_pa_id IN VARCHAR2)
96: IS
97: SELECT
98: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information4))
99: salary,
100: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information5)) benefits,
101: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information6))
102: insurance_salary,

Line 100: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information5)) benefits,

96: IS
97: SELECT
98: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information4))
99: salary,
100: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information5)) benefits,
101: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information6))
102: insurance_salary,
103: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information7))
104: deductions_withhold_tax,

Line 101: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information6))

97: SELECT
98: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information4))
99: salary,
100: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information5)) benefits,
101: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information6))
102: insurance_salary,
103: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information7))
104: deductions_withhold_tax,
105: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information8)) tax_income,

Line 103: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information7))

99: salary,
100: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information5)) benefits,
101: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information6))
102: insurance_salary,
103: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information7))
104: deductions_withhold_tax,
105: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information8)) tax_income,
106: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information9))
107: withhold_tax,

Line 105: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information8)) tax_income,

101: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information6))
102: insurance_salary,
103: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information7))
104: deductions_withhold_tax,
105: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information8)) tax_income,
106: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information9))
107: withhold_tax,
108: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information10) )expenses,
109: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information11))

Line 106: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information9))

102: insurance_salary,
103: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information7))
104: deductions_withhold_tax,
105: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information8)) tax_income,
106: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information9))
107: withhold_tax,
108: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information10) )expenses,
109: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information11))
110: after_tax_deductions,

Line 108: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information10) )expenses,

104: deductions_withhold_tax,
105: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information8)) tax_income,
106: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information9))
107: withhold_tax,
108: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information10) )expenses,
109: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information11))
110: after_tax_deductions,
111: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information12))net_pay,
112: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information13)) capital_income_base

Line 109: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information11))

105: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information8)) tax_income,
106: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information9))
107: withhold_tax,
108: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information10) )expenses,
109: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information11))
110: after_tax_deductions,
111: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information12))net_pay,
112: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information13)) capital_income_base
113: FROM pay_payroll_actions ppa,

Line 111: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information12))net_pay,

107: withhold_tax,
108: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information10) )expenses,
109: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information11))
110: after_tax_deductions,
111: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information12))net_pay,
112: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information13)) capital_income_base
113: FROM pay_payroll_actions ppa,
114: pay_assignment_actions paa,
115: pay_action_information pai_ass

Line 112: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information13)) capital_income_base

108: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information10) )expenses,
109: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information11))
110: after_tax_deductions,
111: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information12))net_pay,
112: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information13)) capital_income_base
113: FROM pay_payroll_actions ppa,
114: pay_assignment_actions paa,
115: pay_action_information pai_ass
116: WHERE ppa.payroll_action_id = csr_v_pa_id

Line 197: -- fnd_number.canonical_to_number(payl_rep.salary);

193:
194: gplsqltable (l_counter).tagname := 'SALARY';
195: gplsqltable (l_counter).tagvalue :=
196: payl_rep.salary;
197: -- fnd_number.canonical_to_number(payl_rep.salary);
198:
199: l_counter := l_counter
200: + 1;
201: gplsqltable (l_counter).tagname := 'BENEFITS';

Line 204: -- fnd_number.canonical_to_number(payl_rep.benefits);

200: + 1;
201: gplsqltable (l_counter).tagname := 'BENEFITS';
202: gplsqltable (l_counter).tagvalue :=
203: payl_rep.benefits;
204: -- fnd_number.canonical_to_number(payl_rep.benefits);
205:
206: l_counter := l_counter
207: + 1;
208: gplsqltable (l_counter).tagname := 'INSURANCE_SALARY';

Line 211: -- fnd_number.canonical_to_number(payl_rep.insurance_salary);

207: + 1;
208: gplsqltable (l_counter).tagname := 'INSURANCE_SALARY';
209: gplsqltable (l_counter).tagvalue :=
210: payl_rep.insurance_salary;
211: -- fnd_number.canonical_to_number(payl_rep.insurance_salary);
212:
213: l_counter := l_counter
214: + 1;
215: gplsqltable (l_counter).tagname := 'DEDUCTIONS_WITHHOLD_TAX';

Line 218: -- fnd_number.canonical_to_number(payl_rep.deductions_withhold_tax);

214: + 1;
215: gplsqltable (l_counter).tagname := 'DEDUCTIONS_WITHHOLD_TAX';
216: gplsqltable (l_counter).tagvalue :=
217: payl_rep.deductions_withhold_tax;
218: -- fnd_number.canonical_to_number(payl_rep.deductions_withhold_tax);
219:
220: l_counter := l_counter
221: + 1;
222: gplsqltable (l_counter).tagname := 'TAX_INCOME';

Line 225: -- fnd_number.canonical_to_number(payl_rep.tax_income);

221: + 1;
222: gplsqltable (l_counter).tagname := 'TAX_INCOME';
223: gplsqltable (l_counter).tagvalue :=
224: payl_rep.tax_income;
225: -- fnd_number.canonical_to_number(payl_rep.tax_income);
226:
227: l_counter := l_counter
228: + 1;
229: gplsqltable (l_counter).tagname := 'CAPITAL_INCOME_BASE';

Line 232: -- fnd_number.canonical_to_number(payl_rep.capital_income_base);

228: + 1;
229: gplsqltable (l_counter).tagname := 'CAPITAL_INCOME_BASE';
230: gplsqltable (l_counter).tagvalue :=
231: payl_rep.capital_income_base;
232: -- fnd_number.canonical_to_number(payl_rep.capital_income_base);
233:
234: l_counter := l_counter
235: + 1;
236: gplsqltable (l_counter).tagname := 'WITHHOLD_TAX';

Line 239: --fnd_number.canonical_to_number(payl_rep.withhold_Tax);

235: + 1;
236: gplsqltable (l_counter).tagname := 'WITHHOLD_TAX';
237: gplsqltable (l_counter).tagvalue :=
238: payl_rep.withhold_Tax;
239: --fnd_number.canonical_to_number(payl_rep.withhold_Tax);
240:
241: l_counter := l_counter
242: + 1;
243: gplsqltable (l_counter).tagname := 'EXPENSES';

Line 246: --fnd_number.canonical_to_number(payl_rep.expenses);

242: + 1;
243: gplsqltable (l_counter).tagname := 'EXPENSES';
244: gplsqltable (l_counter).tagvalue :=
245: payl_rep.expenses;
246: --fnd_number.canonical_to_number(payl_rep.expenses);
247:
248: l_counter := l_counter
249: + 1;
250: gplsqltable (l_counter).tagname := 'AFTER_TAX_DEDUCTIONS';

Line 253: --fnd_number.canonical_to_number(payl_rep.after_tax_deductions);

249: + 1;
250: gplsqltable (l_counter).tagname := 'AFTER_TAX_DEDUCTIONS';
251: gplsqltable (l_counter).tagvalue :=
252: payl_rep.after_tax_deductions;
253: --fnd_number.canonical_to_number(payl_rep.after_tax_deductions);
254:
255: l_counter := l_counter
256: + 1;
257: gplsqltable (l_counter).tagname := 'NET_PAY';

Line 260: --fnd_number.canonical_to_number(payl_rep.net_pay);

256: + 1;
257: gplsqltable (l_counter).tagname := 'NET_PAY';
258: gplsqltable (l_counter).tagvalue :=
259: payl_rep.net_pay;
260: --fnd_number.canonical_to_number(payl_rep.net_pay);
261:
262: l_counter := l_counter
263: + 1;
264:

Line 298: -- fnd_number.canonical_to_number(csr_total_REC.salary);

294:
295: gplsqltable (l_counter).tagname := 'SALARY';
296: gplsqltable (l_counter).tagvalue :=
297: csr_total_REC.salary;
298: -- fnd_number.canonical_to_number(csr_total_REC.salary);
299:
300: l_counter := l_counter
301: + 1;
302: gplsqltable (l_counter).tagname := 'BENEFITS';

Line 305: -- fnd_number.canonical_to_number(csr_total_REC.benefits);

301: + 1;
302: gplsqltable (l_counter).tagname := 'BENEFITS';
303: gplsqltable (l_counter).tagvalue :=
304: csr_total_REC.benefits;
305: -- fnd_number.canonical_to_number(csr_total_REC.benefits);
306:
307: l_counter := l_counter
308: + 1;
309: gplsqltable (l_counter).tagname := 'INSURANCE_SALARY';

Line 312: -- fnd_number.canonical_to_number(csr_total_REC.insurance_salary);

308: + 1;
309: gplsqltable (l_counter).tagname := 'INSURANCE_SALARY';
310: gplsqltable (l_counter).tagvalue :=
311: csr_total_REC.insurance_salary;
312: -- fnd_number.canonical_to_number(csr_total_REC.insurance_salary);
313:
314: l_counter := l_counter
315: + 1;
316: gplsqltable (l_counter).tagname := 'DEDUCTIONS_WITHHOLD_TAX';

Line 319: -- fnd_number.canonical_to_number(csr_total_REC.deductions_withhold_tax);

315: + 1;
316: gplsqltable (l_counter).tagname := 'DEDUCTIONS_WITHHOLD_TAX';
317: gplsqltable (l_counter).tagvalue :=
318: csr_total_REC.deductions_withhold_tax;
319: -- fnd_number.canonical_to_number(csr_total_REC.deductions_withhold_tax);
320:
321: l_counter := l_counter
322: + 1;
323: gplsqltable (l_counter).tagname := 'TAX_INCOME';

Line 326: -- fnd_number.canonical_to_number(csr_total_REC.tax_income);

322: + 1;
323: gplsqltable (l_counter).tagname := 'TAX_INCOME';
324: gplsqltable (l_counter).tagvalue :=
325: csr_total_REC.tax_income;
326: -- fnd_number.canonical_to_number(csr_total_REC.tax_income);
327:
328: l_counter := l_counter
329: + 1;
330: gplsqltable (l_counter).tagname := 'CAPITAL_INCOME_BASE';

Line 333: -- fnd_number.canonical_to_number(csr_total_REC.capital_income_base);

329: + 1;
330: gplsqltable (l_counter).tagname := 'CAPITAL_INCOME_BASE';
331: gplsqltable (l_counter).tagvalue :=
332: csr_total_REC.capital_income_base;
333: -- fnd_number.canonical_to_number(csr_total_REC.capital_income_base);
334:
335: l_counter := l_counter
336: + 1;
337: gplsqltable (l_counter).tagname := 'WITHHOLD_TAX';

Line 340: --fnd_number.canonical_to_number(csr_total_REC.withhold_Tax);

336: + 1;
337: gplsqltable (l_counter).tagname := 'WITHHOLD_TAX';
338: gplsqltable (l_counter).tagvalue :=
339: csr_total_REC.withhold_Tax;
340: --fnd_number.canonical_to_number(csr_total_REC.withhold_Tax);
341:
342: l_counter := l_counter
343: + 1;
344: gplsqltable (l_counter).tagname := 'EXPENSES';

Line 347: --fnd_number.canonical_to_number(csr_total_REC.expenses);

343: + 1;
344: gplsqltable (l_counter).tagname := 'EXPENSES';
345: gplsqltable (l_counter).tagvalue :=
346: csr_total_REC.expenses;
347: --fnd_number.canonical_to_number(csr_total_REC.expenses);
348:
349: l_counter := l_counter
350: + 1;
351: gplsqltable (l_counter).tagname := 'AFTER_TAX_DEDUCTIONS';

Line 354: --fnd_number.canonical_to_number(csr_total_REC.after_tax_deductions);

350: + 1;
351: gplsqltable (l_counter).tagname := 'AFTER_TAX_DEDUCTIONS';
352: gplsqltable (l_counter).tagvalue :=
353: csr_total_REC.after_tax_deductions;
354: --fnd_number.canonical_to_number(csr_total_REC.after_tax_deductions);
355:
356: l_counter := l_counter
357: + 1;
358: gplsqltable (l_counter).tagname := 'NET_PAY';

Line 361: --fnd_number.canonical_to_number(csr_total_REC.net_pay);

357: + 1;
358: gplsqltable (l_counter).tagname := 'NET_PAY';
359: gplsqltable (l_counter).tagvalue :=
360: csr_total_REC.net_pay;
361: --fnd_number.canonical_to_number(csr_total_REC.net_pay);
362:
363: l_counter := l_counter
364: + 1;
365: