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_VAR_RENT_PKG dependencies on PN_PAYMENT_TERMS

Line 2698: FROM pn_payment_terms

2694: FROM pn_payment_items_all
2695: WHERE NVL(export_to_ar_flag,'N') <>'Y'
2696: AND payment_term_id IN
2697: (SELECT payment_term_id
2698: FROM pn_payment_terms
2699: WHERE VAR_RENT_INV_ID IN
2700: (SELECT var_rent_inv_id
2701: FROM pn_var_rent_inv_all
2702: WHERE var_rent_id = p_var_rent_id

Line 2711: FROM pn_payment_terms_all

2707:
2708: DELETE FROM pn_payment_items_all
2709: WHERE payment_term_id IN
2710: (SELECT payment_term_id
2711: FROM pn_payment_terms_all
2712: WHERE var_rent_inv_id IN
2713: (SELECT var_rent_inv_id
2714: FROM pn_var_rent_inv_all
2715: WHERE var_rent_id = p_var_rent_id

Line 2729: DELETE FROM pn_payment_terms

2725: IF SQL%NOTFOUND THEN
2726: NULL;
2727: END IF;
2728:
2729: DELETE FROM pn_payment_terms
2730: WHERE var_rent_inv_id IN
2731: (SELECT var_rent_inv_id
2732: FROM pn_var_rent_inv_all
2733: WHERE var_rent_id = p_var_rent_id)

Line 2740: FROM pn_payment_terms

2736: FROM pn_payment_items
2737: WHERE export_to_ar_flag ='Y'
2738: AND payment_term_id IN
2739: (SELECT payment_term_id
2740: FROM pn_payment_terms
2741: WHERE VAR_RENT_INV_ID IN
2742: (SELECT VAR_RENT_INV_ID
2743: FROM PN_VAR_RENT_INV_ALL
2744: WHERE VAR_RENT_ID = p_var_rent_id

Line 3555: FROM pn_payment_terms_all

3551:
3552: DELETE FROM pn_payment_items_all
3553: WHERE payment_term_id IN
3554: (SELECT payment_term_id
3555: FROM pn_payment_terms_all
3556: WHERE var_rent_inv_id IN
3557: (SELECT var_rent_inv_id
3558: FROM pn_var_rent_inv_all
3559: WHERE var_rent_id = p_var_rent_id

Line 3571: FROM pn_payment_terms

3567: FROM pn_payment_items_all
3568: WHERE export_to_ar_flag <>'Y'
3569: AND payment_term_id IN
3570: (SELECT payment_term_id
3571: FROM pn_payment_terms
3572: WHERE VAR_RENT_INV_ID IN
3573: (SELECT var_rent_inv_id
3574: FROM pn_var_rent_inv_all
3575: WHERE var_rent_id = p_var_rent_id

Line 3588: DELETE FROM pn_payment_terms

3584: IF SQL%NOTFOUND THEN
3585: NULL;
3586: END IF;
3587:
3588: DELETE FROM pn_payment_terms
3589: WHERE var_rent_inv_id IN
3590: (SELECT var_rent_inv_id
3591: FROM pn_var_rent_inv_all
3592: WHERE var_rent_id = p_var_rent_id)

Line 3599: FROM pn_payment_terms

3595: FROM pn_payment_items
3596: WHERE export_to_ar_flag ='Y'
3597: AND payment_term_id IN
3598: (SELECT payment_term_id
3599: FROM pn_payment_terms
3600: WHERE VAR_RENT_INV_ID IN
3601: (SELECT VAR_RENT_INV_ID
3602: FROM PN_VAR_RENT_INV_ALL
3603: WHERE VAR_RENT_ID = p_var_rent_id

Line 4426: pn_payment_terms_ALL term,

4422:
4423: SELECT SUM(item.ACTUAL_AMOUNT)
4424: INTO l_base_rent
4425: FROM pn_payment_items_ALL item,
4426: pn_payment_terms_ALL term,
4427: pn_var_periods_ALL per,
4428: pn_var_rents_ALL var,
4429: pn_payment_schedules_all sched
4430: WHERE item.PAYMENT_TERM_ID = term.PAYMENT_TERM_ID

Line 4450: pn_payment_terms_ALL term,

4446:
4447: SELECT SUM(item.ACTUAL_AMOUNT)
4448: INTO l_base_rent
4449: FROM pn_payment_items_ALL item,
4450: pn_payment_terms_ALL term,
4451: pn_var_periods_ALL per,
4452: pn_var_rents_ALL var,
4453: pn_payment_schedules_all sched
4454: WHERE item.PAYMENT_TERM_ID = term.PAYMENT_TERM_ID

Line 5125: pn_payment_terms_all pt

5121: SELECT 'Y' term_exists
5122: FROM DUAL
5123: WHERE EXISTS (SELECT NULL
5124: FROM pn_var_rent_inv_all INv,
5125: pn_payment_terms_all pt
5126: WHERE inv.var_rent_id = p_var_rent_id
5127: AND inv.period_id = NVL(p_period_id,inv.period_id)
5128: AND inv.var_rent_inv_id = pt.var_rent_inv_id
5129: AND pt.status ='APPROVED'

Line 5209: DELETE FROM pn_payment_terms_all

5205: IF SQL%NOTFOUND THEN
5206: NULL;
5207: END IF;
5208:
5209: DELETE FROM pn_payment_terms_all
5210: WHERE var_rent_inv_id IN
5211: (SELECT var_rent_inv_id
5212: FROM pn_var_rent_inv_all
5213: WHERE var_rent_id = p_var_rent_id);

Line 5341: PN_PAYMENT_TERMS_ALL ppt,

5337:
5338: CURSOR C_UPD_TERMS IS
5339: SELECT ppi.payment_term_id
5340: FROM PN_PAYMENT_ITEMS_ALL ppi,
5341: PN_PAYMENT_TERMS_ALL ppt,
5342: PN_VAR_RENT_INV_ALL pvri,
5343: PN_LEASES_ALL pl
5344: WHERE DECODE(pl.lease_class_code, 'DIRECT', NVL(ppi.transferred_to_ap_flag,'N'),
5345: 'THIRD_PARTY', NVL(ppi.transferred_to_ar_flag,'N'),

Line 5354: FROM PN_PAYMENT_TERMS_ALL ppt,

5350: AND ppt.var_rent_inv_id = pvri.var_rent_inv_id
5351: AND pvri.var_rent_id = p_var_rent_id
5352: UNION ALL
5353: SELECT ppt.payment_term_id
5354: FROM PN_PAYMENT_TERMS_ALL ppt,
5355: PN_VAR_RENT_INV_ALL pvri
5356: WHERE ppt.STATUS = 'DRAFT'
5357: AND ppt.var_rent_inv_id = pvri.var_rent_inv_id
5358: AND pvri.var_rent_id = p_var_rent_id;

Line 5373: UPDATE PN_PAYMENT_TERMS_ALL

5369: BULK COLLECT INTO l_payment_term_id
5370: LIMIT 1000;
5371:
5372: FORALL i IN 1..l_payment_term_id.COUNT
5373: UPDATE PN_PAYMENT_TERMS_ALL
5374: SET location_id = p_location_id
5375: WHERE payment_term_id = l_payment_term_id(i);
5376: EXIT WHEN C_UPD_TERMS%NOTFOUND;
5377:

Line 8024: FROM pn_payment_terms_all

8020:
8021: /* Fetches payment term information for a invoice id */
8022: CURSOR payment_cur(p_invoice_date DATE) IS
8023: SELECT payment_term_id
8024: FROM pn_payment_terms_all
8025: WHERE var_rent_inv_id IN (SELECT var_rent_inv_id
8026: FROM pn_var_rent_inv_all
8027: WHERE invoice_date = p_invoice_date
8028: AND var_rent_id = p_var_rent_id);

Line 8081: DELETE pn_payment_terms_all

8077: pnp_debug_pkg.debug (' p_old_termn_date = '|| p_old_termn_date);
8078: pnp_debug_pkg.debug (' ------------------------------------------- :');
8079:
8080: /* Delete draft terms for invoices for all periods which lie after the new termination date */
8081: DELETE pn_payment_terms_all
8082: WHERE status = 'DRAFT'
8083: AND var_rent_inv_id IN (SELECT var_rent_inv_id
8084: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp
8085: WHERE pvi.period_id = pvp.period_id

Line 8092: FROM pn_payment_terms_all ppt, pn_var_rent_inv_all pvi, pn_var_periods_all pvp

8088:
8089: /* Delete invoices for which there are no terms */
8090: DELETE pn_var_rent_inv_all
8091: WHERE var_rent_inv_id NOT IN (SELECT ppt.var_rent_inv_id
8092: FROM pn_payment_terms_all ppt, pn_var_rent_inv_all pvi, pn_var_periods_all pvp
8093: WHERE ppt.var_rent_inv_id = pvi.var_rent_inv_id
8094: AND pvi.period_id = pvp.period_id
8095: AND pvp.var_rent_id = p_var_rent_id
8096: AND pvp.start_date > p_new_termn_date)

Line 8572: FROM pn_payment_terms_all

8568:
8569: /* Fetches payment term information for a invoice id */
8570: CURSOR payment_cur(p_invoice_date DATE) IS
8571: SELECT payment_term_id
8572: FROM pn_payment_terms_all
8573: WHERE var_rent_inv_id IN (SELECT var_rent_inv_id
8574: FROM pn_var_rent_inv_all
8575: WHERE invoice_date = p_invoice_date
8576: AND var_rent_id = p_var_rent_id);

Line 8624: DELETE pn_payment_terms_all

8620: pnp_debug_pkg.debug ('p_old_termn_date ....'||p_old_termn_date);
8621:
8622:
8623: /* Delete draft terms for invoices for this period */
8624: DELETE pn_payment_terms_all
8625: WHERE status = 'DRAFT'
8626: AND var_rent_inv_id IN (SELECT var_rent_inv_id
8627: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp
8628: WHERE pvi.period_id = p_period_id );

Line 8802: DELETE pn_payment_terms_all

8798:
8799: DELETE pn_var_constr_defaults_all
8800: WHERE var_rent_id = p_var_rent_id;
8801:
8802: DELETE pn_payment_terms_all
8803: WHERE var_rent_inv_id IN (SELECT var_rent_inv_id
8804: FROM pn_var_rent_inv_all
8805: WHERE var_rent_id = p_var_rent_id);
8806:

Line 8882: FROM pn_payment_terms_all

8878:
8879: /* Check if the specified variable rent agreement has an approved term */
8880: CURSOR approved_term_exists_cur (p_var_rent_id NUMBER) IS
8881: SELECT 'Y' approve_term_exits
8882: FROM pn_payment_terms_all
8883: WHERE status = 'APPROVED'
8884: AND var_rent_inv_id IN (SELECT var_rent_inv_id
8885: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp,
8886: pn_var_rents_all pvr

Line 9696: FROM pn_payment_terms_all

9692:
9693: /* Fetches payment term information for a invoice id */
9694: CURSOR payment_cur(p_period_id NUMBER) IS
9695: SELECT payment_term_id
9696: FROM pn_payment_terms_all
9697: WHERE var_rent_inv_id IN ( SELECT var_rent_inv_id
9698: FROM pn_var_rent_inv_all
9699: WHERE period_id = p_period_id
9700: AND NVL(actual_exp_code, 'N') = 'Y'

Line 9720: DELETE pn_payment_terms_all

9716: BEGIN
9717:
9718: pnp_debug_pkg.debug ('pn_var_rent_pkg.create_rev_term_LY_FLY (+) ');
9719:
9720: DELETE pn_payment_terms_all
9721: WHERE var_rent_inv_id IN (SELECT var_rent_inv_id
9722: FROM pn_var_rent_inv_all
9723: WHERE period_id = p_last_period_id
9724: AND NVL(actual_exp_code, 'N') <> 'Y')