APPS.PQH_UTILITY dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 367: l_org_structure_version_id per_org_structure_versions.org_structure_version_id%type;

363: p_rule_level_cd OUT nocopy varchar2)
364: RETURN BOOLEAN is
365: --
366: l_organization_structure_id pqh_rule_sets.organization_structure_id%type;
367: l_org_structure_version_id per_org_structure_versions.org_structure_version_id%type;
368: --
369: l_hierarchy_level number(10);
370: l_parent_node pqh_rule_sets.organization_id%type;
371: --

Line 553: From per_org_structure_versions

549: Procedure get_org_structure_version_id(p_org_structure_id IN NUMBER,
550: p_org_structure_version_id OUT nocopy NUMBER) is
551: Cursor c1 is
552: Select org_structure_version_id
553: From per_org_structure_versions
554: Where organization_structure_id = p_org_structure_id
555: AND version_number =
556: (select max(version_number)
557: From per_org_structure_versions

Line 557: From per_org_structure_versions

553: From per_org_structure_versions
554: Where organization_structure_id = p_org_structure_id
555: AND version_number =
556: (select max(version_number)
557: From per_org_structure_versions
558: Where organization_structure_id = p_org_structure_id);
559: --
560: l_proc varchar2(72) := g_package||'g_org_structure_version_id';
561: --