APPS.AR_PURGE dependencies on AR_DEFERRED_LINES

Line 2578: ar_deferred_lines dl

2574: mtl_system_items mtl,
2575: ra_customer_trx_lines ctl,
2576: ra_customer_trx ct_prev,
2577: ra_customer_trx ct,
2578: ar_deferred_lines dl
2579: WHERE te.tax_exemption_id (+) = ctl.tax_exemption_id
2580: AND te.reason_code = lu_te.lookup_code (+)
2581: AND lu_te.lookup_type (+) = 'TAX_REASON'
2582: AND ier.item_exception_rate_id (+) = ctl.item_exception_rate_id

Line 4311: FROM ar_deferred_lines dl

4307: l_line_revenue NUMBER;
4308: BEGIN
4309: SELECT COUNT(*)
4310: INTO l_line_revenue
4311: FROM ar_deferred_lines dl
4312: WHERE p_entity_id = dl.customer_trx_id
4313: AND dl.line_collectible_flag = 'N'
4314: AND dl.manual_override_flag = 'N'
4315: AND dl.acctd_amount_due_original <> dl.acctd_amount_recognized;

Line 4366: DELETE FROM ar_deferred_lines

4362: WHERE customer_trx_line_id in ( select customer_trx_line_id
4363: from ra_customer_trx
4364: where customer_trx_id = p_entity_id );
4365: --
4366: DELETE FROM ar_deferred_lines
4367: WHERE customer_trx_id = p_entity_id;
4368: --
4369: DELETE FROM ra_customer_trx_lines
4370: WHERE customer_trx_id = p_entity_id;