APPS.AR_INVOICE_API_PUB dependencies on RA_CUSTOMER_TRX_LINES

Line 2051: p_interface_line_attribute6 IN ra_customer_trx_lines.interface_line_attribute6%type DEFAULT NULL,

2047: -- Bug12668756
2048: PROCEDURE GET_TRXN_LINE_BALANCE(
2049: p_api_version IN NUMBER,
2050: p_customer_trx_id IN NUMBER,
2051: p_interface_line_attribute6 IN ra_customer_trx_lines.interface_line_attribute6%type DEFAULT NULL,
2052: x_amount_due_remaining OUT NOCOPY NUMBER,
2053: x_acctd_amount_due_remaining OUT NOCOPY NUMBER,
2054: x_return_status OUT NOCOPY VARCHAR2,
2055: x_msg_count OUT NOCOPY NUMBER,

Line 2104: FROM RA_CUSTOMER_TRX_LINES

2100: ELSE
2101: BEGIN
2102: SELECT count(1)
2103: INTO l_count
2104: FROM RA_CUSTOMER_TRX_LINES
2105: WHERE customer_trx_id = p_customer_trx_id
2106: AND INTERFACE_LINE_ATTRIBUTE6 = p_interface_line_attribute6;
2107:
2108: IF l_count = 0 THEN

Line 2120: ra_customer_trx_lines ctl

2116: INTO x_amount_due_remaining,
2117: x_acctd_amount_due_remaining
2118: FROM ra_batch_sources ra,
2119: ra_customer_trx ct,
2120: ra_customer_trx_lines ctl
2121: WHERE ra.batch_source_id = ct.batch_source_id
2122: AND ct.customer_trx_id = ctl.customer_trx_id
2123: AND nvl(gen_line_level_bal_flag,'N') = 'Y'
2124: AND ctl.line_type = 'LINE'