APPS.PN_SCHEDULES_ITEMS dependencies on PN_LEASE_DETAILS_ALL

Line 3306: pn_lease_details_all pld

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:
3310: BEGIN

Line 3517: pn_lease_details_all pld

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:
3521: BEGIN

Line 3804: pn_lease_details_all pld

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:
3808: CURSOR get_ext_dt IS

Line 3812: pn_lease_details_all pld

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:
3816:

Line 3822: pn_lease_details_all pld

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:
3826: CURSOR get_main_lease_terms_to_expand( p_old_lease_end_date DATE) IS

Line 3844: FROM pn_lease_details_all details,

3840: details.lease_commencement_date lease_comm_date,
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

Line 4779: -- tables pn_lease_details_all and pn_leases_all

4775: ------------------------------------------------------------------------
4776: -- FUNCTION :- GET_LEASE_CHANGE_ID
4777: -- 23-SEP-2002 graghuna o created
4778: -- 10-DEC-2002 graghuna o Modified Cursor lease_dt_hist_cursor. Union to
4779: -- tables pn_lease_details_all and pn_leases_all
4780: -- for Month-to-Month Re-Normalization issue. --MTM-I
4781: ------------------------------------------------------------------------
4782: FUNCTION Get_Lease_Change_Id (p_lease_id IN NUMBER)
4783: RETURN NUMBER

Line 4795: FROM pn_leases_all a, pn_lease_details_all b

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
4796: WHERE a.lease_id = b.lease_id
4797: AND a.lease_id = p_lease_id
4798: ORDER BY 1 DESC;
4799:

Line 5578: pn_lease_details_all pld

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:
5582: INVALID_SCHD_DATE EXCEPTION;

Line 6788: pn_lease_details_all pld

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:
6792: -- retrieves the approved schedule for a payment term for a lease

Line 7025: pn_lease_details_all pld

7021: pl.lease_class_code,
7022: pl.lease_num,
7023: pl.name
7024: FROM pn_leases_all pl,
7025: pn_lease_details_all pld
7026: WHERE pl.lease_id = p_lease_id
7027: AND pld.lease_id = pl.lease_id;
7028:
7029: CURSOR var_cur(p1_lease_id IN NUMBER)

Line 7058: FROM pn_lease_details_all details,

7054: SELECT det_history.lease_status lease_status_old,
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