DBA Data[Home] [Help]

APPS.JA_CN_HRMS_EXPORT_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 207: FROM hr_organization_information info

203: AND POS.primary_structure_flag='Y'
204: AND POS.organization_structure_id = POSV.organization_structure_id
205: AND POSE.organization_id_child = p_organization_id
206: AND EXISTS (SELECT 1
207: FROM hr_organization_information info
208: WHERE info.org_information1 = 'HR_ORG'
209: AND info.org_information_context = 'CLASS'
210: AND info.organization_id = POSE.organization_id_parent
211: AND info.org_information2 = 'Y');

Line 289: FROM hr_organization_information info

285: AND date_from <= pd_acc_end_date
286: AND nvl(date_to,
287: pd_acc_end_date) >= pd_acc_start_date
288: AND EXISTS (SELECT 1
289: FROM hr_organization_information info
290: WHERE info.org_information1 = 'HR_ORG'
291: AND info.org_information_context = 'CLASS'
292: AND info.organization_id = org.organization_id
293: AND info.org_information2 = 'Y');