APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on GL_SETS_OF_BOOKS

Line 110: v_currency_code gl_sets_of_books.currency_code%type;

106: Select organization_id, location_id, update_rg_flag
107: From JAI_AR_TRXS
108: Where customer_trx_id= pr_new.previous_customer_trx_id;
109:
110: v_currency_code gl_sets_of_books.currency_code%type;
111: CURSOR curr(c_sob NUMBER) IS
112: SELECT currency_code
113: FROM gl_sets_of_books
114: WHERE set_of_books_id = c_sob;

Line 113: FROM gl_sets_of_books

109:
110: v_currency_code gl_sets_of_books.currency_code%type;
111: CURSOR curr(c_sob NUMBER) IS
112: SELECT currency_code
113: FROM gl_sets_of_books
114: WHERE set_of_books_id = c_sob;
115: V_CURR CURR%ROWTYPE; --2002/03/11 Vijay
116: BEGIN
117: pv_return_code := jai_constants.successful ;

Line 533: v_currency_code gl_sets_of_books.currency_code%type;

529: From RA_CUST_TRX_TYPES_ALL
530: Where cust_trx_type_id = pr_new.cust_trx_type_id
531: And NVL(org_id,0) = NVL(pr_new.org_id,0);
532:
533: v_currency_code gl_sets_of_books.currency_code%type;
534: BEGIN
535: pv_return_code := jai_constants.successful ;
536: /*------------------------------------------------------------------------------------------
537: FILENAME:JA_IN_TRX_HDR_UPDATE_TRG.sql