APPS.PQH_ASG_WRAPPER dependencies on PER_ORG_STRUCTURE_VERSIONS_V

Line 542: ,p_organization_structure_id IN per_org_structure_versions_v.organization_structure_id%TYPE)

538: -- ---------------------------------------------------------------------------+
539: --
540: FUNCTION Is_Org_A_Node
541: (p_search_org_id IN hr_organization_units.organization_id%TYPE
542: ,p_organization_structure_id IN per_org_structure_versions_v.organization_structure_id%TYPE)
543: RETURN CHAR IS
544: --
545: Cursor c_get_structure_version Is
546: Select posvv.org_structure_version_id version_id

Line 548: per_org_structure_versions_v posvv,

544: --
545: Cursor c_get_structure_version Is
546: Select posvv.org_structure_version_id version_id
547: From per_organization_structures_v posv,
548: per_org_structure_versions_v posvv,
549: fnd_sessions fs
550: Where posvv.organization_structure_id = posv.organization_structure_id
551: and fs.effective_date Between posvv.date_from
552: and NVL(posvv.date_to,hr_general.end_of_time)

Line 561: (p_version_id IN per_org_structure_versions_v.organization_structure_id%TYPE) IS

557: -- Cursor modified to improve performance.
558: -- per_org_structure_elements is used instead of per_org_structure_elements_v.
559:
560: Cursor c_orgs_in_hierarchy
561: (p_version_id IN per_org_structure_versions_v.organization_structure_id%TYPE) IS
562: select posev.organization_id_parent org_id
563: from per_org_structure_elements posev
564: where posev.org_Structure_version_id = p_version_id
565: UNION

Line 574: v_version_id per_org_structure_versions_v.organization_structure_id%TYPE := NULL;

570: v_org_in_hierarchy BOOLEAN := FALSE;
571: v_users_starting_node VARCHAR2(240) := NULL;
572: v_return_message VARCHAR2(5);
573: --
574: v_version_id per_org_structure_versions_v.organization_structure_id%TYPE := NULL;
575: --
576: l_proc varchar2(72) := g_package||'Is_Org_A_Node';
577: --
578: BEGIN

Line 746: FROM per_org_structure_versions v

742: AND o.org_structure_version_id = PRIOR o.org_structure_version_id
743: START WITH o.organization_id_child = p_search_org_id
744: AND o.org_structure_version_id =
745: (SELECT v.org_structure_version_id
746: FROM per_org_structure_versions v
747: WHERE v.organization_structure_id = g_org_hierarchy_id
748: AND hr_general.effective_date BETWEEN v.date_from
749: AND NVL(v.date_to, hr_general.end_of_time)));
750: if l_dummy = 'X' then

Line 806: FROM per_org_structure_versions v

802: AND o.org_structure_version_id = PRIOR o.org_structure_version_id
803: START WITH o.organization_id_child = p_search_org_id
804: AND o.org_structure_version_id =
805: (SELECT v.org_structure_version_id
806: FROM per_org_structure_versions v
807: WHERE v.organization_structure_id = g_org_hierarchy_id
808: AND hr_general.effective_date BETWEEN v.date_from
809: AND NVL(v.date_to, hr_general.end_of_time)));
810: if l_dummy = 'X' then