APPS.AR_PURGE dependencies on AR_RATE_ADJUSTMENTS

Line 5042: DELETE FROM ar_rate_adjustments

5038: WHERE cash_receipt_id = p_entity_id;
5039:
5040: --
5041:
5042: DELETE FROM ar_rate_adjustments
5043: WHERE cash_receipt_id = p_entity_id;
5044:
5045:
5046: --

Line 5356: SELECT 'X' FROM ar_rate_adjustments

5352: SELECT 'X' FROM ar_payment_schedules
5353: WHERE cash_receipt_id = cr_id
5354: FOR UPDATE OF cash_receipt_id NOWAIT;
5355: CURSOR c_ara( cr_id number) IS
5356: SELECT 'X' FROM ar_rate_adjustments
5357: WHERE cash_receipt_id = cr_id
5358: FOR UPDATE OF cash_receipt_id NOWAIT;
5359: BEGIN
5360: open c_cr(l_rcpt_id);

Line 5427: DELETE FROM ar_rate_adjustments

5423: p_table_name => 'AR_PAYMENT_SCHEDULES',
5424: p_mode => 'BATCH',
5425: p_key_value_list => r_ar_ps_key_value_list);*/
5426:
5427: DELETE FROM ar_rate_adjustments
5428: WHERE cash_receipt_id = l_rcpt_id;
5429:
5430: /*---------------------------------+
5431: | Calling central MRC library |

Line 5437: p_table_name => 'AR_RATE_ADJUSTMENTS',

5433: +---------------------------------*/
5434: -- Commented as a fix to bug - 13653152
5435: /*ar_mrc_engine.maintain_mrc_data(
5436: p_event_mode => 'DELETE',
5437: p_table_name => 'AR_RATE_ADJUSTMENTS',
5438: p_mode => 'BATCH',
5439: p_key_value_list => r_rate_adj_key_value_list);*/
5440:
5441: print(0,'Purged Successfully');