DBA Data[Home] [Help]

APPS.PAY_GB_RTI_P60 dependencies on PAY_GB_EOY_MAGTAPE

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

3648: fnd_number.number_to_canonical(pact.request_id) request_id,
3649: NVL(upper(SUBSTR(ltrim(hoi.org_information3),1,35)),' ') employer_name,
3650: NVL(upper(SUBSTR(ltrim(SUBSTR(hoi.org_information1,4,11),'/'),1,10)),' ') tax_ref_no,
3651: lpad(NVL(SUBSTR(hoi.org_information1,1,3),' '),3,0) tax_office_no,
3652: DECODE(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,
3653: NVL(upper(SUBSTR(hoi.org_information6,1,13)),' ') acc_ref_no,
3654: report_type
3655: FROM pay_payroll_actions pact,
3656: hr_organization_information hoi

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

4485: fnd_number.number_to_canonical(pact.request_id) request_id,
4486: NVL(upper(SUBSTR(ltrim(hoi.org_information3),1,35)),' ') employer_name,
4487: NVL(upper(SUBSTR(ltrim(SUBSTR(hoi.org_information1,4,11),'/'),1,10)),' ') tax_ref_no,
4488: lpad(SUBSTR(hoi.ORG_INFORMATION1,0,instr(hoi.ORG_INFORMATION1,'/')-1),3,0) tax_office_no,
4489: DECODE(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,
4490: (lpad(SUBSTR(hoi.ORG_INFORMATION6,0,instr(hoi.ORG_INFORMATION6,'P')-1),3,0)
4491: || 'P'
4492: || SUBSTR(hoi.ORG_INFORMATION6,instr(hoi.ORG_INFORMATION6,'P') +1,1)
4493: || lpad(SUBSTR(hoi.ORG_INFORMATION6,instr(hoi.ORG_INFORMATION6,'P')+2,LENGTH(hoi.ORG_INFORMATION6)-3-(instr(hoi.ORG_INFORMATION6,'P')-1)),7,0)