DBA Data[Home] [Help]

APPS.PAY_GB_RTI_FPS_VALIDATE dependencies on HR_ORGANIZATION_INFORMATION

Line 97: hr_organization_information hoi

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
100: and hoi.org_information_context = 'Tax Details References'
101: and nvl(hoi.org_information10,'UK') = 'UK'