APPS.PN_INDEX_RENT_PERIODS_PKG dependencies on PN_INDEX_LEASE_TERMS_ALL

Line 408: DELETE FROM pn_index_lease_terms_all

404: DELETE FROM pn_payment_terms_all
405: WHERE payment_term_id = il_rec.payment_term_id
406: AND status <> pn_index_amount_pkg.c_payment_term_status_approved;
407:
408: DELETE FROM pn_index_lease_terms_all
409: WHERE rent_increase_term_id = il_rec.payment_term_id
410: AND approved_flag <> pn_index_amount_pkg.c_payment_term_status_approved;
411:
412: ELSIF p_ignore_approved_terms = 'ALL' THEN

Line 460: DELETE FROM pn_index_lease_terms_all

456:
457: DELETE FROM pn_payment_terms_all
458: WHERE payment_term_id = il_rec.payment_term_id;
459:
460: DELETE FROM pn_index_lease_terms_all
461: where rent_increase_term_id = il_rec.payment_term_id;
462: END IF;
463:
464: ELSE

Line 472: DELETE FROM pn_index_lease_terms_all

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;
474: END IF;
475:
476: END LOOP;

Line 1133: DELETE FROM pn_index_lease_terms_all

1129:
1130: DELETE FROM pn_index_exclude_term_all
1131: WHERE index_lease_id = p_index_lease_id ;
1132:
1133: DELETE FROM pn_index_lease_terms_all
1134: WHERE index_lease_id = p_index_lease_id ;
1135:
1136: DELETE FROM pn_index_lease_constraints_all
1137: WHERE index_lease_id = p_index_lease_id ;