APPS.INV_EBI_ITEM_HELPER dependencies on PA_EGO_PHASES_V

Line 139: SELECT proj_element_id INTO l_id from pa_ego_phases_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);
139: SELECT proj_element_id INTO l_id from pa_ego_phases_v
140: WHERE name = l_pk1
141: AND parent_structure_id = l_pk2;
142: WHEN G_REVISION THEN
143: l_pk1 := ID_COL_VALUE('organization_id',p_pk_col_name_val_pairs);

Line 222: FROM pa_ego_phases_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
222: FROM pa_ego_phases_v
223: WHERE proj_element_id = l_pk1;
224: WHEN G_REVISION THEN
225: l_pk1 := ID_COL_VALUE('revision_id',p_pk_col_name_val_pairs);
226: SELECT revision_label INTO l_code

Line 1509: ,PA_EGO_PHASES_V phases

1505: BEGIN
1506:
1507: SELECT status.ITEM_STATUS_CODE INTO l_status_code
1508: FROM EGO_LCPHASE_ITEM_STATUS status
1509: ,PA_EGO_PHASES_V phases
1510: WHERE phases.PROJ_ELEMENT_ID = p_phase_id
1511: AND status.PHASE_CODE = phases.PHASE_CODE
1512: AND DEFAULT_FLAG = 'Y';
1513: