APPS.PN_INDEX_AMOUNT_PKG dependencies on PN_INDEX_LEASE_TERMS_ALL

Line 2842: FROM pn_index_lease_terms_all

2838: l_index_lease_term_id pn_index_lease_terms.index_lease_term_id%type;
2839:
2840: cursor cur_total_inter_term ( ip_payment_term_id NUMBER) IS
2841: SELECT SUM(amount) total_inter_term
2842: FROM pn_index_lease_terms_all
2843: WHERE index_period_id = ip_index_period_id
2844: AND lease_term_id = ip_payment_term_id
2845: AND index_term_indicator = ip_index_term_indicator;
2846:

Line 6230: /* Delete from the Intermediate table PN_INDEX_LEASE_TERMS_ALL */

6226:
6227: END IF; -- v_uncontrained_index_amount
6228:
6229:
6230: /* Delete from the Intermediate table PN_INDEX_LEASE_TERMS_ALL */
6231:
6232:
6233: DELETE FROM pn_index_lease_terms_all ilt
6234: WHERE ilt.index_period_id = c_rec.index_period_id

Line 6233: DELETE FROM pn_index_lease_terms_all ilt

6229:
6230: /* Delete from the Intermediate table PN_INDEX_LEASE_TERMS_ALL */
6231:
6232:
6233: DELETE FROM pn_index_lease_terms_all ilt
6234: WHERE ilt.index_period_id = c_rec.index_period_id
6235: AND ilt.approved_flag <> c_payment_term_status_approved ;
6236:
6237: DELETE FROM pn_distributions_all

Line 7140: UPDATE pn_index_lease_terms_all

7136:
7137: --
7138: -- update status of records in pn_index_lease_terms
7139: --
7140: UPDATE pn_index_lease_terms_all
7141: SET APPROVED_FLAG = c_payment_term_status_approved
7142: ,last_update_date = SYSDATE
7143: ,last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)
7144: WHERE rent_increase_term_id = ip_index_pay_term_id;