APPS.PER_PQH_SHR dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 26: per_org_structure_versions ver,

22: --
23: cursor c2(p_business_group_id number, p_effective_date date) is
24: select ver.org_structure_version_id
25: from
26: per_org_structure_versions ver,
27: per_organization_structures str
28: where
29: ver.organization_structure_id = str.organization_structure_id
30: and str.business_group_id = p_business_group_id

Line 509: from per_org_structure_versions osv

505: where ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID;
506: --
507: cursor c3(p_org_structure_version_id number) is
508: select nvl(osv.topnode_pos_ctrl_enabled_flag,'N')
509: from per_org_structure_versions osv
510: where osv.ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID;
511: --
512: l_org_pc_enabled_null boolean := false;
513: l_top_org_id number;