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

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

437: else
438: --
439: l_sql := 'select /*+ ORDERED */ nvl(ettl.reporting_name,et.element_type_id) COL01
440: , nvl(orginfo.org_information7,nvl(ettl.reporting_name, ettl.element_name)) COL02
441: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
442: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator,
443: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
444: from pay_assignment_actions aa
445: , pay_run_results rr

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

485: ,nvl(ettl.reporting_name,et.element_type_id)
486: UNION ALL
487: select /*+ ORDERED */ nvl(ettl.reporting_name,et.element_type_id) COL01
488: , nvl(ettl.reporting_name,ettl.element_name) COL02
489: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
490: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator,
491: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
492: from pay_assignment_actions aa
493: , pay_run_results rr

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

852: pay_soe_util.setValue('10',l_output_table(i).source_number,FALSE,FALSE);
853: pay_soe_util.setValue('11',l_output_table(i).source_text2,FALSE,FALSE);
854:
855: pay_soe_util.setValue(16,to_char(l_output_table(i).balance_value,
856: fnd_currency.get_format_mask(substr(g_currency_code,2,3),40)),FALSE,FALSE);
857: pay_soe_util.setValue(17,to_char(l_output_table(i).defined_balance_id),FALSE,TRUE);
858:
859: end if;
860: end loop;

Line 975: ,to_char(pp.value,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16

971: ,pay_soe_util.getBankDetails('':legislation_code''
972: ,ppm.external_account_id
973: ,''BANK_ACCOUNT_NUMBER''
974: ,fnd_profile.value(''HR_MASK_CHARACTERS'')) COL03
975: ,to_char(pp.value,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
976: from pay_pre_payments pp
977: , pay_personal_payment_methods_f ppm
978: , pay_org_payment_methods_f opm
979: , pay_payment_types_tl pt