APPS.PQH_PSF_BUS dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 4191: from per_org_structure_elements a

4187: l_pc_version number := -1;
4188:
4189: cursor csr_top_node(p_pc_version in number) is
4190: select a.organization_id_parent organization_id
4191: from per_org_structure_elements a
4192: where a.org_structure_version_id = p_pc_version
4193: and not exists
4194: (select null
4195: from per_org_structure_elements b

Line 4195: from per_org_structure_elements b

4191: from per_org_structure_elements a
4192: where a.org_structure_version_id = p_pc_version
4193: and not exists
4194: (select null
4195: from per_org_structure_elements b
4196: where b.org_structure_version_id = p_pc_version
4197: AND b.organization_id_child = a.organization_id_parent);
4198: begin
4199: l_pc_version := get_pc_str_version(p_business_group_id, p_effective_date);