DBA Data[Home] [Help]

APPS.PN_SCHEDULES_ITEMS dependencies on PN_LEASE_CHANGES_ALL

Line 291: pn_lease_changes_all plc

287: ppt.norm_start_date,
288: plc.change_type_lookup_code,
289: plc.change_commencement_date
290: FROM pn_payment_terms_all ppt,
291: pn_lease_changes_all plc
292: WHERE ppt.lease_id = p_lease_id
293: AND ppt.lease_change_id = plc.lease_change_id
294: AND ppt.index_period_id IS NULL
295: AND ppt.var_rent_inv_id IS NULL

Line 3846: pn_lease_changes_all changes,

3842: det_history.lease_extension_end_date lease_ext_end_date,
3843: changes.change_commencement_date amd_comm_date
3844: FROM pn_lease_details_all details,
3845: pn_lease_details_history det_history,
3846: pn_lease_changes_all changes,
3847: pn_leases_all lease
3848: WHERE details.lease_id = p_lease_id
3849: AND det_history.lease_id = p_lease_id
3850: AND changes.lease_id = p_lease_id