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.

[Home] [Help]

APPS.PN_SCHEDULES_ITEMS dependencies on PN_LEASE_DETAILS

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 2132: pn_lease_details_all where lease_id = p_lease_id ); /* 7149537 */

2128: AND pps.payment_schedule_id = ppi.payment_schedule_id
2129: AND pps.payment_status_lookup_code <> 'DRAFT'
2130: and schedule_date >= first_day(l_amd_comn_date)/*Bug 13474500 */
2131: and schedule_date <= (SELECT lease_termination_date from
2132: pn_lease_details_all where lease_id = p_lease_id ); /* 7149537 */
2133:
2134: CURSOR get_drf_sch(l_norm_sch_dt DATE) IS
2135: select distinct ppi.payment_schedule_id
2136: from pn_payment_items_all ppi

Line 2172: FROM pn_lease_details_all

2168: BEGIN
2169:
2170: SELECT lease_commencement_date
2171: INTO l_lease_commence_dt
2172: FROM pn_lease_details_all
2173: WHERE lease_id=p_lease_id; --13773023
2174:
2175: SELECT change_commencement_date
2176: INTO l_amd_comn_date

Line 2232: pn_lease_details_all where lease_id = p_lease_id ); /* 7149537 */

2228: AND pps.payment_schedule_id = ppi.payment_schedule_id
2229: AND pps.payment_status_lookup_code <> 'DRAFT'
2230: and schedule_date >= FIRST_DAY(l_amd_comn_date)
2231: and schedule_date <= (SELECT lease_termination_date from
2232: pn_lease_details_all where lease_id = p_lease_id ); /* 7149537 */
2233:
2234:
2235: IF l_app_amt IS NOT NULL THEN
2236: pnp_debug_pkg.log('create_normalize_items - l_app_amt :=: '||TO_CHAR(l_app_amt));

Line 4066: l_active_lease_change_id pn_lease_details.lease_change_id%TYPE;

4062:
4063: l_msg VARCHAR2(2000);
4064: l_old_lea_term_dt DATE;
4065: l_norm_str_dt DATE;
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,

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 4071: pn_lease_details_all pld

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

Line 4278: l_active_lease_change_id pn_lease_details.lease_change_id%TYPE;

4274:
4275: l_msg VARCHAR2(2000);
4276: l_old_lea_term_dt DATE;
4277: l_norm_str_dt DATE;
4278: l_active_lease_change_id pn_lease_details.lease_change_id%TYPE;
4279: l_norm_trm_exsts BOOLEAN := FALSE;
4280: l_item_end_dt_tbl pnp_util_func.item_end_dt_tbl_type;
4281: i NUMBER;
4282: l_max_item_end_dt DATE := TO_DATE('01/01/0001', 'MM/DD/YYYY');

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 4290: pn_lease_details_all pld

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:
4294: CURSOR get_drf_sch_date(p_payment_term_id NUMBER) IS

Line 4304: FROM pn_lease_details_all

4300: AND pps.payment_schedule_id = ppi.payment_schedule_id
4301: AND pps.payment_status_lookup_code <> 'DRAFT'
4302: and schedule_date >= pn_schedules_items.FIRST_DAY(l_norm_str_dt)
4303: and schedule_date <= (SELECT lease_termination_date
4304: FROM pn_lease_details_all
4305: WHERE lease_id = p_lease_id);
4306:
4307: BEGIN
4308:

Line 4575: l_old_lea_term_dt pn_lease_details.lease_termination_date%TYPE;

4571: p_extend_ri VARCHAR2,
4572: p_ten_trm_context VARCHAR2 DEFAULT 'N')
4573: IS
4574:
4575: l_old_lea_term_dt pn_lease_details.lease_termination_date%TYPE;
4576: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
4577: l_no_sch NUMBER;
4578: l_freq NUMBER;
4579: l_counter NUMBER;

Line 4584: l_active_lease_change_id pn_lease_details.lease_change_id%TYPE;

4580: l_sch_dt pn_payment_schedules.schedule_date%TYPE;
4581: l_msg VARCHAR2(2000);
4582: l_norm_str_dt DATE := NULL;
4583: l_sch_str_dt DATE;
4584: l_active_lease_change_id pn_lease_details.lease_change_id%TYPE;
4585: l_cutoff_date DATE;
4586: l_ext_dt DATE;
4587: l_old_lease_end_date DATE;
4588: l_payment_term_rec pn_payment_terms_all%ROWTYPE;

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 4605: pn_lease_details_all pld

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

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 4613: pn_lease_details_all pld

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

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 4623: pn_lease_details_all pld

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

Line 4645: FROM pn_lease_details_all details,

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

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 5683: -- tables pn_lease_details_all and pn_leases_all

5679: ------------------------------------------------------------------------
5680: -- FUNCTION :- GET_LEASE_CHANGE_ID
5681: -- 23-SEP-2002 graghuna o created
5682: -- 10-DEC-2002 graghuna o Modified Cursor lease_dt_hist_cursor. Union to
5683: -- tables pn_lease_details_all and pn_leases_all
5684: -- for Month-to-Month Re-Normalization issue. --MTM-I
5685: ------------------------------------------------------------------------
5686: FUNCTION Get_Lease_Change_Id (p_lease_id IN NUMBER)
5687: RETURN NUMBER

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 5699: FROM pn_leases_all a, pn_lease_details_all b

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
5700: WHERE a.lease_id = b.lease_id
5701: AND a.lease_id = p_lease_id
5702: ORDER BY 1 DESC;
5703:

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 6557: pn_lease_details_all pld

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

Line 6566: l_lease_change_id pn_lease_details.lease_change_id%TYPE;

6562: l_lease_term_date_old DATE := NULL;
6563: l_payment_term_start_date DATE := NULL;
6564: l_schd_date DATE := NULL;
6565: l_schd_day NUMBER := NULL;
6566: l_lease_change_id pn_lease_details.lease_change_id%TYPE;
6567: l_rollover_mode VARCHAR2(30) := NULL;
6568: l_freq_code pn_payment_terms_all.frequency_code%TYPE;
6569: l_freq NUMBER;
6570: l_no_of_sch NUMBER;

Line 7496: l_active_lease_change_id pn_lease_details.lease_change_id%TYPE;

7492: l_sch_end_dt DATE;
7493: l_lst_cash_sch_dt DATE;
7494: l_norm_str_dt DATE;
7495: l_lease_termination_date DATE;
7496: l_active_lease_change_id pn_lease_details.lease_change_id%TYPE;
7497: l_payment_schedule_id pn_payment_items_all.payment_schedule_id%TYPE;
7498: l_payment_item_id pn_payment_items_all.payment_item_id%TYPE;
7499: l_payment_status_lookup_code pn_payment_schedules_all.payment_status_lookup_code%TYPE;
7500: l_adjustment VARCHAR2(1);

Line 7538: pn_lease_details_all where lease_id = p_lease_id ); /* 7149537 */

7534: AND pps.payment_schedule_id = ppi.payment_schedule_id
7535: AND pps.payment_status_lookup_code <> 'DRAFT'
7536: and schedule_date >= pn_schedules_items.FIRST_DAY(l_amd_comn_date)
7537: and schedule_date <= (SELECT lease_termination_date from
7538: pn_lease_details_all where lease_id = p_lease_id ); /* 7149537 */
7539:
7540: BEGIN
7541:
7542: SELECT change_commencement_date

Line 7556: FROM pn_lease_details_all

7552: THEN */ -- Bug 14284343
7553:
7554: SELECT lease_commencement_date
7555: INTO l_lease_commence_dt -- Bug 14284343
7556: FROM pn_lease_details_all
7557: WHERE lease_id = p_lease_id;
7558:
7559: /*END IF; */ -- Bug 14284343
7560:

Line 7933: l_active_lease_change_id pn_lease_details.lease_change_id%TYPE;

7929:
7930: l_msg VARCHAR2(2000);
7931: l_old_lea_term_dt DATE;
7932: l_is_norm VARCHAR2(1);
7933: l_active_lease_change_id pn_lease_details.lease_change_id%TYPE;
7934: l_schedule_exists VARCHAR2(1) := 'N';
7935:
7936: l_str varchar2(2000);
7937: l_ch_id number;

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 7945: pn_lease_details_all pld

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

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 7984: pn_lease_details_all pld

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

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 7995: pn_lease_details_all pld

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:
7999: end if;

Line 8216: pn_lease_details_all pld

8212: pl.lease_class_code,
8213: pl.lease_num,
8214: pl.name
8215: FROM pn_leases_all pl,
8216: pn_lease_details_all pld
8217: WHERE pl.lease_id = p_lease_id
8218: AND pld.lease_id = pl.lease_id;
8219:
8220: CURSOR var_cur(p1_lease_id IN NUMBER)

Line 8249: FROM pn_lease_details_all details,

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

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