DBA Data[Home] [Help]

APPS.PAY_GB_RTI_EYU dependencies on FND_NUMBER

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

4606: CURSOR csr_payroll_details(pactid NUMBER)
4607: IS
4608: SELECT NVL(UPPER(hoi.org_information11),' ') sender_id,
4609: DECODE(SUBSTR(pact.legislative_parameters,instr(pact.legislative_parameters,'TEST=') + 5,1) ,'N',' ','Y','1') test_indicator,
4610: fnd_number.number_to_canonical(pact.request_id) request_id,
4611: NVL(upper(SUBSTR(ltrim(hoi.org_information3),1,35)),' ') employer_name,
4612: NVL(upper(SUBSTR(ltrim(SUBSTR(hoi.org_information1,4,11),'/'),1,10)),' ') tax_ref_no,
4613: lpad(NVL(SUBSTR(hoi.org_information1,1,3),' '),3,0) tax_office_no,
4614: DECODE(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,

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

5745: CURSOR csr_payroll_details(pactid NUMBER)
5746: IS
5747: SELECT NVL(UPPER(hoi.org_information11),' ') sender_id,
5748: DECODE(SUBSTR(pact.legislative_parameters,instr(pact.legislative_parameters,'TEST=') + 5,1) ,'N',' ','Y','1') test_indicator,
5749: fnd_number.number_to_canonical(pact.request_id) request_id,
5750: NVL(upper(SUBSTR(ltrim(hoi.org_information3),1,35)),' ') employer_name,
5751: NVL(upper(SUBSTR(ltrim(SUBSTR(hoi.org_information1,4,11),'/'),1,10)),' ') tax_ref_no,
5752: lpad(SUBSTR(hoi.ORG_INFORMATION1,0,instr(hoi.ORG_INFORMATION1,'/')-1),3,0) tax_office_no,
5753: DECODE(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,

Line 5801: fnd_number.number_to_canonical(request_id) control_id,

5797:
5798: CURSOR csr_leg_param
5799: IS
5800: SELECT legislative_parameters para,
5801: fnd_number.number_to_canonical(request_id) control_id,
5802: report_type,
5803: business_group_id
5804: FROM pay_payroll_actions pact
5805: WHERE payroll_action_id = pactid;