APPS.PN_INDEX_AMOUNT_PKG dependencies on PN_INDEX_LEASE_TERMS_ALL

Line 2843: FROM pn_index_lease_terms_all

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

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

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

Line 6235: DELETE FROM pn_index_lease_terms_all ilt

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

Line 7142: UPDATE pn_index_lease_terms_all

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