DBA Data[Home] [Help]

APPS.PAY_GB_RTI_FPS_VALIDATE dependencies on PAY_GB_EOY_ARCHIVE

Line 95: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIN_SUB'),1,20) final_submission

91: lpad(nvl(substr(hoi.org_information1,1,3),' '),3,0) tax_office_no,
92: decode(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,
93: nvl(upper(substr(hoi.org_information6,1,13)),' ') acc_ref_no,
94: hoi.org_information7 econ,
95: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIN_SUB'),1,20) final_submission
96: from pay_payroll_actions pact,
97: hr_organization_information hoi
98: where pact.payroll_action_id=pactid
99: and pact.business_group_id = hoi.organization_id

Line 2354: select pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),

2350: IS
2351:
2352:
2353: cursor csr_parameter_info is
2354: select pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),
2355: /*ppa.effective_date*/
2356: sysdate
2357: from pay_payroll_actions ppa
2358: ,pay_assignment_actions paa