[Home] [Help]
319: -- Figure out currency stuff.
320:
321: l_stmt_num := 20;
322:
323: /* The following query will be made to refer to cst_organization_definitions
324: as an impact of the HR-PROFILE option */
325:
326: select set_of_books_id,
327: operating_unit
327: operating_unit
328: into l_sob_id,
329: l_operating_unit
330: /*from org_organization_definitions */
331: from cst_organization_definitions
332: where organization_id = i_org_id;
333:
334: l_stmt_num := 30;
335:
619: gsb.currency_code
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
6177: null,ROUND((nvl(sum(actual_cost),0)*abs(i_p_qty)),c1.precision)/abs(i_p_qty),
6178: (ROUND((nvl(sum(actual_cost),0)*abs(i_p_qty))/c1.minimum_accountable_unit)*c1.minimum_accountable_unit)/abs(i_p_qty))
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
6757:
6758: FND_FILE.put_line(FND_FILE.log,'l_ussgl_tc : '||l_ussgl_tc);
6759:
6760:
6761: /* The following select statement will be made to refer to cst_organization_definitions as an impact of the HR-PROFILE option */
6762: l_stmt_num := 5;
6763: if (i_act_flag = 0) then
6764: SELECT NVL(operating_unit,-1)
6765: INTO l_operating_unit
6763: if (i_act_flag = 0) then
6764: SELECT NVL(operating_unit,-1)
6765: INTO l_operating_unit
6766: /*FROM org_organization_definitions */
6767: FROM cst_organization_definitions
6768: WHERE organization_id = i_org_id;
6769:
6770: l_stmt_num := 6;
6771: SELECT g1.encumbrance_type_id, g2.encumbrance_type_id
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: