DBA Data[Home] [Help]

APPS.CSTPACDP dependencies on GL_SETS_OF_BOOKS

Line 338: from gl_sets_of_books

334: l_stmt_num := 30;
335:
336: select currency_code
337: into l_pri_curr
338: from gl_sets_of_books
339: where set_of_books_id = l_sob_id;
340:
341: if (l_alt_curr is not NULL and l_conv_rate = -1) then
342: if (l_alt_curr <> l_pri_curr) then

Line 624: gl_sets_of_books gsb

620: INTO l_purch_encum_flag,
621: l_pri_curr
622: FROM FINANCIALS_SYSTEM_PARAMS_ALL FSP,
623: cst_organization_definitions cod,
624: gl_sets_of_books gsb
625: WHERE fsp.set_of_books_id = cod.set_of_books_id
626: and fsp.org_id= cod.operating_unit
627: and cod.organization_id = l_enc_org_id
628: and gsb.set_of_books_id = cod.set_of_books_id ;

Line 6183: gl_sets_of_books gsb

6179: into l_ce_round_cost
6180: from mtl_cst_actual_cost_details cacd,
6181: cst_organization_definitions cod,
6182: fnd_currencies c1,
6183: gl_sets_of_books gsb
6184: where cacd.transaction_id = i_txn_id
6185: and cacd.organization_id = i_org_id
6186: and c1.currency_code = gsb.currency_code
6187: and gsb.set_of_books_id = cod.set_of_books_id

Line 7508: FROM cst_organization_definitions cod, gl_sets_of_books sob

7504: +----------------------------------------------------------------------*/
7505: l_stmt_num := 140;
7506: select cod.set_of_books_id, sob.currency_code
7507: INTO sob_id, pri_curr
7508: FROM cst_organization_definitions cod, gl_sets_of_books sob
7509: WHERE cod.organization_id = org_id
7510: AND sob.set_of_books_id = cod.set_of_books_id;
7511:
7512: