APPS.AR_PURGE dependencies on AR_DEFERRED_LINES

Line 1661: ar_deferred_lines dl

1657: mtl_system_items mtl,
1658: ra_customer_trx_lines ctl,
1659: ra_customer_trx ct_prev,
1660: ra_customer_trx ct,
1661: ar_deferred_lines dl
1662: WHERE te.tax_exemption_id (+) = ctl.tax_exemption_id
1663: AND te.reason_code = lu_te.lookup_code (+)
1664: AND lu_te.lookup_type (+) = 'TAX_REASON'
1665: AND ier.item_exception_rate_id (+) = ctl.item_exception_rate_id

Line 3394: FROM ar_deferred_lines dl

3390: l_line_revenue NUMBER;
3391: BEGIN
3392: SELECT COUNT(*)
3393: INTO l_line_revenue
3394: FROM ar_deferred_lines dl
3395: WHERE p_entity_id = dl.customer_trx_id
3396: AND dl.line_collectible_flag = 'N'
3397: AND dl.manual_override_flag = 'N'
3398: AND dl.acctd_amount_due_original <> dl.acctd_amount_recognized;

Line 3454: DELETE FROM ar_deferred_lines

3450: WHERE customer_trx_line_id in ( select customer_trx_line_id
3451: from ra_customer_trx
3452: where customer_trx_id = p_entity_id );
3453: --
3454: DELETE FROM ar_deferred_lines
3455: WHERE customer_trx_id = p_entity_id;
3456: --
3457: DELETE FROM ra_customer_trx_lines
3458: WHERE customer_trx_id = p_entity_id;