APPS.PN_VAR_RENT_PKG dependencies on PN_VAR_RENT_SUMM

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

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

Line 2722: DELETE FROM pn_var_rent_summ

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

Line 3581: DELETE FROM pn_var_rent_summ

3577: )
3578: )
3579: AND payment_status_lookup_code <>'APPROVED';
3580:
3581: DELETE FROM pn_var_rent_summ
3582: WHERE var_rent_id = p_var_rent_id;
3583:
3584: IF SQL%NOTFOUND THEN
3585: NULL;

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: