DBA Data[Home] [Help]

APPS.PN_VAR_RENT_CALC_PKG dependencies on PN_INDEX_LEASES_ALL

Line 9517: pn_index_leases_all pil,

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
9520: AND pil.lease_id = ppt.lease_id
9521: AND pilt.index_period_id = ppt.index_period_id

Line 9644: pn_index_leases_all pil,

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
9647: AND pil.lease_id = ppt.lease_id
9648: AND pilt.index_period_id = ppt.index_period_id