APPS.INV_EBI_ITEM_HELPER dependencies on PA_EGO_LIFECYCLES_V

Line 115: SELECT proj_element_id INTO l_id FROM pa_ego_lifecycles_v

111: SELECT item_catalog_group_id INTO l_id FROM mtl_item_catalog_groups_kfv
112: WHERE concatenated_segments = l_pk1;
113: WHEN G_LIFECYCLE THEN
114: l_pk1 := ID_COL_VALUE('name',p_pk_col_name_val_pairs);
115: SELECT proj_element_id INTO l_id FROM pa_ego_lifecycles_v
116: WHERE name = l_pk1;
117: WHEN G_CURRENT_PHASE THEN
118: l_pk1 := ID_COL_VALUE('name',p_pk_col_name_val_pairs);
119: l_pk2 := ID_COL_VALUE('parent_structure_id',p_pk_col_name_val_pairs);

Line 195: FROM pa_ego_lifecycles_v

191: WHERE item_catalog_group_id = l_pk1;
192: WHEN G_LIFECYCLE THEN
193: l_pk1 := ID_COL_VALUE('proj_element_id',p_pk_col_name_val_pairs);
194: SELECT name INTO l_code
195: FROM pa_ego_lifecycles_v
196: WHERE proj_element_id = l_pk1;
197: WHEN G_CURRENT_PHASE THEN
198: l_pk1 := ID_COL_VALUE('proj_element_id',p_pk_col_name_val_pairs);
199: SELECT phase_code INTO l_code