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 277: FROM pn_leases_all lease,pn_lease_details_all det

273: grouping_rule_id,
274: lease_commencement_date,
275: lease_termination_date,
276: lease_execution_date
277: FROM pn_leases_all lease,pn_lease_details_all det
278: WHERE lease.lease_id = p_lease_id
279: AND det.lease_id = lease.lease_id;
280:
281: l_rowid VARCHAR2(18) := NULL;

Line 437: FROM pn_leases_all

433: AND expiration_date < p_lease_ext_end_dt;
434:
435: CURSOR get_lease_class_code (p_lease_id NUMBER) IS
436: SELECT lease_class_code
437: FROM pn_leases_all
438: WHERE lease_id = p_lease_id;
439:
440: CURSOR get_loc_type_code (p_location_id NUMBER) IS
441: SELECT location_type_lookup_code

Line 453: FROM pn_leases_all pnl,

449: IS
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

Line 647: FROM pn_leases_all lease,

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