APPS.PN_MTM_ROLLFORWARD_PKG dependencies on PN_LEASES_ALL

Line 94: FROM pn_leases_all lease,

90: lease.lease_status lease_status,
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;

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 489: FROM pn_leases_all

485: AND pta.expiration_date = NVL(p_old_ext_end_dt, plda.lease_termination_date);
486:
487: CURSOR get_lease_class_code (p_lease_id NUMBER) IS
488: SELECT lease_class_code
489: FROM pn_leases_all
490: WHERE lease_id = p_lease_id;
491:
492: CURSOR get_loc_type_code (p_location_id NUMBER) IS
493: SELECT location_type_lookup_code

Line 505: FROM pn_leases_all pnl,

501: IS
502: SELECT 'Y'
503: FROM DUAl
504: WHERE 100 < (SELECT sum(allocated_area_pct)
505: FROM pn_leases_all pnl,
506: pn_tenancies_all ten
507: WHERE pnl.lease_class_code <> 'DIRECT'
508: AND pnl.lease_id = ten.lease_id
509: AND ten.location_id = p_location_id

Line 700: FROM pn_leases_all lease,

696: /*SUM(NVL(terms.estimated_amount,terms.actual_amount))*/
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,