APPS.BIS_TARGET_LEVEL_PVT dependencies on BISFV_TARGET_LEVELS

Line 28: REM | 30-JUN-03 rchandra Selected DATASET_ID from bisfv_target_levels to |

24: REM | 23-JAN-03 sugopal For having different local variables for IN and OUT |
25: REM | parameters (bug#2758428) |
26: REM | 17-MAR-03 smuruges Modified the WHERE clause for the cursor ind_res |
27: REM | Replaced the OR clause with nvl on sysdate. |
28: REM | 30-JUN-03 rchandra Selected DATASET_ID from bisfv_target_levels to |
29: REM | populate BIS_Target_Level_PUB.Target_Level_Rec_Type|
30: REM | for bug 3004651 |
31: REM | 21-OCT-04 arhegde bug# 3634587 The SQL used shows up on performance |
32: REM | repository top-20, Removed Retrieve_Measure_Notify_Resps() |

Line 1053: from bisfv_target_levels

1049: , REPORT_USER_FUNCTION_NAME
1050: , UNIT_OF_MEASURE
1051: , SYSTEM_FLAG
1052: , DATASET_ID
1053: from bisfv_target_levels
1054: where measure_id = l_Measure_id;
1055:
1056: BEGIN
1057: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1410: from bisfv_target_levels

1406: , l_target_level_rec.REPORT_USER_FUNCTION_NAME
1407: , l_target_level_rec.UNIT_OF_MEASURE
1408: , l_target_level_rec.SYSTEM_FLAG
1409: , l_target_level_rec.DATASET_ID
1410: from bisfv_target_levels
1411: where target_level_ID = p_Target_Level_rec.Target_Level_ID;
1412: end if;
1413:
1414: x_Target_Level_rec := l_Target_Level_rec;