[Home] [Help]
392: -- terms that are not of status 'APPROVED'
393: --
394: IF p_ignore_approved_terms = 'Y' THEN
395: --DBMS_OUTPUT.put_line ('deleting only non-approved payment terms...');
396: DELETE FROM pn_distributions_all
397: WHERE payment_term_id IN
398: (SELECT payment_term_id
399: FROM pn_payment_terms_all
400: WHERE payment_term_id = il_rec.payment_term_id
449:
450:
451:
452:
453: DELETE FROM pn_distributions_all
454: WHERE payment_term_id = il_rec.payment_term_id;
455:
456:
457: DELETE FROM pn_payment_terms_all
465:
466: DELETE FROM pn_payment_terms_all
467: WHERE payment_term_id = il_rec.payment_term_id;
468:
469: DELETE FROM pn_distributions_all
470: WHERE payment_term_id = il_rec.payment_term_id;
471:
472: DELETE FROM pn_index_lease_terms_all
473: WHERE rent_increase_term_id = il_rec.payment_term_id;
1148: AND NOT EXISTS( SELECT payment_schedule_id
1149: FROM pn_payment_items_all item
1150: WHERE item.payment_schedule_id = sched.payment_schedule_id);
1151:
1152: DELETE FROM pn_distributions_all
1153: WHERE payment_term_id IN (SELECT payment_term_id
1154: FROM pn_payment_terms_all term,pn_index_lease_periods_all period
1155: WHERE term.index_period_id = period.index_period_id
1156: AND period.index_lease_id = p_index_lease_id);
2750:
2751: DELETE pn_payment_items_all
2752: WHERE payment_term_id = l_payment_term_rec.payment_term_id;
2753:
2754: DELETE pn_distributions_all
2755: WHERE payment_term_id = l_payment_term_rec.payment_term_id;
2756:
2757: DELETE pn_payment_terms_all
2758: WHERE payment_term_id = l_payment_term_rec.payment_term_id;