APPS.PN_SCHEDULES_ITEMS dependencies on PN_LEASE_DETAILS_HISTORY

Line 529: FROM pn_lease_details_history

525: l_act_lease_found BOOLEAN := FALSE;
526:
527: CURSOR lease_dt_hist_cursor IS
528: SELECT lease_change_id, lease_termination_date, lease_status
529: FROM pn_lease_details_history
530: WHERE lease_id = p_lease_id
531: ORDER BY 1 DESC;
532:
533: BEGIN

Line 3305: FROM pn_lease_details_history plh,

3301: l_active_lease_change_id pn_lease_details.lease_change_id%TYPE;
3302:
3303: CURSOR get_old_lea_term_dt IS
3304: SELECT plh.lease_termination_date
3305: FROM pn_lease_details_history plh,
3306: pn_lease_details_all pld
3307: WHERE pld.lease_change_id = plh.new_lease_change_id
3308: AND pld.lease_id = p_lease_id;
3309:

Line 3516: FROM pn_lease_details_history plh,

3512: l_ri_end_dt DATE := TO_DATE('01/01/0001', 'MM/DD/YYYY');
3513: l_term_end_dt DATE := NULL;
3514: CURSOR get_old_lea_term_dt IS
3515: SELECT plh.lease_termination_date
3516: FROM pn_lease_details_history plh,
3517: pn_lease_details_all pld
3518: WHERE pld.lease_change_id = plh.new_lease_change_id
3519: AND pld.lease_id = p_lease_id;
3520:

Line 3803: FROM pn_lease_details_history plh,

3799: l_first_draft_sch DATE; -- Bug 7184211
3800:
3801: CURSOR get_old_lea_term_dt IS
3802: SELECT plh.lease_termination_date
3803: FROM pn_lease_details_history plh,
3804: pn_lease_details_all pld
3805: WHERE pld.lease_change_id = plh.new_lease_change_id
3806: AND pld.lease_id = p_lease_id;
3807:

Line 3811: FROM pn_lease_details_history plh,

3807:
3808: CURSOR get_ext_dt IS
3809: SELECT NVL(plh.lease_extension_end_date,
3810: plh.lease_termination_date) old_term_dt
3811: FROM pn_lease_details_history plh,
3812: pn_lease_details_all pld
3813: WHERE pld.lease_change_id = plh.new_lease_change_id
3814: AND pld.lease_id = p_lease_id;
3815:

Line 3821: FROM pn_lease_details_history plh,

3817: CURSOR get_old_lease_end_date IS
3818: SELECT GREATEST( NVL(plh.lease_extension_end_date,
3819: plh.lease_termination_date),
3820: plh.lease_termination_date) old_lease_end_date
3821: FROM pn_lease_details_history plh,
3822: pn_lease_details_all pld
3823: WHERE pld.lease_change_id = plh.new_lease_change_id
3824: AND pld.lease_id = p_lease_id;
3825:

Line 3845: pn_lease_details_history det_history,

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

Line 4791: FROM pn_lease_details_history

4787: l_act_lease_found BOOLEAN := FALSE;
4788:
4789: CURSOR lease_dt_hist_cursor IS
4790: SELECT lease_change_id, lease_status
4791: FROM pn_lease_details_history
4792: WHERE lease_id = p_lease_id
4793: UNION
4794: SELECT b.lease_change_id, a.lease_status
4795: FROM pn_leases_all a, pn_lease_details_all b

Line 5577: FROM pn_lease_details_history plh,

5573: CURSOR get_lease_details IS
5574: SELECT GREATEST(NVL(plh.lease_extension_end_date, plh.lease_termination_date),
5575: plh.lease_termination_date) lease_term_date_old,
5576: pld.lease_change_id lease_change_id
5577: FROM pn_lease_details_history plh,
5578: pn_lease_details_all pld
5579: WHERE pld.lease_change_id = plh.new_lease_change_id
5580: AND pld.lease_id = p_lease_id;
5581:

Line 6787: FROM pn_lease_details_history plh,

6783:
6784: CURSOR get_old_lea_term_dt IS
6785: SELECT NVL(plh.lease_extension_end_date,
6786: plh.lease_termination_date) lease_termination_date
6787: FROM pn_lease_details_history plh,
6788: pn_lease_details_all pld
6789: WHERE pld.lease_change_id = plh.new_lease_change_id
6790: AND pld.lease_id = p_lease_id;
6791:

Line 7059: pn_lease_details_history det_history,

7055: lease.lease_status lease_status_new,
7056: details.lease_termination_date lease_term_date,
7057: det_history.lease_extension_end_date lease_ext_end_date
7058: FROM pn_lease_details_all details,
7059: pn_lease_details_history det_history,
7060: pn_leases_all lease
7061: WHERE details.lease_id = p_lease_id
7062: AND det_history.lease_id = p_lease_id
7063: AND lease.lease_id = p_lease_id