APPS.PN_VAREN_PVT dependencies on PN_VAR_PERIODS_ALL

Line 3348: FROM pn_var_periods_all

3344:
3345: BEGIN
3346: SELECT period_id
3347: INTO l_period_id
3348: FROM pn_var_periods_all
3349: WHERE var_rent_id = p_breakpoint_details_rec_type.var_rent_id
3350: AND start_date <= p_breakpoint_details_rec_type.bkdt_start_date
3351: AND end_date >= p_breakpoint_details_rec_type.bkdt_start_date;
3352:

Line 9912: FROM pn_var_periods_all

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:
9915: -- This sould be changed_var_rent_id
9916: CURSOR c_grp_dates_match

Line 10241: FROM pn_var_periods_all

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:
10244: DELETE FROM pn_var_constraints_all
10245: WHERE period_id IN (SELECT period_id

Line 10246: FROM pn_var_periods_all

10242: WHERE var_rent_id = l_varentid);
10243:
10244: DELETE FROM pn_var_constraints_all
10245: WHERE period_id IN (SELECT period_id
10246: FROM pn_var_periods_all
10247: WHERE var_rent_id = l_varentid);
10248:
10249: DELETE FROM pn_var_bkpts_det_all
10250: WHERE var_rent_id = l_varentid;