APPS.EGO_ITEM_LC_IMP_PC_PUB dependencies on PA_EGO_PHASES_V

Line 1110: FROM ego_lcphase_item_status status, pa_ego_phases_v lc_phases

1106:
1107: CURSOR c_validate_status_code (cp_phase_id IN NUMBER
1108: ,cp_status_code IN VARCHAR2) IS
1109: SELECT status.item_status_code
1110: FROM ego_lcphase_item_status status, pa_ego_phases_v lc_phases
1111: WHERE lc_phases.proj_element_id = cp_phase_id
1112: AND status.phase_code = lc_phases.phase_code
1113: AND status.item_status_code = cp_status_code;
1114:

Line 1257: FROM PA_EGO_PHASES_V

1253: IF c_get_def_status_code%NOTFOUND THEN
1254: CLOSE c_get_def_status_code;
1255: SELECT name
1256: INTO l_dummy_char
1257: FROM PA_EGO_PHASES_V
1258: WHERE proj_element_id = p_phase_id;
1259: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_STATUS_FOR_PHASE_ERR');
1260: fnd_message.Set_Token('PHASE', l_dummy_char);
1261: FND_MSG_PUB.Add;

Line 1328: FROM PA_EGO_PHASES_V

1324: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_INVALID_STATUS');
1325: fnd_message.Set_Token('STATUS', p_status_code);
1326: SELECT name
1327: INTO l_dummy_char
1328: FROM PA_EGO_PHASES_V
1329: WHERE proj_element_id = NVL(p_phase_id,l_phase_id_curr);
1330: fnd_message.Set_Token('PHASE', l_dummy_char);
1331: FND_MSG_PUB.Add;
1332: RAISE FND_API.G_EXC_ERROR;