APPS.EGO_ITEM_PVT dependencies on PA_EGO_PHASES_V

Line 525: FROM PA_EGO_PHASES_V

521: WHERE proj_element_id = p_proj_element_id;
522: ELSIF p_lc_phase_type = 'PHASE' THEN
523: SELECT name
524: INTO l_dummy_char
525: FROM PA_EGO_PHASES_V
526: WHERE proj_element_id = p_proj_element_id;
527: END IF;
528: RETURN l_dummy_char;
529: EXCEPTION

Line 670: l_current_phase_name PA_EGO_PHASES_V.NAME%TYPE;

666: l_current_data_element EGO_USER_ATTR_ROW_OBJ;
667:
668: l_current_category_name MTL_ITEM_CATALOG_GROUPS_KFV.concatenated_segments%TYPE;
669: l_current_life_cycle PA_EGO_LIFECYCLES_V.NAME%TYPE;
670: l_current_phase_name PA_EGO_PHASES_V.NAME%TYPE;
671: l_policy_cat_id NUMBER;
672: l_catalog_category_names_table LOCAL_MEDIUM_VARCHAR_TABLE;
673: l_item_number MTL_SYSTEM_ITEMS_B.SEGMENT1%TYPE;
674: l_row_identifier NUMBER;

Line 720: ,PA_EGO_PHASES_V PEP

716:
717: SELECT PEP.NAME
718: INTO l_current_phase_name
719: FROM MTL_SYSTEM_ITEMS_B MSI
720: ,PA_EGO_PHASES_V PEP
721: WHERE MSI.INVENTORY_ITEM_ID = p_inventory_item_id
722: AND MSI.ORGANIZATION_ID = p_organization_id
723: AND MSI.CURRENT_PHASE_ID = PEP.PROJ_ELEMENT_ID;
724: