DBA Data[Home] [Help]

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 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 648: pn_lease_details_all lease_det,

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,
652: pn_index_leases_all ilease,