APPS.PN_INDEX_RENT_PERIODS_PKG dependencies on PN_DISTRIBUTIONS_ALL

Line 401: DELETE FROM pn_distributions_all

397: -- terms that are not of status 'APPROVED'
398: --
399: IF p_ignore_approved_terms = 'Y' THEN
400: --DBMS_OUTPUT.put_line ('deleting only non-approved payment terms...');
401: DELETE FROM pn_distributions_all
402: WHERE payment_term_id IN
403: (SELECT payment_term_id
404: FROM pn_payment_terms_all
405: WHERE payment_term_id = il_rec.payment_term_id

Line 458: DELETE FROM pn_distributions_all

454:
455:
456:
457:
458: DELETE FROM pn_distributions_all
459: WHERE payment_term_id = il_rec.payment_term_id;
460:
461:
462: DELETE FROM pn_payment_terms_all

Line 474: DELETE FROM pn_distributions_all

470:
471: DELETE FROM pn_payment_terms_all
472: WHERE payment_term_id = il_rec.payment_term_id;
473:
474: DELETE FROM pn_distributions_all
475: WHERE payment_term_id = il_rec.payment_term_id;
476:
477: DELETE FROM pn_index_lease_terms_all
478: WHERE rent_increase_term_id = il_rec.payment_term_id;

Line 1160: DELETE FROM pn_distributions_all

1156: AND NOT EXISTS( SELECT payment_schedule_id
1157: FROM pn_payment_items_all item
1158: WHERE item.payment_schedule_id = sched.payment_schedule_id);
1159:
1160: DELETE FROM pn_distributions_all
1161: WHERE payment_term_id IN (SELECT payment_term_id
1162: FROM pn_payment_terms_all term,pn_index_lease_periods_all period
1163: WHERE term.index_period_id = period.index_period_id
1164: AND period.index_lease_id = p_index_lease_id);

Line 2900: DELETE pn_distributions_all

2896:
2897: DELETE pn_payment_items_all
2898: WHERE payment_term_id = l_payment_term_rec.payment_term_id;
2899:
2900: DELETE pn_distributions_all
2901: WHERE payment_term_id = l_payment_term_rec.payment_term_id;
2902:
2903: DELETE pn_payment_terms_all
2904: WHERE payment_term_id = l_payment_term_rec.payment_term_id;