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 293: FROM ra_customer_trx_lines

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

Line 472: FROM ra_customer_trx_lines

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

Line 642: FROM ra_customer_trx_lines_all trxl, zx_lines zl

638: BEGIN
639: IF p_tax_type = 'VAT'
640: THEN
641: SELECT sum(zl.tax_amt) INTO tax_amount
642: FROM ra_customer_trx_lines_all trxl, zx_lines zl
643: WHERE trxl.line_type = 'TAX'
644: AND trxl.tax_line_id = zl.tax_line_id
645: AND zl.tax_type_code like 'VAT%'
646: AND zl.application_id = 222

Line 651: FROM ra_customer_trx_lines_all trxl, zx_lines zl

647: AND zl.entity_code = 'TRANSACTIONS'
648: AND trxl.customer_trx_id = p_customer_trx_id;
649: ELSE
650: SELECT sum(zl.tax_amt) INTO tax_amount
651: FROM ra_customer_trx_lines_all trxl, zx_lines zl
652: WHERE trxl.line_type = 'TAX'
653: AND trxl.tax_line_id = zl.tax_line_id
654: AND (zl.tax_type_code is null OR zl.tax_type_code not like 'VAT%')
655: AND zl.application_id = 222

Line 700: FROM ra_customer_trx_lines trxl, zx_lines zl

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

Line 710: FROM ra_customer_trx_lines trxl, zx_lines zl

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