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 452: FROM pn_lease_changes_all

448: lp_payment_item_id NUMBER := 0;
449:
450: CURSOR get_lease_change_id (p_lease_id Number) IS
451: SELECT max(lease_change_id)
452: FROM pn_lease_changes_all
453: WHERE lease_id = p_lease_id;
454:
455: CURSOR lease_change(p_lease_change_id NUMBER) IS
456: SELECT change_commencement_date

Line 457: FROM pn_lease_changes_all

453: WHERE lease_id = p_lease_id;
454:
455: CURSOR lease_change(p_lease_change_id NUMBER) IS
456: SELECT change_commencement_date
457: FROM pn_lease_changes_all
458: WHERE lease_change_id = p_lease_change_id;
459:
460: --Fix for bug#14143342
461: CURSOR leave_alone_amt(p_lease_id Number) IS

Line 2043: -- from latest record in pn_lease_changes_all.

2039: -- 18-SEP-08 jsundara o Bug#6825797. Modified procedure to exclude amount that belong
2040: -- to schedules in APPROVED or ON_HOLD status while determining
2041: -- left alone amount.
2042: -- 18-MAR-10 acprakas o Bug#9457825. Modified code to take amendment comm date
2043: -- from latest record in pn_lease_changes_all.
2044: -- 08-APR-20 acprakas o Bug#9555190. Modified to consider the schedule for which
2045: -- normalized item need to be created to check for the existence of
2046: -- cash item
2047: -- 13-APR-2011 acprakas o Bug#11887881. Modified to consider norm_start_date in case of ADEDIT

Line 2179: FROM pn_lease_changes_all

2175: SELECT change_commencement_date
2176: INTO l_amd_comn_date
2177: FROM
2178: (SELECT *
2179: FROM pn_lease_changes_all
2180: WHERE lease_id = p_lease_id
2181: ORDER BY lease_change_id DESC)
2182: WHERE rownum < 2;
2183:

Line 4647: pn_lease_changes_all changes,

4643: det_history.lease_extension_end_date lease_ext_end_date,
4644: changes.change_commencement_date amd_comm_date
4645: FROM pn_lease_details_all details,
4646: pn_lease_details_history det_history,
4647: pn_lease_changes_all changes,
4648: pn_leases_all lease
4649: WHERE details.lease_id = p_lease_id
4650: AND det_history.lease_id = p_lease_id
4651: AND changes.lease_id = p_lease_id

Line 7546: FROM pn_lease_changes_all

7542: SELECT change_commencement_date
7543: INTO l_amd_comn_date
7544: FROM
7545: (SELECT *
7546: FROM pn_lease_changes_all
7547: WHERE lease_id = p_lease_id
7548: ORDER BY lease_change_id DESC)
7549: WHERE rownum < 2;
7550: