APPS.INV_EBI_ITEM_HELPER dependencies on PA_EGO_LIFECYCLES_V

Line 134: SELECT proj_element_id INTO l_id FROM pa_ego_lifecycles_v

130: SELECT item_catalog_group_id INTO l_id FROM mtl_item_catalog_groups_kfv
131: WHERE concatenated_segments = l_pk1;
132: WHEN G_LIFECYCLE THEN
133: l_pk1 := ID_COL_VALUE('name',p_pk_col_name_val_pairs);
134: SELECT proj_element_id INTO l_id FROM pa_ego_lifecycles_v
135: WHERE name = l_pk1;
136: WHEN G_CURRENT_PHASE THEN
137: l_pk1 := ID_COL_VALUE('name',p_pk_col_name_val_pairs);
138: l_pk2 := ID_COL_VALUE('parent_structure_id',p_pk_col_name_val_pairs);

Line 217: FROM pa_ego_lifecycles_v

213: WHERE item_catalog_group_id = l_pk1;
214: WHEN G_LIFECYCLE THEN
215: l_pk1 := ID_COL_VALUE('proj_element_id',p_pk_col_name_val_pairs);
216: SELECT name INTO l_code
217: FROM pa_ego_lifecycles_v
218: WHERE proj_element_id = l_pk1;
219: WHEN G_CURRENT_PHASE THEN
220: l_pk1 := ID_COL_VALUE('proj_element_id',p_pk_col_name_val_pairs);
221: SELECT phase_code INTO l_code