[Home] [Help]
2571: ra_rules rule1,
2572: ra_cust_trx_types ctt_prev,
2573: ra_cust_trx_types ctt,
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
2949: lc.expiration_date, /* expiration_date */
2950: lc.expiration_days, /* expiration_days */
2951: '' /* override_auto_accounting_flag */
2952: FROM
2953: ra_customer_trx_lines ctl,
2954: ar_line_conts lc
2955: WHERE cp_customer_trx_id = ctl.customer_trx_id
2956: and ctl.customer_trx_line_id = lc.customer_trx_line_id
2957: and cp_archive_level <> 'H'
3841: FOR UPDATE OF trx.customer_trx_id NOWAIT;
3842:
3843: cursor trx_line_cur is
3844: SELECT 'Found' record_found
3845: from ra_customer_trx_lines lines
3846: WHERE lines.customer_trx_id = p_entity_id
3847: FOR UPDATE OF lines.customer_trx_id NOWAIT;
3848:
3849: cursor dist_cur is
3886: ar_receivable_applications ra,
3887: ar_payment_schedules ps,
3888: ar_adjustments adj,
3889: ra_cust_trx_line_gl_dist dist,
3890: ra_customer_trx_lines lines,
3891: ra_customer_trx trx
3892: WHERE trx.customer_trx_id = p_entity_id
3893: AND trx.customer_trx_id = lines.customer_trx_id
3894: AND trx.customer_trx_id = dist.customer_trx_id (+)
4172: l_autorule_incomplete_count NUMBER;
4173: BEGIN
4174: SELECT COUNT(*)
4175: INTO l_autorule_incomplete_count
4176: FROM ra_customer_trx_lines
4177: WHERE customer_trx_id = p_entity_id
4178: AND line_type = 'LINE'
4179: AND autorule_complete_flag = 'N';
4180: IF l_autorule_incomplete_count > 0
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;
4371: --
4372: DELETE FROM ra_cust_trx_line_gl_dist
4373: WHERE customer_trx_id = p_entity_id;