DBA Data[Home] [Help]

APPS.PAY_DK_SOE dependencies on FND_NUMBER

Line 375: and hou.organization_id = FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)

371: and rrv.input_value_id = iv.input_value_id
372: and iv.name = 'Third Party Payee'
373: and p_effective_date between
374: iv.effective_start_date and iv.effective_end_date
375: and hou.organization_id = FND_NUMBER.CANONICAL_TO_NUMBER(rrv.result_value)
376: and p_effective_date between hou.date_from and nvl(hou.date_to, p_effective_date);
377:
378: rec_get_pp_name csr_get_pp_name%rowtype;
379:

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