APPS.PN_VAR_RENT_PKG dependencies on PN_VAR_RENT_SUMM_ALL

Line 5202: DELETE FROM pn_var_rent_summ_all

5198: pn_var_bkpts_head_pkg.delete_row(l_bkpt_header_id);
5199:
5200: END LOOP;
5201:
5202: DELETE FROM pn_var_rent_summ_all
5203: WHERE var_rent_id = p_var_rent_id;
5204:
5205: IF SQL%NOTFOUND THEN
5206: NULL;

Line 7879: DELETE pn_var_rent_summ_all

7875: AND period_id IN (SELECT period_id
7876: FROM pn_var_periods_all
7877: WHERE var_rent_id = p_var_rent_id);
7878:
7879: DELETE pn_var_rent_summ_all
7880: WHERE grp_date_id IN (SELECT grp_date_id
7881: FROM pn_var_grp_dates_all
7882: WHERE var_rent_id = p_var_rent_id
7883: AND grp_start_date > p_new_termn_date);

Line 8773: DELETE pn_var_rent_summ_all

8769: WHERE period_id IN (SELECT period_id
8770: FROM pn_var_periods_all
8771: WHERE var_rent_id = p_var_rent_id);
8772:
8773: DELETE pn_var_rent_summ_all
8774: WHERE grp_date_id IN (SELECT grp_date_id
8775: FROM pn_var_grp_dates_all
8776: WHERE var_rent_id = p_var_rent_id);
8777: