DBA Data[Home] [Help]

APPS.AS_OPP_HEADER_PVT dependencies on AS_FORECAST_PROB

Line 3467: FROM as_forecast_prob

3463: )
3464: IS
3465: CURSOR C_Win_Prob_Exists (c_Win_Prob NUMBER) IS
3466: SELECT 'X'
3467: FROM as_forecast_prob
3468: WHERE probability_value = c_Win_Prob
3469: -- ffang 091200 for bug 1403865
3470: and nvl(start_date_active, sysdate) <= sysdate
3471: and nvl(end_date_active, sysdate) >= sysdate

Line 3494: -- WIN_PROBABILITY should exist in as_forecast_prob

3490:
3491: IF (p_WIN_PROBABILITY is NOT NULL) and
3492: (p_WIN_PROBABILITY <> FND_API.G_MISS_NUM)
3493: THEN
3494: -- WIN_PROBABILITY should exist in as_forecast_prob
3495: OPEN C_Win_Prob_Exists (p_WIN_PROBABILITY);
3496: FETCH C_Win_Prob_Exists into l_val;
3497:
3498: IF C_Win_Prob_Exists%NOTFOUND THEN