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 352: FROM pn_payment_items_all items,

348: CURSOR exists_approved_schedule( p_payment_term_id IN NUMBER) IS
349: SELECT 'Y'
350: FROM DUAL
351: WHERE EXISTS( SELECT payment_item_id
352: FROM pn_payment_items_all items,
353: pn_payment_schedules_all sched
354: WHERE sched.payment_schedule_id = items.payment_schedule_id
355: AND items.payment_term_id = p_payment_term_id
356: AND sched.payment_status_lookup_code = 'APPROVED');

Line 436: DELETE FROM pn_payment_items_all

432:
433: ELSE
434: BEGIN
435:
436: DELETE FROM pn_payment_items_all
437: WHERE payment_term_id =il_rec.payment_term_id;
438:
439: DELETE FROM pn_payment_schedules_all pps
440: WHERE not exists(SELECT 1

Line 441: FROM PN_PAYMENT_ITEMS_ALL ppi

437: WHERE payment_term_id =il_rec.payment_term_id;
438:
439: DELETE FROM pn_payment_schedules_all pps
440: WHERE not exists(SELECT 1
441: FROM PN_PAYMENT_ITEMS_ALL ppi
442: WHERE ppi.payment_schedule_id=pps.payment_schedule_id)
443: AND pps.lease_id=il_rec.lease_id;
444:
445:

Line 1105: pn_payment_items_all item,

1101: SELECT term.payment_term_id
1102: FROM pn_payment_schedules_all sched,
1103: pn_index_leases_all ilease,
1104: pn_payment_terms_all term,
1105: pn_payment_items_all item,
1106: pn_index_lease_periods_all period
1107: WHERE sched.lease_id = ilease.lease_id
1108: AND sched.payment_schedule_id = item.payment_schedule_id
1109: AND item.payment_term_id = term.payment_term_id

Line 1139: DELETE FROM pn_payment_items_all

1135:
1136: DELETE FROM pn_index_lease_constraints_all
1137: WHERE index_lease_id = p_index_lease_id ;
1138:
1139: DELETE FROM pn_payment_items_all
1140: WHERE payment_term_id IN ( SELECT term.payment_term_id
1141: FROM pn_payment_terms_all term,pn_index_lease_periods_all iperiod
1142: WHERE term.index_period_id = iperiod.index_period_id
1143: AND iperiod.index_lease_id = p_index_lease_id

Line 1149: FROM pn_payment_items_all item

1145:
1146: DELETE FROM pn_payment_schedules_all sched
1147: WHERE sched.payment_status_lookup_code = 'DRAFT'
1148: AND NOT EXISTS( SELECT payment_schedule_id
1149: FROM pn_payment_items_all item
1150: WHERE item.payment_schedule_id = sched.payment_schedule_id);
1151:
1152: DELETE FROM pn_distributions_all
1153: WHERE payment_term_id IN (SELECT payment_term_id

Line 1441: FROM pn_payment_items_all ppi

1437:
1438: CURSOR cur_total_amount(p_payment_term_id IN NUMBER)
1439: IS
1440: SELECT sum(ppi.actual_amount) total_amount
1441: FROM pn_payment_items_all ppi
1442: WHERE ppi.payment_term_id = p_payment_term_id
1443: AND ppi.payment_item_type_lookup_code = 'CASH';
1444:
1445: v_old_num_months NUMBER;

Line 1557: FROM pn_payment_items_all ppt

1553: INTO v_approved_sch
1554: FROM pn_payment_schedules_all pps
1555: WHERE pps.payment_schedule_id IN
1556: (SELECT ppt.payment_schedule_id
1557: FROM pn_payment_items_all ppt
1558: WHERE ppt.payment_term_id = rec_payment_terms.payment_term_id
1559: AND ppt.export_currency_amount <> 0
1560: AND ppt.payment_item_type_lookup_code = 'CASH')
1561: AND pps.payment_status_lookup_code = 'APPROVED'

Line 1583: UPDATE pn_payment_items_all

1579: last_update_login = fnd_global.login_id
1580: WHERE payment_term_id = rec_payment_terms.payment_term_id;
1581:
1582: BEGIN
1583: UPDATE pn_payment_items_all
1584: SET actual_amount = v_new_amount,
1585: export_currency_amount = v_new_amount,
1586: last_update_date = SYSDATE,
1587: last_updated_by = fnd_global.user_id,

Line 1607: UPDATE pn_payment_items_all

1603: last_update_login = fnd_global.login_id
1604: WHERE payment_term_id = rec_payment_terms.payment_term_id;
1605:
1606: BEGIN
1607: UPDATE pn_payment_items_all
1608: SET actual_amount = v_new_amount,
1609: estimated_amount = v_new_amount,
1610: export_currency_amount = v_new_amount,
1611: last_update_date = SYSDATE,

Line 2477: l_payment_item_id pn_payment_items_all.payment_item_id%TYPE;

2473: l_mths NUMBER;
2474: l_appr_sched_exists BOOLEAN := FALSE;
2475: l_sched_tbl pn_retro_adjustment_pkg.payment_item_tbl_type;
2476: l_lease_id NUMBER;
2477: l_payment_item_id pn_payment_items_all.payment_item_id%TYPE;
2478: l_lst_cash_sch_dt DATE;
2479: l_var_rent_id NUMBER;
2480:
2481: CURSOR get_lease_id IS

Line 2515: FROM pn_payment_items_all

2511: FROM pn_payment_terms_all
2512: WHERE payment_term_id = p_payment_term_id)
2513: AND payment_status_lookup_code = 'APPROVED'
2514: AND payment_schedule_id IN (SELECT payment_schedule_id
2515: FROM pn_payment_items_all
2516: WHERE payment_term_id = p_payment_term_id);
2517:
2518: CURSOR total_amt_old_term_cur(p_term_id IN NUMBER) IS
2519: SELECT SUM(ppi.actual_amount) AS total_amount

Line 2520: FROM pn_payment_items_all ppi

2516: WHERE payment_term_id = p_payment_term_id);
2517:
2518: CURSOR total_amt_old_term_cur(p_term_id IN NUMBER) IS
2519: SELECT SUM(ppi.actual_amount) AS total_amount
2520: FROM pn_payment_items_all ppi
2521: WHERE ppi.payment_term_id = p_term_id
2522: AND ppi.payment_item_type_lookup_code = 'CASH';
2523:
2524: CURSOR draft_schedule_exists_cur (p_sched_date DATE) IS

Line 2534: FROM pn_payment_items_all

2530: AND pps.payment_status_lookup_code = 'DRAFT';
2531:
2532: CURSOR cash_item_exist_cur(p_sched_id NUMBER,p_payment_term_id IN NUMBER) IS
2533: SELECT payment_item_id
2534: FROM pn_payment_items_all
2535: WHERE payment_item_type_lookup_code = 'CASH'
2536: AND payment_schedule_id = p_sched_id
2537: AND payment_term_id = p_payment_term_id;
2538:

Line 2568: l_payment_schedule_id pn_payment_items_all.payment_schedule_id%TYPE;

2564: l_amt_due_to_term NUMBER :=0;
2565: l_amt_due_to_old_term NUMBER;
2566: l_cash_act_amt NUMBER;
2567: l_last_sched_draft VARCHAR2(1);
2568: l_payment_schedule_id pn_payment_items_all.payment_schedule_id%TYPE;
2569: l_lease_change_id NUMBER;
2570: l_errbuf VARCHAR2(80);
2571: l_retcode VARCHAR2(80);
2572: l_update_nbp_flag VARCHAR2(1);

Line 2657: DELETE pn_payment_items_all

2653: SET UPDATE_NBP_FLAG = 'Y'
2654: WHERE payment_term_id = l_payment_term_rec.payment_term_id
2655: AND INCLUDE_IN_VAR_RENT IN ('BASETERM', 'INCLUDE_RI');
2656:
2657: DELETE pn_payment_items_all
2658: WHERE payment_schedule_id IN
2659: (SELECT payment_schedule_id
2660: FROM pn_payment_schedules_all
2661: WHERE lease_id IN (SELECT lease_id FROM pn_payment_terms_all

Line 2751: DELETE pn_payment_items_all

2747: END IF;
2748:
2749: ELSE
2750:
2751: DELETE pn_payment_items_all
2752: WHERE payment_term_id = l_payment_term_rec.payment_term_id;
2753:
2754: DELETE pn_distributions_all
2755: WHERE payment_term_id = l_payment_term_rec.payment_term_id;

Line 2770: DELETE pn_payment_items_all

2766: UPDATE pn_payment_terms_all
2767: SET end_date = p_new_termination_date
2768: WHERE payment_term_id = l_payment_term_rec.payment_term_id;
2769:
2770: DELETE pn_payment_items_all
2771: WHERE payment_schedule_id IN
2772: (SELECT payment_schedule_id
2773: FROM pn_payment_schedules_all
2774: WHERE lease_id IN (SELECT lease_id FROM pn_payment_terms_all