APPS.ARP_ETAX_UTIL dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 149: 5) Added deletes for ra_customer_trx_lines and ra_cust_trx_line_gl_dist

145:
146: 4) Changed from trx_line_id to trx_id per djancis. We have to
147: build all tax lines each time.
148:
149: 5) Added deletes for ra_customer_trx_lines and ra_cust_trx_line_gl_dist
150: tables.
151:
152: 6) Added logic to populate previous_customer_trx_line_id of CM
153: tax lines. Used Navigator to tweak for improved perf.

Line 293: DELETE FROM RA_CUST_TRX_LINE_GL_DIST gld

289: IF PG_DEBUG in ('Y', 'C') THEN
290: arp_standard.debug('arp_etax_util.delete_tax_lines_from_ar()+');
291: END IF;
292:
293: DELETE FROM RA_CUST_TRX_LINE_GL_DIST gld
294: WHERE customer_trx_line_id in (
295: SELECT tl.customer_trx_line_id
296: FROM RA_CUSTOMER_TRX_LINES tl,
297: ZX_LINES zx

Line 630: RA_CUST_TRX_LINE_GL_DIST REC

626: FROM
627: RA_CUSTOMER_TRX T,
628: RA_CUSTOMER_TRX_LINES TL,
629: RA_CUST_TRX_TYPES TT,
630: RA_CUST_TRX_LINE_GL_DIST REC
631: WHERE T.customer_trx_id = trx_id
632: AND T.cust_trx_type_id = TT.cust_trx_type_id
633: AND T.org_id = TT.org_id
634: AND T.customer_trx_id = TL.customer_trx_id

Line 1066: l_ccid ra_cust_trx_line_gl_dist_all.code_combination_id%type;

1062: p_event_class_code IN VARCHAR2,
1063: p_function_short_name IN VARCHAR2,
1064: p_tax_classification_code OUT NOCOPY VARCHAR2 ) IS
1065:
1066: l_ccid ra_cust_trx_line_gl_dist_all.code_combination_id%type;
1067: l_concat_segments VARCHAR2(2000);
1068: l_fail_count NUMBER;
1069: BEGIN
1070: arp_standard.debug('arp_etax_utils.get_default_tax_classification()+');

Line 3286: ra_cust_trx_line_gl_dist ar_rec

3282: l_sob_id,
3283: l_gl_date
3284: FROM
3285: ra_customer_trx_lines ar_tax,
3286: ra_cust_trx_line_gl_dist ar_rec
3287: WHERE
3288: ar_tax.customer_trx_line_id = p_subject_id
3289: AND ar_tax.customer_trx_id = ar_rec.customer_trx_id
3290: AND ar_rec.account_class = 'REC'