APPS.PN_INDEX_RENT_PERIODS_PKG dependencies on PN_INDEX_LEASE_TERMS_ALL

Line 413: DELETE FROM pn_index_lease_terms_all

409: DELETE FROM pn_payment_terms_all
410: WHERE payment_term_id = il_rec.payment_term_id
411: AND status <> pn_index_amount_pkg.c_payment_term_status_approved;
412:
413: DELETE FROM pn_index_lease_terms_all
414: WHERE rent_increase_term_id = il_rec.payment_term_id
415: AND approved_flag <> pn_index_amount_pkg.c_payment_term_status_approved;
416:
417: ELSIF p_ignore_approved_terms = 'ALL' THEN

Line 465: DELETE FROM pn_index_lease_terms_all

461:
462: DELETE FROM pn_payment_terms_all
463: WHERE payment_term_id = il_rec.payment_term_id;
464:
465: DELETE FROM pn_index_lease_terms_all
466: where rent_increase_term_id = il_rec.payment_term_id;
467: END IF;
468:
469: ELSE

Line 477: DELETE FROM pn_index_lease_terms_all

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;
479: END IF;
480:
481: END LOOP;

Line 1141: DELETE FROM pn_index_lease_terms_all

1137:
1138: DELETE FROM pn_index_exclude_term_all
1139: WHERE index_lease_id = p_index_lease_id ;
1140:
1141: DELETE FROM pn_index_lease_terms_all
1142: WHERE index_lease_id = p_index_lease_id ;
1143:
1144: DELETE FROM pn_index_lease_constraints_all
1145: WHERE index_lease_id = p_index_lease_id ;