APPS.EGO_ITEM_PVT dependencies on PA_EGO_LIFECYCLES_V

Line 520: FROM PA_EGO_LIFECYCLES_V

516: BEGIN
517: IF p_lc_phase_type = 'LIFECYCLE' THEN
518: SELECT name
519: INTO l_dummy_char
520: FROM PA_EGO_LIFECYCLES_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

Line 669: l_current_life_cycle PA_EGO_LIFECYCLES_V.NAME%TYPE;

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

Line 709: ,PA_EGO_LIFECYCLES_V PEP

705:
706: SELECT PEP.NAME
707: INTO l_current_life_cycle
708: FROM MTL_SYSTEM_ITEMS_B MSI
709: ,PA_EGO_LIFECYCLES_V PEP
710: WHERE MSI.INVENTORY_ITEM_ID =p_inventory_item_id
711: AND MSI.ORGANIZATION_ID = p_organization_id
712: AND MSI.LIFECYCLE_ID = PEP.PROJ_ELEMENT_ID;
713: