DBA Data[Home] [Help]

APPS.AS_OPP_HEADER_PVT dependencies on AS_FORECAST_PROB

Line 3468: FROM as_forecast_prob

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

Line 3495: -- WIN_PROBABILITY should exist in as_forecast_prob

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