APPS.PN_MTM_ROLLFORWARD_PKG dependencies on PN_TENANCIES_ALL

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 506: pn_tenancies_all ten

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
510: AND NVL(ten.estimated_occupancy_date, ten.occupancy_date)

Line 542: UPDATE pn_tenancies_all

538: EXIT outer_loop;
539: END LOOP;
540: END IF;
541:
542: UPDATE pn_tenancies_all
543: SET expiration_date = p_lease_ext_end_dt
544: ,fin_oblig_end_date = p_lease_ext_end_dt
545: WHERE tenancy_id = rec.tenancy_id;
546:

Line 702: pn_tenancies_all ten,

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,
706: pn_var_rents_all var,