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_LEASES_ALL

Line 554: pn_leases_all c

550: sum(decode(payment_item_type_lookup_code,'CASH',b.export_currency_amount,0)) -
551: sum(decode(payment_item_type_lookup_code,'NORMALIZED',b.export_currency_amount,0)) diff_exp_amt
552: FROM pn_payment_terms_all a,
553: pn_payment_items_all b,
554: pn_leases_all c
555: WHERE a.payment_term_id = b.payment_term_id
556: AND a.normalize = 'Y'
557: AND a.lease_id = c.lease_id
558: AND c.lease_id = p_lease_id

Line 857: l_cal_yr_st VARCHAR2(5); --Definition need to be changed to anchor on new column to be added in pn_leases_all

853: l_first_draft_sch DATE;
854: l_last_app_sch DATE;
855: l_comm_dt DATE;
856: -- Bug 7570052
857: l_cal_yr_st VARCHAR2(5); --Definition need to be changed to anchor on new column to be added in pn_leases_all
858: l_yr_start_dt DATE;
859:
860:
861: CURSOR lst_sch_dt_cur (p_term_id NUMBER)

Line 904: FROM pn_leases_all

900:
901: -- Bug 7570052
902: SELECT cal_start
903: INTO l_cal_yr_st
904: FROM pn_leases_all
905: WHERE lease_id = p_lease_id;
906:
907: IF l_cal_yr_st IS NOT NULL then
908: l_yr_start_dt := to_date(l_cal_yr_st || '-' || to_char(p_term_start_dt,'YYYY'),'DD-MM-YYYY');

Line 1700: FROM pn_leases_all

1696:
1697:
1698: CURSOR org_cur IS
1699: SELECT org_id
1700: FROM pn_leases_all
1701: WHERE lease_id = p_lease_id;
1702:
1703: CURSOR sched_exists(p_payment_term_id NUMBER,p_sch_dt DATE) IS
1704: SELECT sched.payment_schedule_id, payment_status_lookup_code

Line 2896: l_cal_yr_st_dt PN_LEASES_ALL.cal_start%TYPE;

2892: l_tmp_next_cash_duration_dt DATE := null;
2893: l_perv_next_cash_duration_dt DATE := null;
2894:
2895: /* Added for Bug 7570052 */
2896: l_cal_yr_st_dt PN_LEASES_ALL.cal_start%TYPE;
2897: l_non_zero_cash_sch_cnt NUMBER := 0;
2898:
2899: BEGIN
2900:

Line 2939: FROM PN_LEASES_ALL

2935:
2936: -- Bug 7570052
2937: SELECT cal_start
2938: INTO l_cal_yr_st_dt
2939: FROM PN_LEASES_ALL
2940: WHERE LEASE_ID = (select distinct lease_id from pn_payment_terms_all where payment_term_id = p_payment_term_id);
2941:
2942: l_sch_dt := p_sch_dt;
2943: l_sch_day := TO_CHAR(l_sch_dt,'DD');

Line 3538: l_cal_yr_st pn_leases_all.cal_start%TYPE;

3534: l_cash_act_amt pn_payment_items.actual_amount%TYPE;
3535: l_frequency NUMBER;
3536:
3537: -- Bug 7570052
3538: l_cal_yr_st pn_leases_all.cal_start%TYPE;
3539:
3540: --Bug 12364264
3541: l_term_end_date DATE;
3542:

Line 3575: FROM pn_leases_all

3571:
3572: -- Bug 7570052
3573: SELECT cal_start
3574: INTO l_cal_yr_st
3575: FROM pn_leases_all
3576: WHERE lease_id = g_lease_id;
3577:
3578: FOR term IN get_terms
3579: LOOP

Line 4648: pn_leases_all lease

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
4651: AND changes.lease_id = p_lease_id
4652: AND lease.lease_id = p_lease_id

Line 5123: FROM pn_leases_all

5119: l_sch_str_dt DATE;
5120:
5121: CURSOR get_lease_status(p_lease_id NUMBER) IS
5122: SELECT lease_status
5123: FROM pn_leases_all
5124: WHERE lease_id = p_lease_id;
5125:
5126: CURSOR get_lof_terms(p_lease_id NUMBER) IS
5127: SELECT ppt.payment_term_id,

Line 5464: l_cal_yr_st pn_leases_all.cal_start%TYPE;

5460: l_norm_str_dt DATE;
5461: l_lease_termination_date DATE;
5462:
5463: -- Bug 7570052
5464: l_cal_yr_st pn_leases_all.cal_start%TYPE;
5465:
5466: CURSOR lst_cash_sch_dt_cur (p_term_id NUMBER,
5467: p_term_end_dt DATE)
5468: IS

Line 5490: FROM pn_leases_all

5486:
5487: -- Bug 7570052
5488: SELECT cal_start
5489: INTO l_cal_yr_st
5490: FROM pn_leases_all
5491: WHERE lease_id = p_lease_id;
5492:
5493: IF g_lease_status = 'ACT' THEN
5494: l_lease_termination_date := g_new_lea_term_dt;

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 6092: l_cal_yr_st_dt PN_LEASES_ALL.cal_start%TYPE;

6088: l_ext_precision NUMBER;
6089: l_min_acct_unit NUMBER;
6090:
6091: -- Bug 7570052
6092: l_cal_yr_st_dt PN_LEASES_ALL.cal_start%TYPE;
6093: l_non_zero_cash_sch_cnt NUMBER := 0;
6094:
6095: BEGIN
6096:

Line 6115: FROM PN_LEASES_ALL

6111:
6112: -- Bug 7570052
6113: SELECT cal_start
6114: INTO l_cal_yr_st_dt
6115: FROM PN_LEASES_ALL
6116: WHERE LEASE_ID = (select distinct lease_id from pn_payment_terms_all where payment_term_id = p_payment_term_rec.payment_term_id);
6117:
6118: get_sch_info(p_lease_context => 'ABS',
6119: p_normalize_flag => 'N',

Line 7976: select lease_status into l_str from pn_leases_all where lease_id = p_lease_id;

7972: END LOOP;
7973:
7974: pnp_debug_pkg.log('MINI RETRO CONTRACTION - MAIN - Contracting Index rent ');
7975:
7976: select lease_status into l_str from pn_leases_all where lease_id = p_lease_id;
7977:
7978: if l_str in ('ACT','TER') then
7979:
7980:

Line 8215: FROM pn_leases_all pl,

8211: pl.lease_status,
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:

Line 8251: pn_leases_all lease

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
8255: AND details.lease_change_id = det_history.new_lease_change_id;