APPS.AS_OPP_HEADER_PVT dependencies on AS_SALES_STAGES_ALL_B

Line 3262: FROM as_sales_stages_all_b

3258: )
3259: IS
3260: CURSOR C_SALES_STAGE_ID_Exists (c_SALES_STAGE_ID NUMBER) IS
3261: SELECT 'X'
3262: FROM as_sales_stages_all_b
3263: WHERE sales_stage_id = c_sales_stage_id
3264: -- ffang 091200 for bug 1403865
3265: and nvl(start_date_active, sysdate) <= sysdate
3266: and nvl(end_date_active, sysdate) >= sysdate

Line 3289: -- SALES_STAGE_ID should exist in as_sales_stages_all_b

3285:
3286: IF (p_SALES_STAGE_ID is NOT NULL) and
3287: (p_SALES_STAGE_ID <> FND_API.G_MISS_NUM)
3288: THEN
3289: -- SALES_STAGE_ID should exist in as_sales_stages_all_b
3290: OPEN C_SALES_STAGE_ID_Exists (p_SALES_STAGE_ID);
3291: FETCH C_SALES_STAGE_ID_Exists into l_val;
3292:
3293: IF C_SALES_STAGE_ID_Exists%NOTFOUND THEN

Line 5490: FROM as_sales_stages_all_b

5486: )
5487: IS
5488: CURSOR C_Get_Stage_Info (c_SALES_STAGE_ID NUMBER) IS
5489: SELECT nvl(min_win_probability, 0), nvl(max_win_probability, 100)
5490: FROM as_sales_stages_all_b
5491: WHERE sales_stage_id = c_Sales_Stage_Id;
5492:
5493: CURSOR c_Win_Prob_Limit(c_SALES_METHODOLOGY_ID NUMBER, c_SALES_STAGE_ID NUMBER) IS
5494: SELECT nvl(min_win_probability, 0), nvl(max_win_probability, 100)