DBA Data[Home] [Help]

APPS.PAY_GB_RTI_FPS_VALIDATE_13 dependencies on PAY_GB_EOY_MAGTAPE

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

74: hoi.organization_id orgid,
75: nvl(upper(substr(ltrim(hoi.org_information3),1,35)),' ') employer_name,
76: nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' ') tax_ref_no,
77: lpad(nvl(substr(hoi.org_information1,1,3),' '),3,0) tax_office_no,
78: decode(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,
79: nvl(upper(substr(hoi.org_information6,1,13)),' ') acc_ref_no,
80: hoi.org_information7 econ,
81: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIN_SUB'),1,20) final_submission
82: from pay_payroll_actions pact,

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

1282: OPEN get_effective_date;
1283: FETCH get_effective_date INTO l_eff_date;
1284: CLOSE get_effective_date;
1285:
1286: l_msg_value := pay_gb_eoy_magtape.validate_tax_code_yrfil(p_assactid,l_tax_code,l_eff_date); -- Tax code validation
1287:
1288: IF (l_tax_code <> ' ' and l_tax_code IS NOT NULL)
1289: AND (l_msg_value <> ' ') THEN
1290: populate_run_msg(p_assactid,'The Tax Code ' || l_tax_code || ' for assignment ' || l_assignment_number||' is invalid.');

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

1817: OPEN get_effective_date;
1818: FETCH get_effective_date INTO l_eff_date;
1819: CLOSE get_effective_date;
1820:
1821: l_msg_value := pay_gb_eoy_magtape.validate_tax_code_yrfil(p_assactid,l_tax_code,l_eff_date); -- Tax code validation
1822:
1823: IF (l_tax_code <> ' ' and l_tax_code IS NOT NULL)
1824: AND (l_msg_value <> ' ') THEN
1825: populate_run_msg(p_assactid,'The Tax Code ' || l_tax_code || ' for assignment ' || l_assignment_number||' is invalid.');