APPS.PN_MTM_ROLLFORWARD_PKG dependencies on PN_TENANCIES_ALL

Line 431: FROM pn_tenancies_all

427: SELECT tenancy_id,
428: location_id,
429: NVL(occupancy_date,estimated_occupancy_date) st_date,
430: org_id
431: FROM pn_tenancies_all
432: WHERE lease_id = p_lease_id
433: AND expiration_date < p_lease_ext_end_dt;
434:
435: CURSOR get_lease_class_code (p_lease_id NUMBER) IS

Line 454: pn_tenancies_all ten

450: SELECT 'Y'
451: FROM DUAl
452: WHERE EXISTS (SELECT NULL
453: FROM pn_leases_all pnl,
454: pn_tenancies_all ten
455: WHERE pnl.lease_id <> p_lease_id
456: AND pnl.lease_class_code <> 'DIRECT'
457: AND pnl.lease_id = ten.lease_id
458: AND ten.location_id = p_location_id

Line 491: UPDATE pn_tenancies_all

487: EXIT outer_loop;
488: END LOOP;
489: END IF;
490:
491: UPDATE pn_tenancies_all
492: SET expiration_date = p_lease_ext_end_dt
493: ,fin_oblig_end_date = p_lease_ext_end_dt
494: WHERE tenancy_id = rec.tenancy_id;
495:

Line 649: pn_tenancies_all ten,

645: ilease.index_lease_number index_rent_num,
646: var.rent_num var_rent_num
647: FROM pn_leases_all lease,
648: pn_lease_details_all lease_det,
649: pn_tenancies_all ten,
650: pn_locations_all loc,
651: pn_properties_all prop,
652: pn_index_leases_all ilease,
653: pn_var_rents_all var,