DBA Data[Home] [Help]

APPS.PAY_GB_RTI dependencies on PAY_GB_EOY_MAGTAPE

Line 812: l_msg_value := pay_gb_eoy_magtape.validate_tax_code_yrfil(p_assactid,l_tax_code_in_use,l_eff_date); -- Tax code validation

808:
809: l_eff_date := trunc (l_eff_date);
810: hr_utility.trace('l_eff_date = '|| l_eff_date);
811:
812: l_msg_value := pay_gb_eoy_magtape.validate_tax_code_yrfil(p_assactid,l_tax_code_in_use,l_eff_date); -- Tax code validation
813:
814: --Tax code
815:
816: IF (l_tax_code_in_use = ' ' OR l_tax_code_in_use IS NULL) then

Line 2231: decode(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,

2227: fnd_number.number_to_canonical(pact.request_id) request_id,
2228: nvl(upper(substr(ltrim(hoi.org_information3),1,35)),' ') employer_name,
2229: nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' ') tax_ref_no,
2230: lpad(nvl(substr(hoi.org_information1,1,3),' '),3,0) tax_office_no,
2231: decode(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,
2232: nvl(upper(substr(hoi.org_information6,1,13)),' ') acc_ref_no,
2233: report_type
2234: from pay_payroll_actions pact,
2235: hr_organization_information hoi

Line 2535: decode(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,

2531: fnd_number.number_to_canonical(pact.request_id) request_id,
2532: nvl(upper(substr(ltrim(hoi.org_information3),1,35)),' ') employer_name,
2533: nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' ') tax_ref_no,
2534: lpad(substr(hoi.ORG_INFORMATION1,0,instr(hoi.ORG_INFORMATION1,'/')-1),3,0) tax_office_no,
2535: decode(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,
2536: (lpad(substr(hoi.ORG_INFORMATION6,0,instr(hoi.ORG_INFORMATION6,'P')-1),3,0)
2537: || 'P'
2538: || substr(hoi.ORG_INFORMATION6,instr(hoi.ORG_INFORMATION6,'P')+1,1)
2539: || lpad(substr(hoi.ORG_INFORMATION6,instr(hoi.ORG_INFORMATION6,'P')+2,length(hoi.ORG_INFORMATION6)-3-(instr(hoi.ORG_INFORMATION6,'P')-1)),7,0)