DBA Data[Home] [Help]

APPS.PN_VAR_RENT_CALC_PKG dependencies on PN_INDEX_LEASE_TERMS_ALL

Line 9460: FROM pn_index_lease_terms_all pilt,

9456: -- Get the rent increase terms for a payment term of a particular invoice
9457: CURSOR get_rent_incr_cur(p_term_id IN NUMBER,p_inv_id IN NUMBER) IS
9458:
9459: SELECT ppt.payment_term_id rent_incr_term_id
9460: FROM pn_index_lease_terms_all pilt,
9461: pn_payment_terms_all ppt ,
9462: pn_index_leases_all pil,
9463: pn_var_rent_inv_all vinv
9464: WHERE pilt.index_lease_id = pil.index_lease_id

Line 9587: FROM pn_index_lease_terms_all pilt,

9583: -- Get the rent increase terms for a payment term of a particular invoice
9584: CURSOR get_rent_incr_cur(p_term_id IN NUMBER,p_inv_id IN NUMBER) IS
9585:
9586: SELECT ppt.payment_term_id rent_incr_term_id
9587: FROM pn_index_lease_terms_all pilt,
9588: pn_payment_terms_all ppt ,
9589: pn_index_leases_all pil,
9590: pn_var_rent_inv_all vinv
9591: WHERE pilt.index_lease_id = pil.index_lease_id