DBA Data[Home] [Help]

APPS.PAY_ES_ONLINE_SOE dependencies on FND_CURRENCY

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

377: pay_soe_util.setValue('10',l_output_table(i).source_number,FALSE,FALSE);
378: pay_soe_util.setValue('11',l_output_table(i).source_text2,FALSE,FALSE);
379: pay_soe_util.setValue('15',l_balance_type_lst(l_output_table(i).defined_balance_id).meaning_uom,FALSE,FALSE);
380: pay_soe_util.setValue(16,to_char(l_output_table(i).balance_value,
381: fnd_currency.get_format_mask(substr(l_currency_code,2,3),40)),FALSE,FALSE);
382: pay_soe_util.setValue(17,to_char(l_output_table(i).defined_balance_id),FALSE,TRUE);
383: end if;
384: end loop;
385: end if;

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

537: decode(et.element_name,''Other Court Order Deductions'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Court Order Type'',''ES_OTHER_COURT_ORDER_TYPE'')
538: ,''Company Loan Detail'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Purpose'',''ES_LOAN_PURPOSE'')
539: ,''Company Loan'',pay_es_online_soe.Get_Input_Value(et.element_type_id,rr.run_result_id,:effective_date,''Purpose'',''ES_LOAN_PURPOSE'')
540: , '' '') COL02
541: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
542: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
543: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
544: from pay_assignment_actions aa
545: , pay_run_results rr