APPS.EGO_ITEM_PVT dependencies on PA_EGO_LIFECYCLES_V

Line 524: FROM PA_EGO_LIFECYCLES_V

520: BEGIN
521: IF p_lc_phase_type = 'LIFECYCLE' THEN
522: SELECT name
523: INTO l_dummy_char
524: FROM PA_EGO_LIFECYCLES_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

Line 673: l_current_life_cycle PA_EGO_LIFECYCLES_V.NAME%TYPE;

669: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
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;

Line 713: ,PA_EGO_LIFECYCLES_V PEP

709:
710: SELECT PEP.NAME
711: INTO l_current_life_cycle
712: FROM MTL_SYSTEM_ITEMS_B MSI
713: ,PA_EGO_LIFECYCLES_V PEP
714: WHERE MSI.INVENTORY_ITEM_ID =p_inventory_item_id
715: AND MSI.ORGANIZATION_ID = p_organization_id
716: AND MSI.LIFECYCLE_ID = PEP.PROJ_ELEMENT_ID;
717: