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_ALL

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