DBA Data[Home] [Help]

APPS.JAI_RETRO_PRC_PKG dependencies on GL_PERIODS

Line 940: lv_period_name gl_periods.period_name%TYPE;

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

Line 1181: , gl_periods gd

1177: SELECT gd.period_name
1178: INTO lv_period_name
1179: FROM
1180: gl_ledgers gle
1181: , gl_periods gd
1182: WHERE gle.ledger_id = func_curr_det_rec.ledger_id
1183: AND gd.period_set_name = gle.period_set_name
1184: -- AND SYSDATE BETWEEN gd.start_date AND gd.end_date bug #6788048
1185: --eric changed on Feb 1, 2008 for bug #6788048 begin