APPS.PER_PQH_SHR dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 490: PER_ORG_STRUCTURE_ELEMENTS A

486: --
487: CURSOR C1(p_org_structure_version_id number, P_ORGANIZATION_ID NUMBER, p_business_group_id number) IS
488: SELECT level, POSITION_CONTROL_ENABLED_FLAG
489: FROM
490: PER_ORG_STRUCTURE_ELEMENTS A
491: where
492: a.business_group_id = p_business_group_id
493: start with organization_id_child = P_ORGANIZATION_ID
494: and ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID

Line 500: from PER_ORG_STRUCTURE_ELEMENTS

496: and ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID;
497: --
498: CURSOR C2(p_org_structure_version_id number) IS
499: select organization_id_parent organization_id
500: from PER_ORG_STRUCTURE_ELEMENTS
501: where ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID
502: minus
503: select organization_id_child organization_id
504: from PER_ORG_STRUCTURE_ELEMENTS

Line 504: from PER_ORG_STRUCTURE_ELEMENTS

500: from PER_ORG_STRUCTURE_ELEMENTS
501: where ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID
502: minus
503: select organization_id_child organization_id
504: from PER_ORG_STRUCTURE_ELEMENTS
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')