DBA Data[Home] [Help]

APPS.PAY_GB_MOVDED_EDI dependencies on FND_NUMBER

Line 672: fnd_number.canonical_to_number(result_value),NULL))) pay_previous,

668: cursor csr_run_result(l_run_result_id number,l_element_type_id number) is
669: select max(decode(name,'Tax Code',result_value,NULL)) tax_code,
670: max(decode(name,'Tax Basis',result_value,NULL)) tax_basis,
671: to_number(max(decode(name,'Pay Previous',
672: fnd_number.canonical_to_number(result_value),NULL))) pay_previous,
673: to_number(max(decode(name,'Tax Previous',
674: fnd_number.canonical_to_number(result_value),NULL))) tax_previous
675: from pay_input_values_f v,
676: pay_run_result_values rrv

Line 674: fnd_number.canonical_to_number(result_value),NULL))) tax_previous

670: max(decode(name,'Tax Basis',result_value,NULL)) tax_basis,
671: to_number(max(decode(name,'Pay Previous',
672: fnd_number.canonical_to_number(result_value),NULL))) pay_previous,
673: to_number(max(decode(name,'Tax Previous',
674: fnd_number.canonical_to_number(result_value),NULL))) tax_previous
675: from pay_input_values_f v,
676: pay_run_result_values rrv
677: where rrv.run_result_id = l_run_result_id
678: and v.input_value_id = rrv.input_value_id

Line 1784: fnd_number.number_to_canonical(request_id) control_id,

1780: l_temp number;
1781:
1782: cursor csr_leg_param is
1783: select legislative_parameters para,
1784: fnd_number.number_to_canonical(request_id) control_id,
1785: report_type,
1786: business_group_id
1787: from pay_payroll_actions
1788: where payroll_action_id = pactid;