DBA Data[Home] [Help]

APPS.JAI_RETRO_PRC_PKG dependencies on GL_PERIODS

Line 935: lv_period_name gl_periods.period_name%TYPE;

931: lv_code_path VARCHAR2(500);
932: ln_purchase_price_var_account mtl_parameters.purchase_price_var_account%TYPE;
933: ln_retroprice_adj_account_id rcv_parameters.retroprice_adj_account_id%TYPE;
934: func_curr_det_rec jai_plsql_cache_pkg.func_curr_details;
935: lv_period_name gl_periods.period_name%TYPE;
936: ln_receiving_account_id rcv_parameters.receiving_account_id%TYPE;
937: ln_user_id NUMBER := fnd_global.user_id;
938: lv_procedure_name VARCHAR2(40):='Do_Unclaim';
939: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 1176: , gl_periods gd

1172: SELECT gd.period_name
1173: INTO lv_period_name
1174: FROM
1175: gl_ledgers gle
1176: , gl_periods gd
1177: WHERE gle.ledger_id = func_curr_det_rec.ledger_id
1178: AND gd.period_set_name = gle.period_set_name
1179: -- AND SYSDATE BETWEEN gd.start_date AND gd.end_date bug #6788048
1180: --eric changed on Feb 1, 2008 for bug #6788048 begin