DBA Data[Home] [Help]

APPS.PAY_GB_RTI_FPS dependencies on PAY_GB_EOY_MAGTAPE

Line 7309: DECODE(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,

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,
7310: NVL(upper(SUBSTR(hoi.org_information6,1,13)),' ') acc_ref_no,
7311: report_type
7312: FROM pay_payroll_actions pact,
7313: hr_organization_information hoi

Line 12366: DECODE(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,

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,
12367: (lpad(SUBSTR(hoi.ORG_INFORMATION6,0,instr(hoi.ORG_INFORMATION6,'P')-1),3,0)
12368: || 'P'
12369: || SUBSTR(hoi.ORG_INFORMATION6,instr(hoi.ORG_INFORMATION6,'P') +1,1)
12370: || lpad(SUBSTR(hoi.ORG_INFORMATION6,instr(hoi.ORG_INFORMATION6,'P')+2,LENGTH(hoi.ORG_INFORMATION6)-3-(instr(hoi.ORG_INFORMATION6,'P')-1)),7,0)