DBA Data[Home] [Help]

APPS.JA_CN_PS_HRMS_EXPORT_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 291: FROM hr_organization_information info

287: AND pos.primary_structure_flag='Y'
288: AND pos.organization_structure_id = posv.organization_structure_id
289: AND pose.organization_id_child = pn_organization_id
290: AND EXISTS (SELECT 1
291: FROM hr_organization_information info
292: WHERE info.org_information1 = 'HR_ORG'
293: AND info.org_information_context = 'CLASS'
294: AND info.organization_id = pose.organization_id_parent
295: AND info.org_information2 = 'Y'

Line 519: FROM hr_organization_information info

515: AND org.business_group_id = fnd_profile.VALUE('PER_BUSINESS_GROUP_ID')
516: AND date_from <= ld_acc_end_date
517: AND nvl( date_to, ld_acc_end_date) >= ld_acc_start_date
518: AND EXISTS (SELECT 1
519: FROM hr_organization_information info
520: WHERE info.org_information1 = 'HR_ORG'
521: AND info.org_information_context = 'CLASS'
522: AND info.organization_id = org.organization_id
523: AND info.org_information2 = 'Y'