APPS.PAY_GB_RTI_FPS_ARCHIVE dependencies on FND_NUMBER

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

7930: CURSOR csr_payroll_details(pactid NUMBER)
7931: IS
7932: SELECT NVL(UPPER(hoi.org_information11),' ') sender_id,
7933: DECODE(SUBSTR(pact.legislative_parameters,instr(pact.legislative_parameters,'TEST=') + 5,1) ,'N',' ','Y','1') test_indicator,
7934: fnd_number.number_to_canonical(pact.request_id) request_id,
7935: NVL(upper(SUBSTR(ltrim(hoi.org_information3),1,35)),' ') employer_name,
7936: NVL(upper(SUBSTR(ltrim(SUBSTR(hoi.org_information1,4,11),'/'),1,10)),' ') tax_ref_no,
7937: lpad(NVL(SUBSTR(hoi.org_information1,1,3),' '),3,0) tax_office_no,
7938: DECODE(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,

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

13101: SELECT NVL(UPPER(hoi.org_information11),' ') sender_id,
13102: hoi.org_information1 paye_ref,
13103: hoi.organization_id orgid,
13104: DECODE(SUBSTR(pact.legislative_parameters,instr(pact.legislative_parameters,'TEST=') + 5,1) ,'N',' ','Y','1') test_indicator,
13105: fnd_number.number_to_canonical(pact.request_id) request_id,
13106: NVL(upper(SUBSTR(ltrim(hoi.org_information3),1,35)),' ') employer_name,
13107: NVL(upper(SUBSTR(ltrim(SUBSTR(hoi.org_information1,4,11),'/'),1,10)),' ') tax_ref_no,
13108: lpad(SUBSTR(hoi.ORG_INFORMATION1,0,instr(hoi.ORG_INFORMATION1,'/')-1),3,0) tax_office_no,
13109: DECODE(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,

Line 13192: fnd_number.number_to_canonical(request_id) control_id,

13188:
13189: CURSOR csr_leg_param
13190: IS
13191: SELECT legislative_parameters para,
13192: fnd_number.number_to_canonical(request_id) control_id,
13193: report_type,
13194: business_group_id
13195: FROM pay_payroll_actions pact
13196: WHERE payroll_action_id = pactid;