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_MX_SOE_SS_PKG dependencies on FND_CURRENCY

Line 69: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16

65:
66: lv_sql := 'select earn_bal_name COL01
67: ,nvl(earn_reporting_name, earn_bal_name) COL02
68: ,to_char(days_run_val
69: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
70: ,to_char(earn_run_val
71: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL17
72: from PAY_MX_EMPLOYEE_EARNINGS_V
73: where assignment_action_id :action_clause

Line 71: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL17

67: ,nvl(earn_reporting_name, earn_bal_name) COL02
68: ,to_char(days_run_val
69: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
70: ,to_char(earn_run_val
71: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL17
72: from PAY_MX_EMPLOYEE_EARNINGS_V
73: where assignment_action_id :action_clause
74: and earn_run_val <> 0';
75:

Line 94: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16

90:
91: lv_sql := 'select balance_name COL01
92: ,nvl(reporting_name, balance_name) COL02
93: ,to_char(run_val
94: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
95: from PAY_MX_EMPLOYEE_TAXES_V
96: where assignment_action_id :action_clause
97: and run_val <> 0';
98:

Line 117: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16

113:
114: lv_sql := 'select balance_name COL01
115: ,nvl(reporting_name, balance_name) COL02
116: ,to_char(run_val
117: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
118: from PAY_MX_TAX_CALC_DETAILS_V
119: where assignment_action_id :action_clause
120: and run_val <> 0';
121:

Line 218: ,fnd_currency.get_format_mask(lv_currency_code,40));

214: ln_bal_value := pay_balance_pkg.get_value(summary(i).curr_def_bal_id
215: ,p_assignment_action_id);
216: summary(i).curr_val :=
217: to_char(ln_bal_value
218: ,fnd_currency.get_format_mask(lv_currency_code,40));
219:
220: -- summary(i).ytd_val :=
221: -- pay_balance_pkg.get_value(summary(i).ytd_def_bal_id
222: -- ,p_assignment_action_id);

Line 251: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16

247:
248: lv_sql := 'select earn_bal_name COL01
249: ,nvl(earn_reporting_name, earn_bal_name) COL02
250: ,to_char(hours_run_val
251: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
252: ,to_char(earn_run_val
253: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL17
254: from PAY_MX_HOURLY_EARNINGS_V
255: where assignment_action_id :action_clause

Line 253: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL17

249: ,nvl(earn_reporting_name, earn_bal_name) COL02
250: ,to_char(hours_run_val
251: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
252: ,to_char(earn_run_val
253: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL17
254: from PAY_MX_HOURLY_EARNINGS_V
255: where assignment_action_id :action_clause
256: and earn_run_val <> 0';
257:

Line 276: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16

272:
273: lv_sql := 'select balance_name COL01
274: ,nvl(reporting_name, balance_name) COL02
275: ,to_char(run_val
276: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
277: from PAY_MX_TAXABLE_BENEFITS_V
278: where assignment_action_id :action_clause
279: and run_val <> 0';
280:

Line 299: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16

295:
296: lv_sql := 'select balance_name COL01
297: ,nvl(reporting_name, balance_name) COL02
298: ,to_char(run_val
299: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
300: from PAY_MX_TAX_BALANCES_V
301: where assignment_action_id :action_clause
302: and run_val <> 0';
303:

Line 322: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16

318:
319: lv_sql := 'select balance_name COL01
320: ,nvl(reporting_name, balance_name) COL02
321: ,to_char(run_val
322: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
323: from PAY_MX_DEDUCTIONS_V
324: where assignment_action_id :action_clause
325: and run_val <> 0';
326:

Line 345: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16

341:
342: lv_sql := 'select balance_name COL01
343: ,nvl(reporting_name, balance_name) COL02
344: ,to_char(run_val
345: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
346: ,to_char(mtd_val
347: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL17
348: ,to_char(ytd_val
349: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL18

Line 347: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL17

343: ,nvl(reporting_name, balance_name) COL02
344: ,to_char(run_val
345: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
346: ,to_char(mtd_val
347: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL17
348: ,to_char(ytd_val
349: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL18
350: from PAY_MX_OTHER_BALANCES_V
351: where assignment_action_id :action_clause';

Line 349: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL18

345: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
346: ,to_char(mtd_val
347: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL17
348: ,to_char(ytd_val
349: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL18
350: from PAY_MX_OTHER_BALANCES_V
351: where assignment_action_id :action_clause';
352:
353: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');