DBA Data[Home] [Help]

APPS.ARP_PROCESS_APPLICATION dependencies on RA_CUSTOMER_TRX_LINES

Line 8534: update ra_customer_Trx_lines

8530: set previous_customer_Trx_id = NULL
8531: where customer_Trx_id = p_cust_trx_id
8532: and previous_customer_Trx_id = p_app_cust_trx_id;
8533:
8534: update ra_customer_Trx_lines
8535: set previous_customer_Trx_line_id = NULL,
8536: previous_customer_Trx_id = NULL -- Fix for Bug 6726394 (customer_trx_id
8537: where customer_Trx_id = p_cust_trx_id -- value has to be set to null in ra_customer_Trx_lines)
8538: and previous_customer_Trx_id = p_app_cust_trx_id;

Line 8537: where customer_Trx_id = p_cust_trx_id -- value has to be set to null in ra_customer_Trx_lines)

8533:
8534: update ra_customer_Trx_lines
8535: set previous_customer_Trx_line_id = NULL,
8536: previous_customer_Trx_id = NULL -- Fix for Bug 6726394 (customer_trx_id
8537: where customer_Trx_id = p_cust_trx_id -- value has to be set to null in ra_customer_Trx_lines)
8538: and previous_customer_Trx_id = p_app_cust_trx_id;
8539:
8540: SELECT trx_number
8541: INTO l_trx_number