APPS.EGO_ITEM_PVT dependencies on PA_EGO_PHASES_V

Line 529: FROM PA_EGO_PHASES_V

525: WHERE proj_element_id = p_proj_element_id;
526: ELSIF p_lc_phase_type = 'PHASE' THEN
527: SELECT name
528: INTO l_dummy_char
529: FROM PA_EGO_PHASES_V
530: WHERE proj_element_id = p_proj_element_id;
531: END IF;
532: RETURN l_dummy_char;
533: EXCEPTION

Line 674: l_current_phase_name PA_EGO_PHASES_V.NAME%TYPE;

670: l_current_data_element EGO_USER_ATTR_ROW_OBJ;
671:
672: l_current_category_name MTL_ITEM_CATALOG_GROUPS_KFV.concatenated_segments%TYPE;
673: l_current_life_cycle PA_EGO_LIFECYCLES_V.NAME%TYPE;
674: l_current_phase_name PA_EGO_PHASES_V.NAME%TYPE;
675: l_policy_cat_id NUMBER;
676: l_catalog_category_names_table LOCAL_MEDIUM_VARCHAR_TABLE;
677: l_item_number MTL_SYSTEM_ITEMS_B.SEGMENT1%TYPE;
678: l_row_identifier NUMBER;

Line 724: ,PA_EGO_PHASES_V PEP

720:
721: SELECT PEP.NAME
722: INTO l_current_phase_name
723: FROM MTL_SYSTEM_ITEMS_B MSI
724: ,PA_EGO_PHASES_V PEP
725: WHERE MSI.INVENTORY_ITEM_ID = p_inventory_item_id
726: AND MSI.ORGANIZATION_ID = p_organization_id
727: AND MSI.CURRENT_PHASE_ID = PEP.PROJ_ELEMENT_ID;
728: