DBA Data[Home] [Help]

APPS.PAY_GB_RTI_FPS_VALIDATE_13 dependencies on HR_ORGANIZATION_INFORMATION

Line 83: hr_organization_information hoi

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

Line 97: from hr_organization_information hoi

93: cursor csr_payroll_details_2(paye_ref VARCHAR2,orgid number) is
94: select
95: hoi.org_information2 sautr,
96: hoi.org_information3 cotaxref
97: from hr_organization_information hoi
98: where hoi.organization_id = orgid
99: and hoi.org_information_context = 'Tax Details References Cont'
100: and hoi.org_information1 = paye_ref;
101: