DBA Data[Home] [Help]

APPS.PAY_GENERIC_UPGRADE dependencies on HR_ORGANIZATION_INFORMATION

Line 216: from hr_organization_information hoi_1 , --'not exists' validation being done against the base table itself.

212: where legislation_code = p_legislation
213: and business_group_id <> p_business_group
214: )
215: and not exists (select 1 --Bug 7296843
216: from hr_organization_information hoi_1 , --'not exists' validation being done against the base table itself.
217: hr_organization_information hoi_2
218: where hoi_1.organization_id <> p_business_group
219: and hoi_1.organization_id = hoi_2.organization_id
220: and hoi_1.org_information9 = p_legislation

Line 217: hr_organization_information hoi_2

213: and business_group_id <> p_business_group
214: )
215: and not exists (select 1 --Bug 7296843
216: from hr_organization_information hoi_1 , --'not exists' validation being done against the base table itself.
217: hr_organization_information hoi_2
218: where hoi_1.organization_id <> p_business_group
219: and hoi_1.organization_id = hoi_2.organization_id
220: and hoi_1.org_information9 = p_legislation
221: and hoi_2.org_information_context ='CLASS'