DBA Data[Home] [Help]

APPS.PAY_GB_MOVDED_EDI dependencies on FND_NUMBER

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

858: cursor csr_run_result(l_run_result_id number,l_element_type_id number) is
859: select max(decode(name,'Tax Code',result_value,NULL)) tax_code,
860: max(decode(name,'Tax Basis',result_value,NULL)) tax_basis,
861: to_number(max(decode(name,'Pay Previous',
862: fnd_number.canonical_to_number(result_value),NULL))) pay_previous,
863: to_number(max(decode(name,'Tax Previous',
864: fnd_number.canonical_to_number(result_value),NULL))) tax_previous
865: from pay_input_values_f v,
866: pay_run_result_values rrv

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

860: max(decode(name,'Tax Basis',result_value,NULL)) tax_basis,
861: to_number(max(decode(name,'Pay Previous',
862: fnd_number.canonical_to_number(result_value),NULL))) pay_previous,
863: to_number(max(decode(name,'Tax Previous',
864: fnd_number.canonical_to_number(result_value),NULL))) tax_previous
865: from pay_input_values_f v,
866: pay_run_result_values rrv
867: where rrv.run_result_id = l_run_result_id
868: and v.input_value_id = rrv.input_value_id

Line 3040: fnd_number.number_to_canonical(request_id) control_id,

3036: l_temp number;
3037:
3038: cursor csr_leg_param is
3039: select legislative_parameters para,
3040: fnd_number.number_to_canonical(request_id) control_id,
3041: report_type,
3042: business_group_id
3043: from pay_payroll_actions
3044: where payroll_action_id = pactid;