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_ALL

Line 2715: FROM pn_payment_terms_all

2711:
2712: DELETE FROM pn_payment_items_all
2713: WHERE payment_term_id IN
2714: (SELECT payment_term_id
2715: FROM pn_payment_terms_all
2716: WHERE var_rent_inv_id IN
2717: (SELECT var_rent_inv_id
2718: FROM pn_var_rent_inv_all
2719: WHERE var_rent_id = p_var_rent_id

Line 3559: FROM pn_payment_terms_all

3555:
3556: DELETE FROM pn_payment_items_all
3557: WHERE payment_term_id IN
3558: (SELECT payment_term_id
3559: FROM pn_payment_terms_all
3560: WHERE var_rent_inv_id IN
3561: (SELECT var_rent_inv_id
3562: FROM pn_var_rent_inv_all
3563: WHERE var_rent_id = p_var_rent_id

Line 4430: pn_payment_terms_ALL term,

4426:
4427: SELECT SUM(item.ACTUAL_AMOUNT)
4428: INTO l_base_rent
4429: FROM pn_payment_items_ALL item,
4430: pn_payment_terms_ALL term,
4431: pn_var_periods_ALL per,
4432: pn_var_rents_ALL var,
4433: pn_payment_schedules_all sched
4434: WHERE item.PAYMENT_TERM_ID = term.PAYMENT_TERM_ID

Line 4454: pn_payment_terms_ALL term,

4450:
4451: SELECT SUM(item.ACTUAL_AMOUNT)
4452: INTO l_base_rent
4453: FROM pn_payment_items_ALL item,
4454: pn_payment_terms_ALL term,
4455: pn_var_periods_ALL per,
4456: pn_var_rents_ALL var,
4457: pn_payment_schedules_all sched
4458: WHERE item.PAYMENT_TERM_ID = term.PAYMENT_TERM_ID

Line 5129: pn_payment_terms_all pt

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

Line 5213: DELETE FROM pn_payment_terms_all

5209: IF SQL%NOTFOUND THEN
5210: NULL;
5211: END IF;
5212:
5213: DELETE FROM pn_payment_terms_all
5214: WHERE var_rent_inv_id IN
5215: (SELECT var_rent_inv_id
5216: FROM pn_var_rent_inv_all
5217: WHERE var_rent_id = p_var_rent_id);

Line 5345: PN_PAYMENT_TERMS_ALL ppt,

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

Line 5358: FROM PN_PAYMENT_TERMS_ALL ppt,

5354: AND ppt.var_rent_inv_id = pvri.var_rent_inv_id
5355: AND pvri.var_rent_id = p_var_rent_id
5356: UNION ALL
5357: SELECT ppt.payment_term_id
5358: FROM PN_PAYMENT_TERMS_ALL ppt,
5359: PN_VAR_RENT_INV_ALL pvri
5360: WHERE ppt.STATUS = 'DRAFT'
5361: AND ppt.var_rent_inv_id = pvri.var_rent_inv_id
5362: AND pvri.var_rent_id = p_var_rent_id;

Line 5377: UPDATE PN_PAYMENT_TERMS_ALL

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

Line 8030: FROM pn_payment_terms_all

8026:
8027: /* Fetches payment term information for a invoice id */
8028: CURSOR payment_cur(p_invoice_date DATE) IS
8029: SELECT payment_term_id
8030: FROM pn_payment_terms_all
8031: WHERE var_rent_inv_id IN (SELECT var_rent_inv_id
8032: FROM pn_var_rent_inv_all
8033: WHERE invoice_date = p_invoice_date
8034: AND var_rent_id = p_var_rent_id);

Line 8087: DELETE pn_payment_terms_all

8083: pnp_debug_pkg.debug (' p_old_termn_date = '|| p_old_termn_date);
8084: pnp_debug_pkg.debug (' ------------------------------------------- :');
8085:
8086: /* Delete draft terms for invoices for all periods which lie after the new termination date */
8087: DELETE pn_payment_terms_all
8088: WHERE status = 'DRAFT'
8089: AND var_rent_inv_id IN (SELECT var_rent_inv_id
8090: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp
8091: WHERE pvi.period_id = pvp.period_id

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

8094:
8095: /* Delete invoices for which there are no terms */
8096: DELETE pn_var_rent_inv_all
8097: WHERE var_rent_inv_id NOT IN (SELECT ppt.var_rent_inv_id
8098: FROM pn_payment_terms_all ppt, pn_var_rent_inv_all pvi, pn_var_periods_all pvp
8099: WHERE ppt.var_rent_inv_id = pvi.var_rent_inv_id
8100: AND pvi.period_id = pvp.period_id
8101: AND pvp.var_rent_id = p_var_rent_id
8102: AND pvp.start_date > p_new_termn_date)

Line 8589: FROM pn_payment_terms_all

8585:
8586: /* Fetches payment term information for a invoice id */
8587: CURSOR payment_cur(p_invoice_date DATE) IS
8588: SELECT payment_term_id
8589: FROM pn_payment_terms_all
8590: WHERE var_rent_inv_id IN (SELECT var_rent_inv_id
8591: FROM pn_var_rent_inv_all
8592: WHERE invoice_date = p_invoice_date
8593: AND var_rent_id = p_var_rent_id);

Line 8641: DELETE pn_payment_terms_all

8637: pnp_debug_pkg.debug ('p_old_termn_date ....'||p_old_termn_date);
8638:
8639:
8640: /* Delete draft terms for invoices for this period */
8641: DELETE pn_payment_terms_all
8642: WHERE status = 'DRAFT'
8643: AND var_rent_inv_id IN (SELECT var_rent_inv_id
8644: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp
8645: WHERE pvi.period_id = p_period_id );

Line 8819: DELETE pn_payment_terms_all

8815:
8816: DELETE pn_var_constr_defaults_all
8817: WHERE var_rent_id = p_var_rent_id;
8818:
8819: DELETE pn_payment_terms_all
8820: WHERE var_rent_inv_id IN (SELECT var_rent_inv_id
8821: FROM pn_var_rent_inv_all
8822: WHERE var_rent_id = p_var_rent_id);
8823:

Line 8899: FROM pn_payment_terms_all

8895:
8896: /* Check if the specified variable rent agreement has an approved term */
8897: CURSOR approved_term_exists_cur (p_var_rent_id NUMBER) IS
8898: SELECT 'Y' approve_term_exits
8899: FROM pn_payment_terms_all
8900: WHERE status = 'APPROVED'
8901: AND var_rent_inv_id IN (SELECT var_rent_inv_id
8902: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp,
8903: pn_var_rents_all pvr

Line 9713: FROM pn_payment_terms_all

9709:
9710: /* Fetches payment term information for a invoice id */
9711: CURSOR payment_cur(p_period_id NUMBER) IS
9712: SELECT payment_term_id
9713: FROM pn_payment_terms_all
9714: WHERE var_rent_inv_id IN ( SELECT var_rent_inv_id
9715: FROM pn_var_rent_inv_all
9716: WHERE period_id = p_period_id
9717: AND NVL(actual_exp_code, 'N') = 'Y'

Line 9737: DELETE pn_payment_terms_all

9733: BEGIN
9734:
9735: pnp_debug_pkg.debug ('pn_var_rent_pkg.create_rev_term_LY_FLY (+) ');
9736:
9737: DELETE pn_payment_terms_all
9738: WHERE var_rent_inv_id IN (SELECT var_rent_inv_id
9739: FROM pn_var_rent_inv_all
9740: WHERE period_id = p_last_period_id
9741: AND NVL(actual_exp_code, 'N') <> 'Y')