eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_SCHEDULES_ITEMS dependencies on PN_LEASE_DETAILS

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 3301: l_active_lease_change_id pn_lease_details.lease_change_id%TYPE;

3297:
3298: l_msg VARCHAR2(2000);
3299: l_old_lea_term_dt DATE;
3300: l_norm_str_dt DATE;
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,

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 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 3507: l_active_lease_change_id pn_lease_details.lease_change_id%TYPE;

3503:
3504: l_msg VARCHAR2(2000);
3505: l_old_lea_term_dt DATE;
3506: l_norm_str_dt DATE;
3507: l_active_lease_change_id pn_lease_details.lease_change_id%TYPE;
3508: l_norm_trm_exsts BOOLEAN := FALSE;
3509: l_item_end_dt_tbl pnp_util_func.item_end_dt_tbl_type;
3510: i NUMBER;
3511: l_max_item_end_dt DATE := TO_DATE('01/01/0001', 'MM/DD/YYYY');

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 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 3774: l_old_lea_term_dt pn_lease_details.lease_termination_date%TYPE;

3770: p_extend_ri VARCHAR2,
3771: p_ten_trm_context VARCHAR2 DEFAULT 'N')
3772: IS
3773:
3774: l_old_lea_term_dt pn_lease_details.lease_termination_date%TYPE;
3775: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
3776: l_no_sch NUMBER;
3777: l_freq NUMBER;
3778: l_counter NUMBER;

Line 3783: l_active_lease_change_id pn_lease_details.lease_change_id%TYPE;

3779: l_sch_dt pn_payment_schedules.schedule_date%TYPE;
3780: l_msg VARCHAR2(2000);
3781: l_norm_str_dt DATE := NULL;
3782: l_sch_str_dt DATE;
3783: l_active_lease_change_id pn_lease_details.lease_change_id%TYPE;
3784: l_cutoff_date DATE;
3785: l_ext_dt DATE;
3786: l_old_lease_end_date DATE;
3787: l_payment_term_rec pn_payment_terms_all%ROWTYPE;

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 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 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 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 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 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 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 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 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 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 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 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 5587: l_lease_change_id pn_lease_details.lease_change_id%TYPE;

5583: l_lease_term_date_old DATE := NULL;
5584: l_payment_term_start_date DATE := NULL;
5585: l_schd_date DATE := NULL;
5586: l_schd_day NUMBER := NULL;
5587: l_lease_change_id pn_lease_details.lease_change_id%TYPE;
5588: l_rollover_mode VARCHAR2(30) := NULL;
5589: l_freq_code pn_payment_terms_all.frequency_code%TYPE;
5590: l_freq NUMBER;
5591: l_no_of_sch NUMBER;

Line 6501: l_active_lease_change_id pn_lease_details.lease_change_id%TYPE;

6497: l_sch_end_dt DATE;
6498: l_lst_cash_sch_dt DATE;
6499: l_norm_str_dt DATE;
6500: l_lease_termination_date DATE;
6501: l_active_lease_change_id pn_lease_details.lease_change_id%TYPE;
6502: l_payment_schedule_id pn_payment_items_all.payment_schedule_id%TYPE;
6503: l_payment_item_id pn_payment_items_all.payment_item_id%TYPE;
6504: l_payment_status_lookup_code pn_payment_schedules_all.payment_status_lookup_code%TYPE;
6505: l_adjustment VARCHAR2(1);

Line 6781: l_active_lease_change_id pn_lease_details.lease_change_id%TYPE;

6777:
6778: l_msg VARCHAR2(2000);
6779: l_old_lea_term_dt DATE;
6780: l_is_norm VARCHAR2(1);
6781: l_active_lease_change_id pn_lease_details.lease_change_id%TYPE;
6782: l_schedule_exists VARCHAR2(1) := 'N';
6783:
6784: CURSOR get_old_lea_term_dt IS
6785: SELECT NVL(plh.lease_extension_end_date,

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

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