APPS.CSTPAPBR dependencies on GL_SETS_OF_BOOKS

Line 623: from gl_sets_of_books

619: -- ---------------------------------
620: l_stmt_num := 10;
621: select currency_code
622: into l_curr_rec.pri_currency
623: from gl_sets_of_books
624: where set_of_books_id = i_ae_txn_rec.set_of_books_id;
625:
626: /* Changes for INVCONV Bug 5337465 */
627: IF (i_ae_txn_rec.txn_action_id in (3,12,21,15,22)) THEN /* Direct and Intransit Transfers */

Line 8101: from gl_sets_of_books

8097:
8098: l_stmt_num := 10;
8099: select currency_code
8100: into l_ae_curr_rec.pri_currency
8101: from gl_sets_of_books
8102: where set_of_books_id = i_ae_txn_rec.set_of_books_id;
8103:
8104: l_ae_curr_rec.alt_currency := i_ae_txn_rec.currency_code;
8105: l_ae_curr_rec.currency_conv_date := i_ae_txn_rec.currency_conv_date;

Line 8962: l_snd_curr GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;

8958: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
8959: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type) RETURN NUMBER
8960: IS
8961: l_snd_sob_id NUMBER;
8962: l_snd_curr GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;
8963: l_rcv_sob_id NUMBER;
8964: l_rcv_coa_id NUMBER;
8965: l_rcv_curr GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;
8966: l_curr_type MTL_MATERIAL_TRANSACTIONS.CURRENCY_CONVERSION_TYPE%TYPE;

Line 8965: l_rcv_curr GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;

8961: l_snd_sob_id NUMBER;
8962: l_snd_curr GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;
8963: l_rcv_sob_id NUMBER;
8964: l_rcv_coa_id NUMBER;
8965: l_rcv_curr GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;
8966: l_curr_type MTL_MATERIAL_TRANSACTIONS.CURRENCY_CONVERSION_TYPE%TYPE;
8967: l_conv_rate NUMBER;
8968: l_conv_date DATE;
8969: l_err_rec CSTPALTY.cst_ae_err_rec_type;

Line 9074: FROM gl_sets_of_books

9070:
9071: l_stmt_num := 20;
9072: SELECT chart_of_accounts_id
9073: INTO l_rcv_coa_id
9074: FROM gl_sets_of_books
9075: WHERE set_of_books_id = l_rcv_sob_id;
9076:
9077: l_stmt_num := 30;
9078: SELECT to_number(org_information3)