APPS.INV_EBI_ITEM_HELPER dependencies on PA_EGO_PHASES_V

Line 120: SELECT proj_element_id INTO l_id from pa_ego_phases_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);
120: SELECT proj_element_id INTO l_id from pa_ego_phases_v
121: WHERE name = l_pk1
122: AND parent_structure_id = l_pk2;
123: WHEN G_REVISION THEN
124: l_pk1 := ID_COL_VALUE('organization_id',p_pk_col_name_val_pairs);

Line 200: FROM pa_ego_phases_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
200: FROM pa_ego_phases_v
201: WHERE proj_element_id = l_pk1;
202: WHEN G_REVISION THEN
203: l_pk1 := ID_COL_VALUE('revision_id',p_pk_col_name_val_pairs);
204: SELECT revision_label INTO l_code