DBA Data[Home] [Help]

APPS.ARP_PROCESS_HEADER_UPDTE_COVER dependencies on RA_CUSTOMER_TRX_ALL

Line 376: CURSOR c_get_old_complete_flag (p_customer_trx_id ra_customer_trx_all.customer_trx_id%type) IS

372: WHERE customer_trx_id = p_trx_id
373: AND line_type = 'LINE';
374:
375: /* manishri, 07-Jun-2010. Bug 9693686 */
376: CURSOR c_get_old_complete_flag (p_customer_trx_id ra_customer_trx_all.customer_trx_id%type) IS
377: SELECT complete_flag
378: FROM ra_customer_trx_all
379: WHERE customer_trx_id = p_customer_trx_id;
380: /* end of change, manishri, 07-Jun-2010. Bug 9693686 */

Line 378: FROM ra_customer_trx_all

374:
375: /* manishri, 07-Jun-2010. Bug 9693686 */
376: CURSOR c_get_old_complete_flag (p_customer_trx_id ra_customer_trx_all.customer_trx_id%type) IS
377: SELECT complete_flag
378: FROM ra_customer_trx_all
379: WHERE customer_trx_id = p_customer_trx_id;
380: /* end of change, manishri, 07-Jun-2010. Bug 9693686 */
381:
382: l_trx_date DATE;