APPS.PAY_GB_RTI dependencies on FND_NUMBER

Line 2227: fnd_number.number_to_canonical(pact.request_id) request_id,

2223: cursor csr_payroll_details(pactid NUMBER) is
2224: select
2225: nvl(UPPER(hoi.org_information11),' ') sender_id,
2226: decode(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'TEST=') + 5,1) ,'N',' ','Y','1') test_indicator,
2227: fnd_number.number_to_canonical(pact.request_id) request_id,
2228: nvl(upper(substr(ltrim(hoi.org_information3),1,35)),' ') employer_name,
2229: nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' ') tax_ref_no,
2230: lpad(nvl(substr(hoi.org_information1,1,3),' '),3,0) tax_office_no,
2231: decode(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,

Line 2531: fnd_number.number_to_canonical(pact.request_id) request_id,

2527: cursor csr_payroll_details(pactid NUMBER) is
2528: select
2529: nvl(UPPER(hoi.org_information11),' ') sender_id,
2530: decode(substr(pact.legislative_parameters,instr(pact.legislative_parameters,'TEST=') + 5,1) ,'N',' ','Y','1') test_indicator,
2531: fnd_number.number_to_canonical(pact.request_id) request_id,
2532: nvl(upper(substr(ltrim(hoi.org_information3),1,35)),' ') employer_name,
2533: nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' ') tax_ref_no,
2534: lpad(substr(hoi.ORG_INFORMATION1,0,instr(hoi.ORG_INFORMATION1,'/')-1),3,0) tax_office_no,
2535: decode(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,

Line 2578: fnd_number.number_to_canonical(request_id) control_id,

2574: l_form_name varchar2(100);
2575:
2576: cursor csr_leg_param is
2577: select legislative_parameters para,
2578: fnd_number.number_to_canonical(request_id) control_id,
2579: report_type,
2580: business_group_id
2581: from pay_payroll_actions pact
2582: where payroll_action_id = pactid;