DBA Data[Home] [Help]

APPS.CSTPAPPR dependencies on GL_SETS_OF_BOOKS

Line 720: from gl_sets_of_books

716:
717:
718: select currency_code
719: into l_curr_rec.pri_currency
720: from gl_sets_of_books
721: where set_of_books_id = i_ae_txn_rec.set_of_books_id;
722: l_curr_rec.alt_currency := i_ae_txn_rec.currency_code;
723: l_curr_rec.currency_conv_date := i_ae_txn_rec.currency_conv_date;
724: l_curr_rec.currency_conv_type := i_ae_txn_rec.currency_conv_type;

Line 967: from gl_sets_of_books

963:
964:
965: select currency_code
966: into l_curr_rec.pri_currency
967: from gl_sets_of_books
968: where set_of_books_id = i_ae_txn_rec.set_of_books_id;
969:
970: /* BUG 9113487 */
971: l_stmt_num := 15;

Line 3033: gl_sets_of_books

3029: currency_code
3030: into
3031: l_curr_rec.pri_currency
3032: from
3033: gl_sets_of_books
3034: where
3035: set_of_books_id = p_ae_txn_rec.set_of_books_id;
3036:
3037: l_stmt_num := 20;

Line 3255: gl_sets_of_books

3251: currency_code
3252: into
3253: l_curr_rec.pri_currency
3254: from
3255: gl_sets_of_books
3256: where
3257: set_of_books_id = p_ae_txn_rec.set_of_books_id;
3258:
3259: l_stmt_num := 20;

Line 3453: from gl_sets_of_books

3449: l_stmt_num := 10;
3450:
3451: select currency_code
3452: into l_curr_rec.pri_currency
3453: from gl_sets_of_books
3454: where set_of_books_id = i_ae_txn_rec.set_of_books_id;
3455:
3456: l_curr_rec.alt_currency := i_ae_txn_rec.currency_code;
3457: l_curr_rec.currency_conv_date := i_ae_txn_rec.currency_conv_date;

Line 3846: GL_SETS_OF_BOOKS SOB

3842: GL_PERIOD_STATUSES ACR,
3843: GL_PERIOD_TYPES GLPT,
3844: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
3845: GL_ENCUMBRANCE_TYPES GET,
3846: GL_SETS_OF_BOOKS SOB
3847: WHERE
3848: GLPT.period_type = ACR.period_type AND
3849: ACR.application_id = l_application_id AND
3850: ACR.set_of_books_id = i_set_of_books_id AND