DBA Data[Home] [Help]

APPS.PAY_GB_RTI_EYU dependencies on PAY_GB_EOY_MAGTAPE

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

2534: nvl(UPPER(hoi.org_information11),' ') sender_id,
2535: nvl(upper(substr(ltrim(hoi.org_information3),1,35)),' ') employer_name,
2536: nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' ') tax_ref_no,
2537: lpad(nvl(substr(hoi.org_information1,1,3),' '),3,0) tax_office_no,
2538: decode(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,
2539: nvl(upper(substr(hoi.org_information6,1,13)),' ') acc_ref_no,
2540: hoi.org_information7 econ
2541:
2542: from pay_payroll_actions pact,

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

3152: OPEN get_effective_date;
3153: FETCH get_effective_date INTO l_eff_date;
3154: CLOSE get_effective_date;
3155:
3156: l_msg_value := pay_gb_eoy_magtape.validate_tax_code_yrfil(p_assactid,l_tax_code,l_eff_date); -- Tax code validation
3157:
3158: IF (l_tax_code <> ' ' and l_tax_code IS NOT NULL)
3159: AND (l_msg_value <> ' ') THEN
3160: populate_run_msg(p_assactid,'The Tax Code ' || l_tax_code || ' for assignment ' || l_assignment_number||' is invalid.');

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

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,
4615: NVL(upper(SUBSTR(hoi.org_information6,1,13)),' ') acc_ref_no,
4616: report_type
4617: FROM pay_payroll_actions pact,
4618: hr_organization_information hoi

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

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,
5754: (lpad(SUBSTR(hoi.ORG_INFORMATION6,0,instr(hoi.ORG_INFORMATION6,'P')-1),3,0)
5755: || 'P'
5756: || SUBSTR(hoi.ORG_INFORMATION6,instr(hoi.ORG_INFORMATION6,'P') +1,1)
5757: || lpad(SUBSTR(hoi.ORG_INFORMATION6,instr(hoi.ORG_INFORMATION6,'P')+2,LENGTH(hoi.ORG_INFORMATION6)-3-(instr(hoi.ORG_INFORMATION6,'P')-1)),7,0)