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 965: from gl_sets_of_books

961:
962:
963: select currency_code
964: into l_curr_rec.pri_currency
965: from gl_sets_of_books
966: where set_of_books_id = i_ae_txn_rec.set_of_books_id;
967:
968: l_curr_rec.alt_currency := i_ae_txn_rec.currency_code;
969: l_curr_rec.currency_conv_date := i_ae_txn_rec.currency_conv_date;

Line 2673: gl_sets_of_books

2669: currency_code
2670: into
2671: l_curr_rec.pri_currency
2672: from
2673: gl_sets_of_books
2674: where
2675: set_of_books_id = p_ae_txn_rec.set_of_books_id;
2676:
2677: l_stmt_num := 20;

Line 2895: gl_sets_of_books

2891: currency_code
2892: into
2893: l_curr_rec.pri_currency
2894: from
2895: gl_sets_of_books
2896: where
2897: set_of_books_id = p_ae_txn_rec.set_of_books_id;
2898:
2899: l_stmt_num := 20;

Line 3093: from gl_sets_of_books

3089: l_stmt_num := 10;
3090:
3091: select currency_code
3092: into l_curr_rec.pri_currency
3093: from gl_sets_of_books
3094: where set_of_books_id = i_ae_txn_rec.set_of_books_id;
3095:
3096: l_curr_rec.alt_currency := i_ae_txn_rec.currency_code;
3097: l_curr_rec.currency_conv_date := i_ae_txn_rec.currency_conv_date;

Line 3477: GL_SETS_OF_BOOKS SOB

3473: FROM
3474: GL_PERIOD_STATUSES ACR,
3475: GL_PERIOD_TYPES GLPT,
3476: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
3477: GL_SETS_OF_BOOKS SOB
3478: WHERE
3479: GLPT.period_type = ACR.period_type AND
3480: ACR.application_id = l_application_id AND
3481: ACR.set_of_books_id = i_set_of_books_id AND