APPS.JAI_AR_TRX_HEADERS_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;
116: BEGIN
117: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 799: v_currency_code gl_sets_of_books.currency_code%type;

795: From RA_CUST_TRX_TYPES_ALL
796: Where cust_trx_type_id = pr_new.cust_trx_type_id
797: And NVL(org_id, 0) = NVL(pr_new.org_id, 0);
798:
799: v_currency_code gl_sets_of_books.currency_code%type;
800: lv_api_name CONSTANT VARCHAR2(200) := 'UPDATE_TRX_NUMBER';
801: lv_debug_info VARCHAR2(4000);
802: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;
803: t_jai_line_rec_new JAI_AR_TRX_LINES%ROWTYPE;