APPS.EGO_ITEM_LC_IMP_PC_PUB dependencies on PA_EGO_PHASES_V

Line 1113: FROM ego_lcphase_item_status status, pa_ego_phases_v lc_phases

1109:
1110: CURSOR c_validate_status_code (cp_phase_id IN NUMBER
1111: ,cp_status_code IN VARCHAR2) IS
1112: SELECT status.item_status_code
1113: FROM ego_lcphase_item_status status, pa_ego_phases_v lc_phases
1114: WHERE lc_phases.proj_element_id = cp_phase_id
1115: AND status.phase_code = lc_phases.phase_code
1116: AND status.item_status_code = cp_status_code;
1117: --Bug 14076356 , Added to validate the Item status

Line 1266: FROM PA_EGO_PHASES_V

1262: IF c_get_def_status_code%NOTFOUND THEN
1263: CLOSE c_get_def_status_code;
1264: SELECT name
1265: INTO l_dummy_char
1266: FROM PA_EGO_PHASES_V
1267: WHERE proj_element_id = p_phase_id;
1268: fnd_message.Set_Name(G_APP_NAME, 'EGO_NO_STATUS_FOR_PHASE_ERR');
1269: fnd_message.Set_Token('PHASE', l_dummy_char);
1270: FND_MSG_PUB.Add;

Line 1351: FROM PA_EGO_PHASES_V

1347: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_INVALID_STATUS');
1348: fnd_message.Set_Token('STATUS', p_status_code);
1349: SELECT name
1350: INTO l_dummy_char
1351: FROM PA_EGO_PHASES_V
1352: WHERE proj_element_id = NVL(p_phase_id,l_phase_id_curr);
1353: fnd_message.Set_Token('PHASE', l_dummy_char);
1354: FND_MSG_PUB.Add;
1355: RAISE FND_API.G_EXC_ERROR;

Line 1385: -- FROM PA_EGO_PHASES_V

1381: fnd_message.Set_Name(G_APP_NAME, 'EGO_STATUS_INVALID');
1382: -- fnd_message.Set_Token('STATUS', p_status_code);
1383: -- SELECT name
1384: -- INTO l_dummy_char
1385: -- FROM PA_EGO_PHASES_V
1386: -- WHERE proj_element_id = NVL(p_phase_id,l_phase_id_curr);
1387: -- fnd_message.Set_Token('PHASE', l_dummy_char);
1388: FND_MSG_PUB.Add;
1389: RAISE FND_API.G_EXC_ERROR;