DBA Data[Home] [Help]

APPS.PAY_SOE_GLB dependencies on FND_CURRENCY

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

426: --
427: l_sql :=
428: 'select /*+ ORDERED */ nvl(ettl.reporting_name,et.element_type_id) COL01
429: , nvl(ettl.reporting_name,ettl.element_name) COL02
430: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
431: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
432: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
433: from pay_assignment_actions aa
434: , pay_run_results rr

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

782: pay_soe_util.setValue('10',l_output_table(i).source_number,FALSE,FALSE);
783: pay_soe_util.setValue('11',l_output_table(i).source_text2,FALSE,FALSE);
784:
785: pay_soe_util.setValue(16,to_char(l_output_table(i).balance_value,
786: fnd_currency.get_format_mask(substr(g_currency_code,2,3),40)),FALSE,FALSE);
787: pay_soe_util.setValue(17,to_char(l_output_table(i).defined_balance_id),FALSE,TRUE);
788:
789: end if;
790: end loop;

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

896: ,pay_soe_util.getBankDetails('':legislation_code''
897: ,ppm.external_account_id
898: ,''BANK_ACCOUNT_NUMBER''
899: ,fnd_profile.value(''HR_MASK_CHARACTERS'')) COL03
900: ,to_char(pp.value,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
901: from pay_pre_payments pp
902: , pay_personal_payment_methods_f ppm
903: , pay_org_payment_methods_f opm
904: , pay_payment_types_tl pt