APPS.PAY_GB_RTI_FPS dependencies on FND_NUMBER

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

7301: CURSOR csr_payroll_details(pactid NUMBER)
7302: IS
7303: SELECT NVL(UPPER(hoi.org_information11),' ') sender_id,
7304: DECODE(SUBSTR(pact.legislative_parameters,instr(pact.legislative_parameters,'TEST=') + 5,1) ,'N',' ','Y','1') test_indicator,
7305: fnd_number.number_to_canonical(pact.request_id) request_id,
7306: NVL(upper(SUBSTR(ltrim(hoi.org_information3),1,35)),' ') employer_name,
7307: NVL(upper(SUBSTR(ltrim(SUBSTR(hoi.org_information1,4,11),'/'),1,10)),' ') tax_ref_no,
7308: lpad(NVL(SUBSTR(hoi.org_information1,1,3),' '),3,0) tax_office_no,
7309: DECODE(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,

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

12358: CURSOR csr_payroll_details(pactid NUMBER)
12359: IS
12360: SELECT NVL(UPPER(hoi.org_information11),' ') sender_id,
12361: DECODE(SUBSTR(pact.legislative_parameters,instr(pact.legislative_parameters,'TEST=') + 5,1) ,'N',' ','Y','1') test_indicator,
12362: fnd_number.number_to_canonical(pact.request_id) request_id,
12363: NVL(upper(SUBSTR(ltrim(hoi.org_information3),1,35)),' ') employer_name,
12364: NVL(upper(SUBSTR(ltrim(SUBSTR(hoi.org_information1,4,11),'/'),1,10)),' ') tax_ref_no,
12365: lpad(SUBSTR(hoi.ORG_INFORMATION1,0,instr(hoi.ORG_INFORMATION1,'/')-1),3,0) tax_office_no,
12366: DECODE(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,

Line 12437: fnd_number.number_to_canonical(request_id) control_id,

12433:
12434: CURSOR csr_leg_param
12435: IS
12436: SELECT legislative_parameters para,
12437: fnd_number.number_to_canonical(request_id) control_id,
12438: report_type,
12439: business_group_id
12440: FROM pay_payroll_actions pact
12441: WHERE payroll_action_id = pactid;