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 74: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16

70:
71: lv_sql := 'select earn_bal_name COL01
72: ,nvl(earn_reporting_name, earn_bal_name) COL02
73: ,to_char(days_run_val
74: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
75: ,to_char(earn_run_val
76: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL17
77: from PAY_MX_EMPLOYEE_EARNINGS_V
78: where assignment_action_id :action_clause

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

72: ,nvl(earn_reporting_name, earn_bal_name) COL02
73: ,to_char(days_run_val
74: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
75: ,to_char(earn_run_val
76: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL17
77: from PAY_MX_EMPLOYEE_EARNINGS_V
78: where assignment_action_id :action_clause
79: and earn_run_val <> 0';
80:

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

95:
96: lv_sql := 'select balance_name COL01
97: ,nvl(reporting_name, balance_name) COL02
98: ,to_char(run_val
99: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
100: from PAY_MX_EMPLOYEE_TAXES_V
101: where assignment_action_id :action_clause
102: and run_val <> 0';
103:

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

118:
119: lv_sql := 'select balance_name COL01
120: ,nvl(reporting_name, balance_name) COL02
121: ,to_char(run_val
122: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
123: from PAY_MX_TAX_CALC_DETAILS_V
124: where assignment_action_id :action_clause
125: and run_val <> 0';
126:

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

219: ln_bal_value := pay_balance_pkg.get_value(summary(i).curr_def_bal_id
220: ,p_assignment_action_id);
221: summary(i).curr_val :=
222: to_char(ln_bal_value
223: ,fnd_currency.get_format_mask(lv_currency_code,40));
224:
225: -- summary(i).ytd_val :=
226: -- pay_balance_pkg.get_value(summary(i).ytd_def_bal_id
227: -- ,p_assignment_action_id);

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

252:
253: lv_sql := 'select earn_bal_name COL01
254: ,nvl(earn_reporting_name, earn_bal_name) COL02
255: ,to_char(hours_run_val
256: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
257: ,to_char(earn_run_val
258: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL17
259: from PAY_MX_HOURLY_EARNINGS_V
260: where assignment_action_id :action_clause

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

254: ,nvl(earn_reporting_name, earn_bal_name) COL02
255: ,to_char(hours_run_val
256: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
257: ,to_char(earn_run_val
258: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL17
259: from PAY_MX_HOURLY_EARNINGS_V
260: where assignment_action_id :action_clause
261: and earn_run_val <> 0';
262:

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

277:
278: lv_sql := 'select balance_name COL01
279: ,nvl(reporting_name, balance_name) COL02
280: ,to_char(run_val
281: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
282: from PAY_MX_TAXABLE_BENEFITS_V
283: where assignment_action_id :action_clause
284: and run_val <> 0';
285:

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

300:
301: lv_sql := 'select balance_name COL01
302: ,nvl(reporting_name, balance_name) COL02
303: ,to_char(run_val
304: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
305: from PAY_MX_TAX_BALANCES_V
306: where assignment_action_id :action_clause
307: and run_val <> 0';
308:

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

323:
324: lv_sql := 'select balance_name COL01
325: ,nvl(reporting_name, balance_name) COL02
326: ,to_char(run_val
327: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
328: from PAY_MX_DEDUCTIONS_V
329: where assignment_action_id :action_clause
330: and run_val <> 0';
331:

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

346:
347: lv_sql := 'select balance_name COL01
348: ,nvl(reporting_name, balance_name) COL02
349: ,to_char(run_val
350: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
351: ,to_char(mtd_val
352: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL17
353: ,to_char(ytd_val
354: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL18

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

348: ,nvl(reporting_name, balance_name) COL02
349: ,to_char(run_val
350: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
351: ,to_char(mtd_val
352: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL17
353: ,to_char(ytd_val
354: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL18
355: from PAY_MX_OTHER_BALANCES_V
356: where assignment_action_id :action_clause';

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

350: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
351: ,to_char(mtd_val
352: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL17
353: ,to_char(ytd_val
354: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL18
355: from PAY_MX_OTHER_BALANCES_V
356: where assignment_action_id :action_clause';
357:
358: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');