DBA Data[Home] [Help]

APPS.PAY_KW_SOE dependencies on FND_CURRENCY

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

425: pay_soe_util.setValue('10',l_output_table(i).source_number,FALSE,FALSE);
426: pay_soe_util.setValue('11',l_output_table(i).source_text2,FALSE,FALSE);
427: pay_soe_util.setValue('15',l_balance_type_lst(l_output_table(i).defined_balance_id).meaning_uom,FALSE,FALSE);
428: pay_soe_util.setValue(16,to_char(l_output_table(i).balance_value,
429: fnd_currency.get_format_mask(substr(l_currency_code,2,3),40)),FALSE,FALSE);
430: pay_soe_util.setValue(17,to_char(l_output_table(i).defined_balance_id),FALSE,TRUE);
431: end if;
432: end loop;
433: end if;

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

585: --
586: l_sql :=
587: 'select nvl(ettl.reporting_name,et.element_type_id) COL01
588: , nvl(ettl.reporting_name,ettl.element_name) || pay_kw_soe.kw_loan_type(rr.assignment_action_id ,rr.run_result_id,:effective_date ) COL02
589: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
590: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
591: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
592: from pay_assignment_actions aa
593: , pay_run_results rr