[Home] [Help]
1654: ra_rules rule1,
1655: ra_cust_trx_types ctt_prev,
1656: ra_cust_trx_types ctt,
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
2032: lc.expiration_date, /* expiration_date */
2033: lc.expiration_days, /* expiration_days */
2034: '' /* override_auto_accounting_flag */
2035: FROM
2036: ra_customer_trx_lines ctl,
2037: ar_line_conts lc
2038: WHERE cp_customer_trx_id = ctl.customer_trx_id
2039: and ctl.customer_trx_line_id = lc.customer_trx_line_id
2040: and cp_archive_level <> 'H'
2924: FOR UPDATE OF trx.customer_trx_id NOWAIT;
2925:
2926: cursor trx_line_cur is
2927: SELECT 'Found' record_found
2928: from ra_customer_trx_lines lines
2929: WHERE lines.customer_trx_id = p_entity_id
2930: FOR UPDATE OF lines.customer_trx_id NOWAIT;
2931:
2932: cursor dist_cur is
2969: ar_receivable_applications ra,
2970: ar_payment_schedules ps,
2971: ar_adjustments adj,
2972: ra_cust_trx_line_gl_dist dist,
2973: ra_customer_trx_lines lines,
2974: ra_customer_trx trx
2975: WHERE trx.customer_trx_id = p_entity_id
2976: AND trx.customer_trx_id = lines.customer_trx_id
2977: AND trx.customer_trx_id = dist.customer_trx_id (+)
3255: l_autorule_incomplete_count NUMBER;
3256: BEGIN
3257: SELECT COUNT(*)
3258: INTO l_autorule_incomplete_count
3259: FROM ra_customer_trx_lines
3260: WHERE customer_trx_id = p_entity_id
3261: AND line_type = 'LINE'
3262: AND autorule_complete_flag = 'N';
3263: IF l_autorule_incomplete_count > 0
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;
3459: --
3460: DELETE FROM ra_cust_trx_line_gl_dist
3461: WHERE customer_trx_id = p_entity_id