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 */
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;