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_INDEX_RENT_PERIODS_PKG dependencies on PN_PAYMENT_ITEMS_ALL

Line 357: FROM pn_payment_items_all items,

353: CURSOR exists_approved_schedule( p_payment_term_id IN NUMBER) IS
354: SELECT 'Y'
355: FROM DUAL
356: WHERE EXISTS( SELECT payment_item_id
357: FROM pn_payment_items_all items,
358: pn_payment_schedules_all sched
359: WHERE sched.payment_schedule_id = items.payment_schedule_id
360: AND items.payment_term_id = p_payment_term_id
361: AND sched.payment_status_lookup_code = 'APPROVED');

Line 441: DELETE FROM pn_payment_items_all

437:
438: ELSE
439: BEGIN
440:
441: DELETE FROM pn_payment_items_all
442: WHERE payment_term_id =il_rec.payment_term_id;
443:
444: DELETE FROM pn_payment_schedules_all pps
445: WHERE not exists(SELECT 1

Line 446: FROM PN_PAYMENT_ITEMS_ALL ppi

442: WHERE payment_term_id =il_rec.payment_term_id;
443:
444: DELETE FROM pn_payment_schedules_all pps
445: WHERE not exists(SELECT 1
446: FROM PN_PAYMENT_ITEMS_ALL ppi
447: WHERE ppi.payment_schedule_id=pps.payment_schedule_id)
448: AND pps.lease_id=il_rec.lease_id;
449:
450:

Line 1113: pn_payment_items_all item,

1109: SELECT term.payment_term_id
1110: FROM pn_payment_schedules_all sched,
1111: pn_index_leases_all ilease,
1112: pn_payment_terms_all term,
1113: pn_payment_items_all item,
1114: pn_index_lease_periods_all period
1115: WHERE sched.lease_id = ilease.lease_id
1116: AND sched.payment_schedule_id = item.payment_schedule_id
1117: AND item.payment_term_id = term.payment_term_id

Line 1147: DELETE FROM pn_payment_items_all

1143:
1144: DELETE FROM pn_index_lease_constraints_all
1145: WHERE index_lease_id = p_index_lease_id ;
1146:
1147: DELETE FROM pn_payment_items_all
1148: WHERE payment_term_id IN ( SELECT term.payment_term_id
1149: FROM pn_payment_terms_all term,pn_index_lease_periods_all iperiod
1150: WHERE term.index_period_id = iperiod.index_period_id
1151: AND iperiod.index_lease_id = p_index_lease_id

Line 1157: FROM pn_payment_items_all item

1153:
1154: DELETE FROM pn_payment_schedules_all sched
1155: WHERE sched.payment_status_lookup_code = 'DRAFT'
1156: AND NOT EXISTS( SELECT payment_schedule_id
1157: FROM pn_payment_items_all item
1158: WHERE item.payment_schedule_id = sched.payment_schedule_id);
1159:
1160: DELETE FROM pn_distributions_all
1161: WHERE payment_term_id IN (SELECT payment_term_id

Line 1449: FROM pn_payment_items_all ppi

1445:
1446: CURSOR cur_total_amount(p_payment_term_id IN NUMBER)
1447: IS
1448: SELECT sum(ppi.actual_amount) total_amount
1449: FROM pn_payment_items_all ppi
1450: WHERE ppi.payment_term_id = p_payment_term_id
1451: AND ppi.payment_item_type_lookup_code = 'CASH';
1452:
1453: v_old_num_months NUMBER;

Line 1565: FROM pn_payment_items_all ppt

1561: INTO v_approved_sch
1562: FROM pn_payment_schedules_all pps
1563: WHERE pps.payment_schedule_id IN
1564: (SELECT ppt.payment_schedule_id
1565: FROM pn_payment_items_all ppt
1566: WHERE ppt.payment_term_id = rec_payment_terms.payment_term_id
1567: AND ppt.export_currency_amount <> 0
1568: AND ppt.payment_item_type_lookup_code = 'CASH')
1569: AND pps.payment_status_lookup_code = 'APPROVED'

Line 1591: UPDATE pn_payment_items_all

1587: last_update_login = fnd_global.login_id
1588: WHERE payment_term_id = rec_payment_terms.payment_term_id;
1589:
1590: BEGIN
1591: UPDATE pn_payment_items_all
1592: SET actual_amount = v_new_amount,
1593: export_currency_amount = v_new_amount,
1594: last_update_date = SYSDATE,
1595: last_updated_by = fnd_global.user_id,

Line 1615: UPDATE pn_payment_items_all

1611: last_update_login = fnd_global.login_id
1612: WHERE payment_term_id = rec_payment_terms.payment_term_id;
1613:
1614: BEGIN
1615: UPDATE pn_payment_items_all
1616: SET actual_amount = v_new_amount,
1617: estimated_amount = v_new_amount,
1618: export_currency_amount = v_new_amount,
1619: last_update_date = SYSDATE,

Line 2606: l_payment_item_id pn_payment_items_all.payment_item_id%TYPE;

2602: l_mths NUMBER;
2603: l_appr_sched_exists BOOLEAN := FALSE;
2604: l_sched_tbl pn_retro_adjustment_pkg.payment_item_tbl_type;
2605: l_lease_id NUMBER;
2606: l_payment_item_id pn_payment_items_all.payment_item_id%TYPE;
2607: l_lst_cash_sch_dt DATE;
2608: l_var_rent_id NUMBER;
2609:
2610: CURSOR get_lease_id IS

Line 2659: FROM pn_payment_items_all

2655: FROM pn_payment_terms_all
2656: WHERE payment_term_id = p_payment_term_id)
2657: AND payment_status_lookup_code = 'APPROVED'
2658: AND payment_schedule_id IN (SELECT payment_schedule_id
2659: FROM pn_payment_items_all
2660: WHERE payment_term_id = p_payment_term_id);
2661:
2662: CURSOR total_amt_old_term_cur(p_term_id IN NUMBER) IS
2663: SELECT SUM(ppi.actual_amount) AS total_amount

Line 2664: FROM pn_payment_items_all ppi

2660: WHERE payment_term_id = p_payment_term_id);
2661:
2662: CURSOR total_amt_old_term_cur(p_term_id IN NUMBER) IS
2663: SELECT SUM(ppi.actual_amount) AS total_amount
2664: FROM pn_payment_items_all ppi
2665: WHERE ppi.payment_term_id = p_term_id
2666: AND ppi.payment_item_type_lookup_code = 'CASH';
2667:
2668: CURSOR draft_schedule_exists_cur (p_sched_date DATE) IS

Line 2678: FROM pn_payment_items_all

2674: AND pps.payment_status_lookup_code = 'DRAFT';
2675:
2676: CURSOR cash_item_exist_cur(p_sched_id NUMBER,p_payment_term_id IN NUMBER) IS
2677: SELECT payment_item_id
2678: FROM pn_payment_items_all
2679: WHERE payment_item_type_lookup_code = 'CASH'
2680: AND payment_schedule_id = p_sched_id
2681: AND payment_term_id = p_payment_term_id;
2682:

Line 2712: l_payment_schedule_id pn_payment_items_all.payment_schedule_id%TYPE;

2708: l_amt_due_to_term NUMBER :=0;
2709: l_amt_due_to_old_term NUMBER;
2710: l_cash_act_amt NUMBER;
2711: l_last_sched_draft VARCHAR2(1);
2712: l_payment_schedule_id pn_payment_items_all.payment_schedule_id%TYPE;
2713: l_lease_change_id NUMBER;
2714: l_errbuf VARCHAR2(80);
2715: l_retcode VARCHAR2(80);
2716: l_update_nbp_flag VARCHAR2(1);

Line 2802: DELETE pn_payment_items_all

2798: SET UPDATE_NBP_FLAG = 'Y'
2799: WHERE payment_term_id = l_payment_term_rec.payment_term_id
2800: AND INCLUDE_IN_VAR_RENT IN ('BASETERM', 'INCLUDE_RI');
2801:
2802: DELETE pn_payment_items_all
2803: WHERE payment_schedule_id IN
2804: (SELECT payment_schedule_id
2805: FROM pn_payment_schedules_all
2806: WHERE lease_id IN (SELECT lease_id FROM pn_payment_terms_all

Line 2897: DELETE pn_payment_items_all

2893: END IF;
2894:
2895: ELSE
2896:
2897: DELETE pn_payment_items_all
2898: WHERE payment_term_id = l_payment_term_rec.payment_term_id;
2899:
2900: DELETE pn_distributions_all
2901: WHERE payment_term_id = l_payment_term_rec.payment_term_id;

Line 2916: DELETE pn_payment_items_all

2912: UPDATE pn_payment_terms_all
2913: SET end_date = p_new_termination_date
2914: WHERE payment_term_id = l_payment_term_rec.payment_term_id;
2915:
2916: DELETE pn_payment_items_all
2917: WHERE payment_schedule_id IN
2918: (SELECT payment_schedule_id
2919: FROM pn_payment_schedules_all
2920: WHERE lease_id IN (SELECT lease_id FROM pn_payment_terms_all