[Home] [Help]
321: from per_security_profiles psp
322: where psp.include_top_organization_flag = 'Y'
323: and psp.organization_structure_id =
324: (select osv.organization_structure_id
325: from per_org_structure_versions osv
326: where osv.org_structure_version_id =
327: p_org_structure_version_id)
328: and ((psp.organization_id = p_organization_id_child)
329: or(psp.organization_id = p_organization_id_parent
381:
382: cursor c1 is
383: select str.position_control_structure_flg
384: from per_organization_structures str,
385: per_org_structure_versions osv
386: where osv.org_structure_version_id = p_org_structure_version_id
387: and osv.organization_structure_id = str.organization_structure_id;
388:
389: l_result varchar2(10);
422: -- |--------------------< chk_org_structure_version_id >------------------------|
423: -- -----------------------------------------------------------------------------
424: -- Description:
425: -- Validates that the mandatory structure version id is supplied and that it
426: -- exists in per_org_structure_versions for the business group on the
427: -- effective date (Insert Only).
428: --
429: -- Pre-conditions:
430: -- Business group is valid
435: -- p_org_structure_version_id
436: -- p_effective_date
437: --
438: -- Post Success:
439: -- If a row does exist in per_org_structure_versions for the given id and
440: -- business group then processing continues.
441: --
442: -- Post Failure:
443: -- Processing stops and an error is raised.
451: ,p_effective_date in DATE) IS
452:
453: CURSOR csr_org_structure_versions IS
454: SELECT 'X'
455: from per_org_structure_versions osv
456: where osv.org_structure_version_id = p_org_structure_version_id
457: and (osv.business_group_id = p_business_group_id or p_business_group_id is null)
458: and p_effective_date between osv.DATE_FROM
459: and nvl(osv.DATE_TO,hr_general.end_of_time);