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

Line 255: 'SELECT TO_CHAR('||l_sp_percentage_rate|| ',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16 '||

251: l_defbal_id := PAY_NL_GENERAL.GET_DEFINED_BALANCE_ID('NET_EMPLOYEE_SI_CONTRIBUTION_ASG_SIT_PTD');
252: l_ZVW_Contribution := l_ZVW_Contribution + NVL(pay_balance_pkg.get_value(l_defbal_id, p_assignment_action_id, null, null, l_context_id, 'ZVW', null, null ),0);
253:
254: l_sql :=
255: 'SELECT TO_CHAR('||l_sp_percentage_rate|| ',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16 '||
256: ',TO_CHAR('||l_prev_tax_income||',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL17 '||
257: ','''||l_Tax_Code||''' COL01 '||
258: ',REPLACE('''||l_Tax_Table||''',''||fnd_global.local_chr(39)'',fnd_global.local_chr(39)) COL02 '||
259: ',REPLACE('''||l_Tax_Reduction||''',''||fnd_global.local_chr(39)'',fnd_global.local_chr(39)) COL03 '||

Line 256: ',TO_CHAR('||l_prev_tax_income||',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL17 '||

252: l_ZVW_Contribution := l_ZVW_Contribution + NVL(pay_balance_pkg.get_value(l_defbal_id, p_assignment_action_id, null, null, l_context_id, 'ZVW', null, null ),0);
253:
254: l_sql :=
255: 'SELECT TO_CHAR('||l_sp_percentage_rate|| ',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16 '||
256: ',TO_CHAR('||l_prev_tax_income||',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL17 '||
257: ','''||l_Tax_Code||''' COL01 '||
258: ',REPLACE('''||l_Tax_Table||''',''||fnd_global.local_chr(39)'',fnd_global.local_chr(39)) COL02 '||
259: ',REPLACE('''||l_Tax_Reduction||''',''||fnd_global.local_chr(39)'',fnd_global.local_chr(39)) COL03 '||
260: ',REPLACE('''||l_Labour_Tax_Reduction||''',''||fnd_global.local_chr(39)'',fnd_global.local_chr(39)) COL07 '||

Line 263: ',TO_CHAR('''||TO_CHAR(l_Travel_Allowance)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL18 '

259: ',REPLACE('''||l_Tax_Reduction||''',''||fnd_global.local_chr(39)'',fnd_global.local_chr(39)) COL03 '||
260: ',REPLACE('''||l_Labour_Tax_Reduction||''',''||fnd_global.local_chr(39)'',fnd_global.local_chr(39)) COL07 '||
261: ',REPLACE('''||l_Senior_Tax_Reduction||''',''||fnd_global.local_chr(39)'',fnd_global.local_chr(39)) COL05 '||
262: ','''||l_Special_Indicators||''' COL06 ' ||
263: ',TO_CHAR('''||TO_CHAR(l_Travel_Allowance)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL18 '
264: ||',TO_CHAR('''||TO_CHAR(l_Sea_Days_Discount)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL19 '
265: ||',TO_CHAR('''||TO_CHAR(l_ABW_Allowance)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL20 '
266: ||',TO_CHAR('''||TO_CHAR(l_ABW_Allowance_Stoppage)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL21 '
267: ||',TO_CHAR('''||TO_CHAR(l_WAO_Allowance)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL22 '

Line 264: ||',TO_CHAR('''||TO_CHAR(l_Sea_Days_Discount)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL19 '

260: ',REPLACE('''||l_Labour_Tax_Reduction||''',''||fnd_global.local_chr(39)'',fnd_global.local_chr(39)) COL07 '||
261: ',REPLACE('''||l_Senior_Tax_Reduction||''',''||fnd_global.local_chr(39)'',fnd_global.local_chr(39)) COL05 '||
262: ','''||l_Special_Indicators||''' COL06 ' ||
263: ',TO_CHAR('''||TO_CHAR(l_Travel_Allowance)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL18 '
264: ||',TO_CHAR('''||TO_CHAR(l_Sea_Days_Discount)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL19 '
265: ||',TO_CHAR('''||TO_CHAR(l_ABW_Allowance)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL20 '
266: ||',TO_CHAR('''||TO_CHAR(l_ABW_Allowance_Stoppage)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL21 '
267: ||',TO_CHAR('''||TO_CHAR(l_WAO_Allowance)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL22 '
268: ||',TO_CHAR('''||TO_CHAR(l_ZVW_Contribution)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL23 '||

Line 265: ||',TO_CHAR('''||TO_CHAR(l_ABW_Allowance)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL20 '

261: ',REPLACE('''||l_Senior_Tax_Reduction||''',''||fnd_global.local_chr(39)'',fnd_global.local_chr(39)) COL05 '||
262: ','''||l_Special_Indicators||''' COL06 ' ||
263: ',TO_CHAR('''||TO_CHAR(l_Travel_Allowance)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL18 '
264: ||',TO_CHAR('''||TO_CHAR(l_Sea_Days_Discount)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL19 '
265: ||',TO_CHAR('''||TO_CHAR(l_ABW_Allowance)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL20 '
266: ||',TO_CHAR('''||TO_CHAR(l_ABW_Allowance_Stoppage)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL21 '
267: ||',TO_CHAR('''||TO_CHAR(l_WAO_Allowance)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL22 '
268: ||',TO_CHAR('''||TO_CHAR(l_ZVW_Contribution)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL23 '||
269: 'FROM dual';

Line 266: ||',TO_CHAR('''||TO_CHAR(l_ABW_Allowance_Stoppage)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL21 '

262: ','''||l_Special_Indicators||''' COL06 ' ||
263: ',TO_CHAR('''||TO_CHAR(l_Travel_Allowance)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL18 '
264: ||',TO_CHAR('''||TO_CHAR(l_Sea_Days_Discount)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL19 '
265: ||',TO_CHAR('''||TO_CHAR(l_ABW_Allowance)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL20 '
266: ||',TO_CHAR('''||TO_CHAR(l_ABW_Allowance_Stoppage)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL21 '
267: ||',TO_CHAR('''||TO_CHAR(l_WAO_Allowance)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL22 '
268: ||',TO_CHAR('''||TO_CHAR(l_ZVW_Contribution)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL23 '||
269: 'FROM dual';
270: --

Line 267: ||',TO_CHAR('''||TO_CHAR(l_WAO_Allowance)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL22 '

263: ',TO_CHAR('''||TO_CHAR(l_Travel_Allowance)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL18 '
264: ||',TO_CHAR('''||TO_CHAR(l_Sea_Days_Discount)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL19 '
265: ||',TO_CHAR('''||TO_CHAR(l_ABW_Allowance)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL20 '
266: ||',TO_CHAR('''||TO_CHAR(l_ABW_Allowance_Stoppage)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL21 '
267: ||',TO_CHAR('''||TO_CHAR(l_WAO_Allowance)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL22 '
268: ||',TO_CHAR('''||TO_CHAR(l_ZVW_Contribution)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL23 '||
269: 'FROM dual';
270: --
271: RETURN l_sql;

Line 268: ||',TO_CHAR('''||TO_CHAR(l_ZVW_Contribution)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL23 '||

264: ||',TO_CHAR('''||TO_CHAR(l_Sea_Days_Discount)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL19 '
265: ||',TO_CHAR('''||TO_CHAR(l_ABW_Allowance)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL20 '
266: ||',TO_CHAR('''||TO_CHAR(l_ABW_Allowance_Stoppage)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL21 '
267: ||',TO_CHAR('''||TO_CHAR(l_WAO_Allowance)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL22 '
268: ||',TO_CHAR('''||TO_CHAR(l_ZVW_Contribution)||''',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL23 '||
269: 'FROM dual';
270: --
271: RETURN l_sql;
272: --

Line 299: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16

295: , decode(pay_nl_general.get_iv_run_result(rr.run_result_id,et.element_type_id,''SI Type Name''),null,'' '',
296: '' and pay_nl_general.get_iv_run_result('' || max(rr.run_result_id) || '','' || max(et.element_type_id)
297: || '','' || ''''''SI Type Name'''''' || '') ='' || ''pay_nl_general.get_iv_run_result(run_result_id,element_type_id,''
298: || ''''''SI Type Name'''''' || '')'') COL04
299: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
300: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
301: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
302: from pay_assignment_actions aa
303: , pay_run_results rr

Line 714: fnd_currency.get_format_mask(substr(PAY_SOE_GLB.g_currency_code,2,3),40)),FALSE,FALSE);

710: /* end Bug 4253982 */
711: END IF;
712: pay_soe_util.setValue('12',l_si_type_name,FALSE,FALSE);
713: pay_soe_util.setValue(16,to_char(l_output_table(i).balance_value,
714: fnd_currency.get_format_mask(substr(PAY_SOE_GLB.g_currency_code,2,3),40)),FALSE,FALSE);
715: pay_soe_util.setValue(17,to_char(l_output_table(i).defined_balance_id),FALSE,TRUE);
716:
717: end if;
718: end loop;