APPS.PN_SCHEDULES_ITEMS dependencies on PN_LEASE_DETAILS_HISTORY

Line 736: FROM pn_lease_details_history

732: l_act_lease_found BOOLEAN := FALSE;
733:
734: CURSOR lease_dt_hist_cursor IS
735: SELECT lease_change_id, lease_termination_date, lease_status
736: FROM pn_lease_details_history
737: WHERE lease_id = p_lease_id
738: ORDER BY 1 DESC;
739:
740: BEGIN

Line 4070: FROM pn_lease_details_history plh,

4066: l_active_lease_change_id pn_lease_details.lease_change_id%TYPE;
4067:
4068: CURSOR get_old_lea_term_dt IS
4069: SELECT plh.lease_termination_date
4070: FROM pn_lease_details_history plh,
4071: pn_lease_details_all pld
4072: WHERE pld.lease_change_id = plh.new_lease_change_id
4073: AND pld.lease_id = p_lease_id;
4074:

Line 4289: FROM pn_lease_details_history plh,

4285: l_sch_dt_1 DATE;
4286: l_payment_schedule_id pn_payment_items_all.payment_schedule_id%TYPE;
4287: CURSOR get_old_lea_term_dt IS
4288: SELECT plh.lease_termination_date
4289: FROM pn_lease_details_history plh,
4290: pn_lease_details_all pld
4291: WHERE pld.lease_change_id = plh.new_lease_change_id
4292: AND pld.lease_id = p_lease_id;
4293:

Line 4604: FROM pn_lease_details_history plh,

4600: l_first_draft_sch DATE; -- Bug 7184211
4601:
4602: CURSOR get_old_lea_term_dt IS
4603: SELECT plh.lease_termination_date
4604: FROM pn_lease_details_history plh,
4605: pn_lease_details_all pld
4606: WHERE pld.lease_change_id = plh.new_lease_change_id
4607: AND pld.lease_id = p_lease_id;
4608:

Line 4612: FROM pn_lease_details_history plh,

4608:
4609: CURSOR get_ext_dt IS
4610: SELECT NVL(plh.lease_extension_end_date,
4611: plh.lease_termination_date) old_term_dt
4612: FROM pn_lease_details_history plh,
4613: pn_lease_details_all pld
4614: WHERE pld.lease_change_id = plh.new_lease_change_id
4615: AND pld.lease_id = p_lease_id;
4616:

Line 4622: FROM pn_lease_details_history plh,

4618: CURSOR get_old_lease_end_date IS
4619: SELECT GREATEST( NVL(plh.lease_extension_end_date,
4620: plh.lease_termination_date),
4621: plh.lease_termination_date) old_lease_end_date
4622: FROM pn_lease_details_history plh,
4623: pn_lease_details_all pld
4624: WHERE pld.lease_change_id = plh.new_lease_change_id
4625: AND pld.lease_id = p_lease_id;
4626:

Line 4646: pn_lease_details_history det_history,

4642: details.lease_termination_date lease_term_date,
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

Line 5695: FROM pn_lease_details_history

5691: l_act_lease_found BOOLEAN := FALSE;
5692:
5693: CURSOR lease_dt_hist_cursor IS
5694: SELECT lease_change_id, lease_status
5695: FROM pn_lease_details_history
5696: WHERE lease_id = p_lease_id
5697: UNION
5698: SELECT b.lease_change_id, a.lease_status
5699: FROM pn_leases_all a, pn_lease_details_all b

Line 6556: FROM pn_lease_details_history plh,

6552: CURSOR get_lease_details IS
6553: SELECT GREATEST(NVL(plh.lease_extension_end_date, plh.lease_termination_date),
6554: plh.lease_termination_date) lease_term_date_old,
6555: pld.lease_change_id lease_change_id
6556: FROM pn_lease_details_history plh,
6557: pn_lease_details_all pld
6558: WHERE pld.lease_change_id = plh.new_lease_change_id
6559: AND pld.lease_id = p_lease_id;
6560:

Line 7944: FROM pn_lease_details_history plh,

7940: CURSOR get_old_lea_term_dt IS
7941:
7942:
7943: SELECT NVL(plh.lease_termination_date,plh.lease_extension_end_date) lease_termination_date
7944: FROM pn_lease_details_history plh,
7945: pn_lease_details_all pld
7946: WHERE pld.lease_change_id = plh.new_lease_change_id
7947: AND pld.lease_id = p_lease_id;
7948:

Line 7983: FROM pn_lease_details_history plh,

7979:
7980:
7981:
7982: SELECT plh.lease_status into l_sts
7983: FROM pn_lease_details_history plh,
7984: pn_lease_details_all pld
7985: WHERE pld.lease_change_id = plh.new_lease_change_id
7986: AND pld.lease_id = p_lease_id;
7987:

Line 7994: FROM pn_lease_details_history plh,

7990:
7991:
7992: if l_sts in ('MTM','HLD') then
7993: SELECT NVL(plh.lease_extension_end_date,plh.lease_termination_date) into l_old_lea_term_dt
7994: FROM pn_lease_details_history plh,
7995: pn_lease_details_all pld
7996: WHERE pld.lease_change_id = plh.new_lease_change_id
7997: AND pld.lease_id = p_lease_id;
7998:

Line 8250: pn_lease_details_history det_history,

8246: lease.lease_status lease_status_new,
8247: details.lease_termination_date lease_term_date,
8248: det_history.lease_extension_end_date lease_ext_end_date
8249: FROM pn_lease_details_all details,
8250: pn_lease_details_history det_history,
8251: pn_leases_all lease
8252: WHERE details.lease_id = p_lease_id
8253: AND det_history.lease_id = p_lease_id
8254: AND lease.lease_id = p_lease_id