DBA Data[Home] [Help]

APPS.PN_INDEX_LEASE_COMMON_PKG dependencies on PN_LEASE_DETAILS_ALL

Line 466: pn_leases_all leases, pn_lease_details_all lease_det

462: AS
463: CURSOR c IS
464: SELECT index_leases.commencement_date, lease_det.lease_termination_date
465: FROM pn_index_lease_periods_all periods, pn_index_leases_all index_leases,
466: pn_leases_all leases, pn_lease_details_all lease_det
467: WHERE periods.index_period_id = p_index_period_id
468: AND index_leases.index_lease_id = periods.index_lease_id
469: AND index_leases.lease_id = leases.lease_id
470: AND leases.lease_id = lease_det.lease_id