DBA Data[Home] [Help]

APPS.PN_VAR_RENT_CALC_PKG dependencies on PN_INDEX_LEASE_TERMS_ALL

Line 9515: FROM pn_index_lease_terms_all pilt,

9511: -- Get the rent increase terms for a payment term of a particular invoice
9512: CURSOR get_rent_incr_cur(p_term_id IN NUMBER,p_inv_id IN NUMBER) IS
9513:
9514: SELECT ppt.payment_term_id rent_incr_term_id
9515: FROM pn_index_lease_terms_all pilt,
9516: pn_payment_terms_all ppt ,
9517: pn_index_leases_all pil,
9518: pn_var_rent_inv_all vinv
9519: WHERE pilt.index_lease_id = pil.index_lease_id

Line 9642: FROM pn_index_lease_terms_all pilt,

9638: -- Get the rent increase terms for a payment term of a particular invoice
9639: CURSOR get_rent_incr_cur(p_term_id IN NUMBER,p_inv_id IN NUMBER) IS
9640:
9641: SELECT ppt.payment_term_id rent_incr_term_id
9642: FROM pn_index_lease_terms_all pilt,
9643: pn_payment_terms_all ppt ,
9644: pn_index_leases_all pil,
9645: pn_var_rent_inv_all vinv
9646: WHERE pilt.index_lease_id = pil.index_lease_id