DBA Data[Home] [Help]

APPS.PAY_DK_SOE dependencies on FND_CURRENCY

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

323: ,pay_soe_util.getBankDetails('':legislation_code''
324: ,ppm.external_account_id
325: ,''BANK_ACCOUNT_NUMBER''
326: ,fnd_profile.value(''HR_MASK_CHARACTERS'')) COL03
327: ,to_char(pp.value,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
328: ,nvl(pay_dk_soe.get_bank_reg_number(ppm.external_account_id), '''') COL05
329: from pay_pre_payments pp
330: , pay_personal_payment_methods_f ppm
331: , pay_org_payment_methods_f opm

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

410: ,''Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,max(rr.run_result_id))||'' )''
411: ,''Employer Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,max(rr.run_result_id))||'' )''
412: ,''Retro Pension'', '' ( ''||pay_dk_soe.get_pp_name(:effective_date,max(rr.run_result_id))||'' )''
413: ,''Retro Employer Pension'','' ( ''||pay_dk_soe.get_pp_name(:effective_date,max(rr.run_result_id))||'' )'') COL02
414: , to_char(sum(FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
415: , decode(count(*),1,''1'',''2'') COL17 -- destination indicator
416: , decode(count(*),1,max(rr.run_result_id),max(et.element_type_id)) COL18
417: from pay_assignment_actions aa
418: , pay_run_results rr

Line 874: fnd_currency.get_format_mask(substr(rec_get_params.currency_code,2,3),40)),FALSE,FALSE);

870: pay_soe_util.setValue('12',l_output_table(i).organization_id,FALSE,FALSE);
871: pay_soe_util.setValue('13',l_org_name,FALSE,FALSE);
872:
873: pay_soe_util.setValue(16,to_char(l_output_table(i).balance_value,
874: fnd_currency.get_format_mask(substr(rec_get_params.currency_code,2,3),40)),FALSE,FALSE);
875: pay_soe_util.setValue(17,to_char(l_output_table(i).defined_balance_id),FALSE,TRUE);
876:
877: end if;
878: end loop;