DBA Data[Home] [Help]

APPS.PAY_GB_RTI_FPS_VALIDATE_13 dependencies on PAY_GB_EOY_ARCHIVE

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

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,
83: hr_organization_information hoi
84: where pact.payroll_action_id=pactid
85: and pact.business_group_id = hoi.organization_id

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

2364: IS
2365:
2366:
2367: cursor csr_parameter_info is
2368: select pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),
2369: /*ppa.effective_date*/
2370: sysdate
2371: from pay_payroll_actions ppa
2372: ,pay_assignment_actions paa