DBA Data[Home] [Help]

APPS.AR_CM_VAL_PVT dependencies on RA_CUSTOMER_TRX_LINES

Line 92: FROM ra_customer_trx_lines

88: IF p_inv_line_number IS NOT NULL THEN
89: BEGIN
90: SELECT customer_trx_line_id
91: INTO p_inv_customer_trx_line_id
92: FROM ra_customer_trx_lines
93: WHERE customer_trx_id = p_inv_customer_trx_id
94: AND line_number = p_inv_line_number
95: AND line_type = 'LINE';
96: EXCEPTION

Line 109: FROM ra_customer_trx_lines

105: IF p_inv_customer_trx_line_id IS NOT NULL THEN
106: BEGIN
107: SELECT customer_trx_id
108: INTO p_inv_customer_trx_id
109: FROM ra_customer_trx_lines
110: WHERE customer_trx_line_id = p_inv_customer_trx_line_id
111: AND line_type = 'LINE';
112: EXCEPTION
113: WHEN no_data_found THEN