DBA Data[Home] [Help]

APPS.PN_VAREN_PVT dependencies on PN_VAR_VOL_HIST_ALL

Line 9910: FROM pn_var_vol_hist_all

9906:
9907: CURSOR c_vol_histexist --(p_chg_cal_var_rent_id number)
9908: IS
9909: SELECT COUNT (*)
9910: FROM pn_var_vol_hist_all
9911: WHERE period_id IN (SELECT period_id
9912: FROM pn_var_periods_all
9913: WHERE var_rent_id = l_chg_cal_var_rent_id);
9914:

Line 10239: DELETE FROM pn_var_vol_hist_all

10235: , 3
10236: );
10237: x_return_status := fnd_api.g_ret_sts_success;
10238:
10239: DELETE FROM pn_var_vol_hist_all
10240: WHERE period_id IN (SELECT period_id
10241: FROM pn_var_periods_all
10242: WHERE var_rent_id = l_varentid);
10243: