APPS.PN_VAR_RENT_PKG dependencies on PN_VAR_RENT_SUMM

Line 2670: | 14-JUL-05 hareesha o Bug 4284035 - Replaced PN_VAR_RENT_SUMM with _ALL tbl.

2666: | MODIFICATION HISTORY
2667: |
2668: | 03-SEP-01 Daniel o Created
2669: | 27-DEC-01 Daniel o included parameter p_term_date for contraction.
2670: | 14-JUL-05 hareesha o Bug 4284035 - Replaced PN_VAR_RENT_SUMM with _ALL tbl.
2671: | 11-JAN-07 Pseeram o Added the call delete_report_date_row to delete
2672: | report dates records after undo periods.
2673: | 09-FEB-07 Lokesh o Bug # 5874461, Added NVL for export_to_ar_flag
2674: +=============================================================================*/

Line 2726: DELETE FROM pn_var_rent_summ

2722: AND NVL(export_to_ar_flag,'N') <>'Y' ;
2723:
2724: ---Mac Trac Issue M30106 ends here -----
2725:
2726: DELETE FROM pn_var_rent_summ
2727: WHERE var_rent_id = p_var_rent_id;
2728:
2729: IF SQL%NOTFOUND THEN
2730: NULL;

Line 3585: DELETE FROM pn_var_rent_summ

3581: )
3582: )
3583: AND payment_status_lookup_code <>'APPROVED';
3584:
3585: DELETE FROM pn_var_rent_summ
3586: WHERE var_rent_id = p_var_rent_id;
3587:
3588: IF SQL%NOTFOUND THEN
3589: NULL;

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: