APPS.PN_VAR_RENT_PKG dependencies on PN_VAR_RENT_SUMM_ALL

Line 5206: DELETE FROM pn_var_rent_summ_all

5202: pn_var_bkpts_head_pkg.delete_row(l_bkpt_header_id);
5203:
5204: END LOOP;
5205:
5206: DELETE FROM pn_var_rent_summ_all
5207: WHERE var_rent_id = p_var_rent_id;
5208:
5209: IF SQL%NOTFOUND THEN
5210: NULL;

Line 7885: DELETE pn_var_rent_summ_all

7881: AND period_id IN (SELECT period_id
7882: FROM pn_var_periods_all
7883: WHERE var_rent_id = p_var_rent_id);
7884:
7885: DELETE pn_var_rent_summ_all
7886: WHERE grp_date_id IN (SELECT grp_date_id
7887: FROM pn_var_grp_dates_all
7888: WHERE var_rent_id = p_var_rent_id
7889: AND grp_start_date > p_new_termn_date);

Line 8790: DELETE pn_var_rent_summ_all

8786: WHERE period_id IN (SELECT period_id
8787: FROM pn_var_periods_all
8788: WHERE var_rent_id = p_var_rent_id);
8789:
8790: DELETE pn_var_rent_summ_all
8791: WHERE grp_date_id IN (SELECT grp_date_id
8792: FROM pn_var_grp_dates_all
8793: WHERE var_rent_id = p_var_rent_id);
8794: