APPS.HR_HEAD_COUNT_SUMMARY dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 126: from per_org_structure_versions posv

122: is
123: select distinct pose.ORGANIZATION_ID_CHILD organization_id
124: from per_org_structure_elements pose
125: where exists (select 1
126: from per_org_structure_versions posv
127: where posv.org_structure_version_id = pose.org_structure_version_id
128: and posv.organization_structure_id = P_ORGANIZATION_STRUCTURE_ID
129: and (posv.date_from <= P_REPORT_DATE_FROM
130: or nvl(posv.date_to,to_date('31/12/4712','DD/MM/YYYY'))

Line 146: from per_org_structure_versions posv

142: is
143: select posv.org_structure_version_id
144: ,posv.date_from date_from
145: ,nvl(posv.date_to,to_date('31/12/4712','DD/MM/YYYY')) date_to
146: from per_org_structure_versions posv
147: where posv.organization_structure_id = P_ORGANIZATION_STRUCTURE_ID
148: and (P_REPORT_DATE_FROM between posv.date_from and
149: nvl(posv.date_to,to_date('31/12/4712','DD/MM/YYYY'))
150: or posv.date_from between P_REPORT_DATE_FROM and P_REPORT_DATE_TO)

Line 425: from per_org_structure_versions posv

421: begin
422:
423: select min(posv.org_structure_version_id)
424: into l_min_org_structure_version_id
425: from per_org_structure_versions posv
426: where posv.organization_structure_id = P_ORGANIZATION_STRUCTURE_ID
427: and P_REPORT_DATE_FROM between posv.date_from
428: and nvl(posv.date_to,to_date('31/12/4712','DD/MM/YYYY'));
429:

Line 435: from per_org_structure_versions posv

431:
432: select greatest(posv.date_from,P_REPORT_DATE_FROM),
433: least(nvl(posv.date_to,P_REPORT_DATE_TO),P_REPORT_DATE_TO)
434: into l_min_date_from,l_min_date_to
435: from per_org_structure_versions posv
436: where posv.org_structure_version_id = l_min_org_structure_version_id;
437:
438: hr_utility.set_location('l_min_date_from='||l_min_date_from,170);
439: hr_utility.set_location('l_min_date_to='||l_min_date_to,180);

Line 443: from per_org_structure_versions posv

439: hr_utility.set_location('l_min_date_to='||l_min_date_to,180);
440:
441: select max(posv.org_structure_version_id)
442: into l_max_org_structure_version_id
443: from per_org_structure_versions posv
444: where posv.organization_structure_id = P_ORGANIZATION_STRUCTURE_ID
445: and P_REPORT_DATE_TO between posv.date_from
446: and nvl(posv.date_to,to_date('31/12/4712','DD/MM/YYYY'));
447:

Line 453: from per_org_structure_versions posv

449:
450: select least(nvl(posv.date_to,P_REPORT_DATE_TO),P_REPORT_DATE_TO),
451: greatest(posv.date_from,P_REPORT_DATE_FROM)
452: into l_max_date_to,l_max_date_from
453: from per_org_structure_versions posv
454: where posv.org_structure_version_id = l_max_org_structure_version_id;
455:
456: exception
457: when NO_DATA_FOUND then