APPS.AS_OPP_HEADER_PVT dependencies on AS_SALES_STAGES_ALL_B

Line 3261: FROM as_sales_stages_all_b

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

Line 3288: -- SALES_STAGE_ID should exist in as_sales_stages_all_b

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

Line 5489: FROM as_sales_stages_all_b

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