APPS.PN_MTM_ROLLFORWARD_PKG dependencies on PN_LEASE_DETAILS_ALL

Line 95: pn_lease_details_all det

91: lease.status status,
92: det.lease_extension_end_date lease_extension_end_date,
93: det.lease_change_id lease_change_id
94: FROM pn_leases_all lease,
95: pn_lease_details_all det
96: WHERE lease.lease_id = det.lease_id ';
97:
98: Q_lease_details := Q_lease_details || l_where_clause;
99:

Line 294: FROM pn_leases_all lease,pn_lease_details_all det

290: attribute12,
291: attribute13,
292: attribute14,
293: attribute15
294: FROM pn_leases_all lease,pn_lease_details_all det
295: WHERE lease.lease_id = p_lease_id
296: AND det.lease_id = lease.lease_id;
297:
298: l_rowid VARCHAR2(18) := NULL;

Line 482: FROM pn_tenancies_all pta, pn_lease_details_all plda

478: SELECT pta.tenancy_id,
479: pta.location_id,
480: NVL(pta.occupancy_date,pta.estimated_occupancy_date) st_date,
481: pta.org_id
482: FROM pn_tenancies_all pta, pn_lease_details_all plda
483: WHERE pta.lease_id = p_lease_id
484: AND pta.lease_id = plda.lease_id
485: AND pta.expiration_date = NVL(p_old_ext_end_dt, plda.lease_termination_date);
486:

Line 701: pn_lease_details_all lease_det,

697: NULL charge,
698: ilease.index_lease_number index_rent_num,
699: var.rent_num var_rent_num
700: FROM pn_leases_all lease,
701: pn_lease_details_all lease_det,
702: pn_tenancies_all ten,
703: pn_locations_all loc,
704: pn_properties_all prop,
705: pn_index_leases_all ilease,