APPS.CSTPAPBR dependencies on GL_SETS_OF_BOOKS

Line 648: from gl_sets_of_books

644: -- ---------------------------------
645: l_stmt_num := 10;
646: select currency_code
647: into l_curr_rec.pri_currency
648: from gl_sets_of_books
649: where set_of_books_id = i_ae_txn_rec.set_of_books_id;
650:
651: /* Changes for INVCONV Bug 5337465 */
652: IF (i_ae_txn_rec.txn_action_id in (3,12,21,15,22)) THEN /* Direct and Intransit Transfers */

Line 8487: from gl_sets_of_books

8483:
8484: l_stmt_num := 10;
8485: select currency_code
8486: into l_ae_curr_rec.pri_currency
8487: from gl_sets_of_books
8488: where set_of_books_id = i_ae_txn_rec.set_of_books_id;
8489:
8490: l_ae_curr_rec.alt_currency := i_ae_txn_rec.currency_code;
8491: l_ae_curr_rec.currency_conv_date := i_ae_txn_rec.currency_conv_date;

Line 9403: l_snd_curr GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;

9399: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
9400: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type) RETURN NUMBER
9401: IS
9402: l_snd_sob_id NUMBER;
9403: l_snd_curr GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;
9404: l_rcv_sob_id NUMBER;
9405: l_rcv_coa_id NUMBER;
9406: l_rcv_curr GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;
9407: l_curr_type MTL_MATERIAL_TRANSACTIONS.CURRENCY_CONVERSION_TYPE%TYPE;

Line 9406: l_rcv_curr GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;

9402: l_snd_sob_id NUMBER;
9403: l_snd_curr GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;
9404: l_rcv_sob_id NUMBER;
9405: l_rcv_coa_id NUMBER;
9406: l_rcv_curr GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;
9407: l_curr_type MTL_MATERIAL_TRANSACTIONS.CURRENCY_CONVERSION_TYPE%TYPE;
9408: l_conv_rate NUMBER;
9409: l_conv_date DATE;
9410: l_err_rec CSTPALTY.cst_ae_err_rec_type;

Line 9515: FROM gl_sets_of_books

9511:
9512: l_stmt_num := 20;
9513: SELECT chart_of_accounts_id
9514: INTO l_rcv_coa_id
9515: FROM gl_sets_of_books
9516: WHERE set_of_books_id = l_rcv_sob_id;
9517:
9518: l_stmt_num := 30;
9519: SELECT to_number(org_information3)