[Home] [Help]
287: -- Figure out currency stuff.
288:
289: l_stmt_num := 20;
290:
291: /* The following query will be made to refer to cst_organization_definitions
292: as an impact of the HR-PROFILE option */
293:
294: select set_of_books_id,
295: operating_unit
295: operating_unit
296: into l_sob_id,
297: l_operating_unit
298: /*from org_organization_definitions */
299: from cst_organization_definitions
300: where organization_id = i_org_id;
301:
302: l_stmt_num := 30;
303:
6082: null,ROUND((nvl(sum(actual_cost),0)*abs(i_p_qty)),c1.precision)/abs(i_p_qty),
6083: (ROUND((nvl(sum(actual_cost),0)*abs(i_p_qty))/c1.minimum_accountable_unit)*c1.minimum_accountable_unit)/abs(i_p_qty))
6084: into l_ce_round_cost
6085: from mtl_cst_actual_cost_details cacd,
6086: cst_organization_definitions cod,
6087: fnd_currencies c1,
6088: gl_sets_of_books gsb
6089: where cacd.transaction_id = i_txn_id
6090: and cacd.organization_id = i_org_id
6634:
6635: FND_FILE.put_line(FND_FILE.log,'l_ussgl_tc : '||l_ussgl_tc);
6636:
6637:
6638: /* The following select statement will be made to refer to cst_organization_definitions as an impact of the HR-PROFILE option */
6639: l_stmt_num := 5;
6640: if (i_act_flag = 0) then
6641: SELECT NVL(operating_unit,-1)
6642: INTO l_operating_unit
6640: if (i_act_flag = 0) then
6641: SELECT NVL(operating_unit,-1)
6642: INTO l_operating_unit
6643: /*FROM org_organization_definitions */
6644: FROM cst_organization_definitions
6645: WHERE organization_id = i_org_id;
6646:
6647: l_stmt_num := 6;
6648: SELECT REQ_ENCUMBRANCE_TYPE_ID,PURCH_ENCUMBRANCE_TYPE_ID
7305: +----------------------------------------------------------------------*/
7306: l_stmt_num := 140;
7307: select cod.set_of_books_id, sob.currency_code
7308: INTO sob_id, pri_curr
7309: FROM cst_organization_definitions cod, gl_sets_of_books sob
7310: WHERE cod.organization_id = org_id
7311: AND sob.set_of_books_id = cod.set_of_books_id;
7312:
7313: