DBA Data[Home] [Help]

APPS.PAY_AE_SOE dependencies on FND_CURRENCY

Line 439: fnd_currency.get_format_mask(substr(l_currency_code,2,3),40)),FALSE,FALSE);

435: pay_soe_util.setValue('10',l_output_table(i).source_number,FALSE,FALSE);
436: pay_soe_util.setValue('11',l_output_table(i).source_text2,FALSE,FALSE);
437: pay_soe_util.setValue('15',l_balance_type_lst(l_output_table(i).defined_balance_id).meaning_uom,FALSE,FALSE);
438: pay_soe_util.setValue(16,to_char(l_output_table(i).balance_value,
439: fnd_currency.get_format_mask(substr(l_currency_code,2,3),40)),FALSE,FALSE);
440: pay_soe_util.setValue(17,to_char(l_output_table(i).defined_balance_id),FALSE,TRUE);
441: end if;
442: end loop;
443: end if;

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

601: --
602: l_sql :=
603: 'select nvl(ettl.reporting_name,et.element_type_id) COL01
604: , nvl(ettl.reporting_name,ettl.element_name) || pay_ae_soe.ae_loan_type(rr.assignment_action_id ,rr.run_result_id,:effective_date ) COL02
605: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
606: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
607: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
608: from pay_assignment_actions aa
609: , pay_run_results rr