APPS.OE_ORDER_PURGE_PVT dependencies on OE_SALES_CREDITS

Line 3052: FROM OE_SALES_CREDITS

3048: IS
3049:
3050: CURSOR c_order_sales_credits IS
3051: SELECT SALES_CREDIT_ID
3052: FROM OE_SALES_CREDITS
3053: WHERE HEADER_ID = p_header_id;
3054:
3055: l_sales_credit_id NUMBER;
3056: l_lock_sales_credit_id NUMBER;

Line 3073: FROM oe_sales_credits

3069:
3070: -- Lock the sales credits record.
3071: SELECT sales_credit_id
3072: INTO l_lock_sales_credit_id
3073: FROM oe_sales_credits
3074: WHERE sales_credit_id = l_sales_credit_id
3075: FOR UPDATE NOWAIT;
3076:
3077: DELETE FROM OE_SALES_CREDITS

Line 3077: DELETE FROM OE_SALES_CREDITS

3073: FROM oe_sales_credits
3074: WHERE sales_credit_id = l_sales_credit_id
3075: FOR UPDATE NOWAIT;
3076:
3077: DELETE FROM OE_SALES_CREDITS
3078: WHERE SALES_CREDIT_ID = l_sales_credit_id;
3079:
3080: END LOOP;
3081:

Line 3114: FROM OE_SALES_CREDITS

3110: IS
3111:
3112: CURSOR c_line_sales_credits IS
3113: SELECT SALES_CREDIT_ID
3114: FROM OE_SALES_CREDITS
3115: WHERE LINE_ID = p_line_id;
3116:
3117: l_sales_credit_id NUMBER;
3118: l_lock_sales_credit_id NUMBER;

Line 3135: FROM oe_sales_credits

3131:
3132: -- Lock the sales credits record.
3133: SELECT sales_credit_id
3134: INTO l_lock_sales_credit_id
3135: FROM oe_sales_credits
3136: WHERE sales_credit_id = l_sales_credit_id
3137: FOR UPDATE NOWAIT;
3138:
3139: DELETE FROM OE_SALES_CREDITS

Line 3139: DELETE FROM OE_SALES_CREDITS

3135: FROM oe_sales_credits
3136: WHERE sales_credit_id = l_sales_credit_id
3137: FOR UPDATE NOWAIT;
3138:
3139: DELETE FROM OE_SALES_CREDITS
3140: WHERE SALES_CREDIT_ID = l_sales_credit_id;
3141:
3142: END LOOP;
3143: