APPS.ARP_TRX_LINE_UTIL dependencies on RA_CUSTOMER_TRX_LINES

Line 139: FROM ra_customer_trx_lines l,

135: l_prior_date date;
136:
137: CURSOR gl_dates IS
138: SELECT gl_date
139: FROM ra_customer_trx_lines l,
140: ar_revenue_assignments ra
141: WHERE l.customer_trx_line_id = p_customer_trx_line_id
142: AND l.customer_trx_line_id = ra.customer_trx_line_id
143: AND ra.account_class = 'REV'

Line 161: FROM ra_customer_trx_lines l,

157: SELECT MIN(gl_date),
158: MAX(gl_date)
159: INTO l_min_gl_date,
160: l_max_gl_date
161: FROM ra_customer_trx_lines l,
162: ar_revenue_assignments ra
163: WHERE l.customer_trx_line_id = p_customer_trx_line_id
164: AND l.customer_trx_line_id = ra.customer_trx_line_id
165: AND ra.account_class = 'REV';

Line 294: FROM ra_customer_trx_lines

290: END IF;
291:
292: SELECT nvl( max(line_number), 0 ) + 1
293: INTO p_line_number
294: FROM ra_customer_trx_lines
295: WHERE customer_trx_id = p_customer_trx_id
296: AND line_type in ('LINE', 'CB', 'CHARGES');
297:
298: IF PG_DEBUG in ('Y', 'C') THEN

Line 473: FROM ra_customer_trx_lines

469: SELECT
470: nvl(max(line_number) , 0)
471: INTO
472: l_line_number
473: FROM ra_customer_trx_lines
474: WHERE customer_trx_id = p_customer_trx_id
475: AND line_type IN ('LINE','CB','CHARGES');
476: p_line_number := l_line_number+1;
477: IF PG_DEBUG in ('Y', 'C') THEN

Line 703: FROM ra_customer_trx_lines trxl, zx_lines zl

699: BEGIN
700: IF p_tax_type = 'VAT'
701: THEN
702: SELECT sum(zl.tax_amt) INTO tax_amount
703: FROM ra_customer_trx_lines trxl, zx_lines zl
704: WHERE trxl.line_type = 'TAX'
705: AND trxl.tax_line_id = zl.tax_line_id
706: AND zl.tax_type_code like 'VAT%'
707: AND zl.application_id = 222

Line 713: FROM ra_customer_trx_lines trxl, zx_lines zl

709: AND trxl.customer_trx_id = p_customer_trx_id
710: AND trxl.link_to_cust_trx_line_id = p_customer_trx_line_id;
711: ELSE
712: SELECT sum(zl.tax_amt) INTO tax_amount
713: FROM ra_customer_trx_lines trxl, zx_lines zl
714: WHERE trxl.line_type = 'TAX'
715: AND trxl.tax_line_id = zl.tax_line_id
716: AND (zl.tax_type_code is null OR zl.tax_type_code not like 'VAT%')
717: AND zl.application_id = 222