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_VAR_RENT_INV_ALL

Line 2705: FROM pn_var_rent_inv_all

2701: (SELECT payment_term_id
2702: FROM pn_payment_terms
2703: WHERE VAR_RENT_INV_ID IN
2704: (SELECT var_rent_inv_id
2705: FROM pn_var_rent_inv_all
2706: WHERE var_rent_id = p_var_rent_id
2707: )
2708: )
2709: )

Line 2718: FROM pn_var_rent_inv_all

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
2720: )
2721: )
2722: AND NVL(export_to_ar_flag,'N') <>'Y' ;

Line 2736: FROM pn_var_rent_inv_all

2732:
2733: DELETE FROM pn_payment_terms
2734: WHERE var_rent_inv_id IN
2735: (SELECT var_rent_inv_id
2736: FROM pn_var_rent_inv_all
2737: WHERE var_rent_id = p_var_rent_id)
2738: AND NOT EXISTS
2739: (SELECT 1
2740: FROM pn_payment_items

Line 2747: FROM PN_VAR_RENT_INV_ALL

2743: (SELECT payment_term_id
2744: FROM pn_payment_terms
2745: WHERE VAR_RENT_INV_ID IN
2746: (SELECT VAR_RENT_INV_ID
2747: FROM PN_VAR_RENT_INV_ALL
2748: WHERE VAR_RENT_ID = p_var_rent_id
2749: )
2750: )
2751: );

Line 3436: FROM pn_var_rent_inv_all inv

3432: SELECT 1
3433: INTO l_calculation_exists
3434: FROM dual
3435: WHERE EXISTS ( SELECT inv.var_rent_inv_id
3436: FROM pn_var_rent_inv_all inv
3437: WHERE inv.var_rent_id = p_var_rent_id);
3438:
3439: RETURN l_calculation_exists;
3440:

Line 3487: FROM pn_var_rent_inv_all inv

3483: SELECT 1
3484: INTO l_invoice_exists
3485: FROM dual
3486: WHERE EXISTS ( SELECT inv.var_rent_inv_id
3487: FROM pn_var_rent_inv_all inv
3488: WHERE inv.var_rent_id = p_var_rent_id);
3489:
3490: RETURN l_invoice_exists;
3491:

Line 3562: FROM pn_var_rent_inv_all

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
3564: )
3565: )
3566: AND export_to_ar_flag <>'Y' ;

Line 3578: FROM pn_var_rent_inv_all

3574: (SELECT payment_term_id
3575: FROM pn_payment_terms
3576: WHERE VAR_RENT_INV_ID IN
3577: (SELECT var_rent_inv_id
3578: FROM pn_var_rent_inv_all
3579: WHERE var_rent_id = p_var_rent_id
3580: )
3581: )
3582: )

Line 3595: FROM pn_var_rent_inv_all

3591:
3592: DELETE FROM pn_payment_terms
3593: WHERE var_rent_inv_id IN
3594: (SELECT var_rent_inv_id
3595: FROM pn_var_rent_inv_all
3596: WHERE var_rent_id = p_var_rent_id)
3597: AND NOT EXISTS
3598: (SELECT 1
3599: FROM pn_payment_items

Line 3606: FROM PN_VAR_RENT_INV_ALL

3602: (SELECT payment_term_id
3603: FROM pn_payment_terms
3604: WHERE VAR_RENT_INV_ID IN
3605: (SELECT VAR_RENT_INV_ID
3606: FROM PN_VAR_RENT_INV_ALL
3607: WHERE VAR_RENT_ID = p_var_rent_id
3608: )
3609: )
3610: );

Line 4771: | pn_var_rent_inv_all table.

Line 4884: FROM pn_var_rent_inv_all

4880: SELECT 1
4881: INTO l_exported
4882: FROM dual
4883: WHERE EXISTS ( SELECT VAR_RENT_INV_ID
4884: FROM pn_var_rent_inv_all
4885: WHERE var_rent_inv_id = p_id
4886: AND (actual_exp_code = 'Y' OR
4887: variance_exp_code = 'Y')
4888: );

Line 5085: FROM pn_var_rent_inv_ALL inv1

5081: SELECT 1
5082: INTO l_adjust_hist_exists
5083: FROM dual
5084: WHERE EXISTS(SELECT 1
5085: FROM pn_var_rent_inv_ALL inv1
5086: WHERE inv1.period_id = p_period_id
5087: AND (NVL(inv1.adjust_num,0) <> 0 OR
5088: NVL(inv1.true_up_amt,0) <> 0 ));
5089:

Line 5128: FROM pn_var_rent_inv_all INv,

5124: CURSOR chk_term_cur IS
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

Line 5136: FROM pn_var_rent_inv_all pvri

5132: AND inv.var_rent_inv_id = pt.var_rent_inv_id
5133: AND pt.status ='APPROVED'
5134: AND pt.var_rent_type IN ('ACTUAL','VARIANCE'))
5135: OR EXISTS (SELECT NULL
5136: FROM pn_var_rent_inv_all pvri
5137: WHERE pvri.period_id = NVL(p_period_id,pvri.period_id)
5138: AND pvri.actual_invoiced_amount = 0
5139: AND actual_exp_code = 'Y'
5140: );

Line 5216: FROM pn_var_rent_inv_all

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);
5218:
5219: IF SQL%NOTFOUND THEN
5220: NULL;

Line 5223: DELETE FROM pn_var_rent_inv_all

5219: IF SQL%NOTFOUND THEN
5220: NULL;
5221: END IF;
5222:
5223: DELETE FROM pn_var_rent_inv_all
5224: WHERE var_rent_id = p_var_rent_id;
5225:
5226: IF SQL%NOTFOUND THEN
5227: NULL;

Line 5233: FROM pn_var_rent_inv_all

5229:
5230: DELETE FROM pn_var_abatements_all
5231: WHERE var_rent_inv_id IN
5232: (SELECT var_rent_inv_id
5233: FROM pn_var_rent_inv_all
5234: WHERE var_rent_id = p_var_rent_id);
5235:
5236: IF SQL%NOTFOUND THEN
5237: NULL;

Line 5346: PN_VAR_RENT_INV_ALL pvri,

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'),
5350: 'SUB_LEASE', NVL(ppi.transferred_to_ar_flag,'N')) = 'N'

Line 5359: PN_VAR_RENT_INV_ALL pvri

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;
5363:

Line 7955: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp

7951:
7952: /* This cursor fetches the distinct invoices for periods starting after new termination date */
7953: CURSOR invoice_date_cur IS
7954: SELECT DISTINCT pvi.invoice_date, pvi.period_id
7955: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp
7956: WHERE pvp.period_id = pvi.period_id
7957: AND pvp.start_date > p_new_termn_date
7958: AND pvp.var_rent_id = p_var_rent_id;
7959:

Line 7966: FROM pn_var_rent_inv_all

7962: CURSOR rent_inv_cur ( p_period_id NUMBER
7963: ,p_invoice_date DATE
7964: ,p_adjust_num NUMBER) IS
7965: SELECT *
7966: FROM pn_var_rent_inv_all
7967: WHERE period_id = p_period_id
7968: AND (NVL(actual_exp_code, 'N') = 'Y' OR
7969: NVL(variance_exp_code, 'N') = 'Y' OR
7970: NVL(forecasted_exp_code, 'N') = 'Y' OR

Line 7987: FROM pn_var_rent_inv_all

7983: CURSOR term_status_cur ( p_period_id NUMBER
7984: ,p_invoice_date DATE
7985: ,p_adjust_num NUMBER) IS
7986: SELECT variance_exp_code, forecasted_exp_code
7987: FROM pn_var_rent_inv_all
7988: WHERE period_id = p_period_id
7989: AND (NVL(actual_exp_code, 'N') = 'Y' OR
7990: NVL(variance_exp_code, 'N') = 'Y' OR
7991: NVL(forecasted_exp_code, 'N') = 'Y' OR

Line 8014: FROM pn_var_rent_inv_all

8010:
8011: /* this cursor fetches invoice for a particular period */
8012: CURSOR invoice_cur (p_period_id NUMBER) IS
8013: SELECT var_rent_inv_id
8014: FROM pn_var_rent_inv_all
8015: WHERE period_id = p_period_id;
8016:
8017: /* This cursor fetches periods staring after new termination date for which there exists invoices */
8018: CURSOR period_inv_cur IS

Line 8024: FROM pn_var_rent_inv_all

8020: FROM pn_var_periods_all per
8021: WHERE per.var_rent_id = p_var_rent_id
8022: AND per.start_date > p_new_termn_date
8023: AND EXISTS (SELECT var_rent_inv_id
8024: FROM pn_var_rent_inv_all
8025: WHERE period_id = per.period_id);
8026:
8027: /* Fetches payment term information for a invoice id */
8028: CURSOR payment_cur(p_invoice_date DATE) IS

Line 8032: FROM pn_var_rent_inv_all

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);
8035:
8036: /* Fetches the maximum adjust num cursor */

Line 8040: FROM pn_var_rent_inv_all

8036: /* Fetches the maximum adjust num cursor */
8037: CURSOR max_adjust_num_cur (p_period_id NUMBER,
8038: p_invoice_date DATE) IS
8039: SELECT max(adjust_num) max_adjust_num
8040: FROM pn_var_rent_inv_all
8041: WHERE period_id = p_period_id
8042: AND invoice_date = p_invoice_date;
8043:
8044: /*Bug#6524437

Line 8054: FROM pn_var_rent_inv_all

8050: /* Fetches the amount for the particular invoice date */
8051: CURSOR actual_invoice_amount (p_period_id NUMBER,
8052: p_invoice_date DATE) IS
8053: SELECT SUM(actual_invoiced_amount) actual_amount
8054: FROM pn_var_rent_inv_all
8055: WHERE var_rent_inv_id IN ( SELECT var_rent_inv_id
8056: FROM pn_var_rent_inv_all
8057: WHERE period_id = p_period_id
8058: AND (NVL(actual_exp_code, 'N') = 'Y' OR

Line 8056: FROM pn_var_rent_inv_all

8052: p_invoice_date DATE) IS
8053: SELECT SUM(actual_invoiced_amount) actual_amount
8054: FROM pn_var_rent_inv_all
8055: WHERE var_rent_inv_id IN ( SELECT var_rent_inv_id
8056: FROM pn_var_rent_inv_all
8057: WHERE period_id = p_period_id
8058: AND (NVL(actual_exp_code, 'N') = 'Y' OR
8059: NVL(variance_exp_code, 'N') = 'Y' OR
8060: NVL(forecasted_exp_code, 'N') = 'Y' OR

Line 8066: l_actual_invoiced_amount pn_var_rent_inv_all.actual_invoiced_amount%TYPE;

8062: /*AND NVL(actual_invoiced_amount, 0) <> 0*/
8063: AND invoice_date = p_invoice_date);
8064:
8065: l_invoice_exists VARCHAR2(1) := 'N';
8066: l_actual_invoiced_amount pn_var_rent_inv_all.actual_invoiced_amount%TYPE;
8067: l_rowid ROWID;
8068: l_var_rent_inv_id NUMBER;
8069: l_date DATE := SYSDATE;
8070: l_errbuf VARCHAR2(250) := NULL;

Line 8090: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp

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
8092: AND pvp.var_rent_id = p_var_rent_id
8093: AND pvp.start_date > p_new_termn_date);
8094:

Line 8096: DELETE pn_var_rent_inv_all

8092: AND pvp.var_rent_id = p_var_rent_id
8093: AND pvp.start_date > p_new_termn_date);
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

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 8547: FROM pn_var_rent_inv_all

8543:
8544: /* This cursor fetches the distinct invoices for periods starting after new termination date */
8545: CURSOR invoice_date_cur IS
8546: SELECT DISTINCT invoice_date
8547: FROM pn_var_rent_inv_all
8548: WHERE period_id = p_period_id
8549: AND invoice_date > p_new_termn_date;
8550:
8551: /* This cursor fetches the invoices existing after the new termination date */

Line 8556: FROM pn_var_rent_inv_all

8552: CURSOR invoice_cur ( p_period_id NUMBER
8553: ,p_invoice_date DATE
8554: ,p_adjust_num NUMBER) IS
8555: SELECT *
8556: FROM pn_var_rent_inv_all
8557: WHERE period_id = p_period_id
8558: AND (NVL(actual_exp_code, 'N') = 'Y' OR
8559: NVL(variance_exp_code, 'N') = 'Y' OR
8560: NVL(forecasted_exp_code, 'N') = 'Y')

Line 8574: FROM pn_var_rent_inv_all

8570: CURSOR term_status_cur ( p_period_id NUMBER
8571: ,p_invoice_date DATE
8572: ,p_adjust_num NUMBER) IS
8573: SELECT variance_exp_code, forecasted_exp_code
8574: FROM pn_var_rent_inv_all
8575: WHERE period_id = p_period_id
8576: AND (NVL(actual_exp_code, 'N') = 'Y' OR
8577: NVL(variance_exp_code, 'N') = 'Y' OR
8578: NVL(forecasted_exp_code, 'N') = 'Y')

Line 8591: FROM pn_var_rent_inv_all

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);
8594:
8595: /* Fetches the maximum adjust num cursor */

Line 8599: FROM pn_var_rent_inv_all

8595: /* Fetches the maximum adjust num cursor */
8596: CURSOR max_adjust_num_cur (p_period_id NUMBER,
8597: p_invoice_date DATE) IS
8598: SELECT max(adjust_num) max_adjust_num
8599: FROM pn_var_rent_inv_all
8600: WHERE period_id = p_period_id
8601: AND invoice_date = p_invoice_date
8602: AND true_up_amt IS NULL
8603: AND true_up_status IS NULL

Line 8610: FROM pn_var_rent_inv_all

8606: /* Fetches the amount for the particular invoice date */
8607: CURSOR actual_invoice_amount (p_period_id NUMBER,
8608: p_invoice_date DATE) IS
8609: SELECT SUM(actual_invoiced_amount) actual_amount
8610: FROM pn_var_rent_inv_all
8611: WHERE var_rent_inv_id IN ( SELECT var_rent_inv_id
8612: FROM pn_var_rent_inv_all
8613: WHERE period_id = p_period_id
8614: AND (NVL(actual_exp_code, 'N') = 'Y' OR

Line 8612: FROM pn_var_rent_inv_all

8608: p_invoice_date DATE) IS
8609: SELECT SUM(actual_invoiced_amount) actual_amount
8610: FROM pn_var_rent_inv_all
8611: WHERE var_rent_inv_id IN ( SELECT var_rent_inv_id
8612: FROM pn_var_rent_inv_all
8613: WHERE period_id = p_period_id
8614: AND (NVL(actual_exp_code, 'N') = 'Y' OR
8615: NVL(variance_exp_code, 'N') = 'Y' OR
8616: NVL(forecasted_exp_code, 'N') = 'Y')

Line 8621: l_actual_invoiced_amount pn_var_rent_inv_all.actual_invoiced_amount%TYPE;

8617: /*AND NVL(actual_invoiced_amount, 0) <> 0*/
8618: AND invoice_date = p_invoice_date);
8619:
8620:
8621: l_actual_invoiced_amount pn_var_rent_inv_all.actual_invoiced_amount%TYPE;
8622: l_rowid ROWID;
8623: l_var_rent_inv_id NUMBER;
8624: l_date DATE := SYSDATE;
8625: l_errbuf VARCHAR2(250) := NULL;

Line 8644: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp

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 );
8646:
8647: /* Delete invoices for which there are no terms */
8648: DELETE pn_var_rent_inv_all

Line 8648: DELETE pn_var_rent_inv_all

8644: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp
8645: WHERE pvi.period_id = p_period_id );
8646:
8647: /* Delete invoices for which there are no terms */
8648: DELETE pn_var_rent_inv_all
8649: WHERE period_id = p_period_id
8650: AND actual_exp_code = 'N'
8651: AND forecasted_exp_code = 'N'
8652: AND variance_exp_code = 'N';

Line 8821: FROM pn_var_rent_inv_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:
8824: DELETE pn_var_rent_inv_all
8825: WHERE var_rent_id = p_var_rent_id;

Line 8824: DELETE pn_var_rent_inv_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:
8824: DELETE pn_var_rent_inv_all
8825: WHERE var_rent_id = p_var_rent_id;
8826:
8827: DELETE pn_var_grp_dates_all
8828: WHERE var_rent_id = p_var_rent_id;

Line 8902: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp,

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
8904: WHERE pvi.period_id = pvp.period_id
8905: AND pvr.var_rent_id = pvp.var_rent_id
8906: AND pvr.var_rent_id = p_var_rent_id);

Line 9679: FROM pn_var_rent_inv_all

9675:
9676: /* This cursor fetches the invoices for LY/FLY calculation */
9677: CURSOR invoice_date_cur (p_period_id NUMBER) IS
9678: SELECT DISTINCT invoice_date
9679: FROM pn_var_rent_inv_all
9680: WHERE period_id = p_period_id
9681: AND NVL(actual_exp_code, 'N') = 'Y'
9682: AND NVL(actual_invoiced_amount, 0) <> 0;
9683:

Line 9689: FROM pn_var_rent_inv_all

9685: CURSOR invoice_cur ( p_period_id NUMBER
9686: ,p_invoice_date DATE
9687: ,p_adjust_num NUMBER) IS
9688: SELECT *
9689: FROM pn_var_rent_inv_all
9690: WHERE period_id = p_period_id
9691: AND (NVL(actual_exp_code, 'N') = 'Y' OR
9692: NVL(variance_exp_code, 'N') = 'Y')
9693: AND NVL(actual_invoiced_amount, 0) <> 0

Line 9701: FROM pn_var_rent_inv_all

9697: /* Fetches the amount for the particular invoice date */
9698: CURSOR actual_invoice_amount (p_period_id NUMBER,
9699: p_invoice_date DATE) IS
9700: SELECT SUM(actual_invoiced_amount) actual_amount
9701: FROM pn_var_rent_inv_all
9702: WHERE var_rent_inv_id IN ( SELECT var_rent_inv_id
9703: FROM pn_var_rent_inv_all
9704: WHERE period_id = p_period_id
9705: AND (NVL(actual_exp_code, 'N') = 'Y' OR

Line 9703: FROM pn_var_rent_inv_all

9699: p_invoice_date DATE) IS
9700: SELECT SUM(actual_invoiced_amount) actual_amount
9701: FROM pn_var_rent_inv_all
9702: WHERE var_rent_inv_id IN ( SELECT var_rent_inv_id
9703: FROM pn_var_rent_inv_all
9704: WHERE period_id = p_period_id
9705: AND (NVL(actual_exp_code, 'N') = 'Y' OR
9706: NVL(variance_exp_code, 'N') = 'Y')
9707: AND NVL(actual_invoiced_amount, 0) <> 0

Line 9715: FROM pn_var_rent_inv_all

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'
9718: AND NVL(actual_invoiced_amount, 0) <> 0);
9719:

Line 9724: FROM pn_var_rent_inv_all

9720: /* Fetches the maximum adjust num cursor */
9721: CURSOR max_adjust_num_cur (p_period_id NUMBER,
9722: p_invoice_date DATE) IS
9723: SELECT max(adjust_num) max_adjust_num
9724: FROM pn_var_rent_inv_all
9725: WHERE period_id = p_period_id
9726: AND invoice_date = p_invoice_date;
9727:
9728: l_rowid ROWID;

Line 9739: FROM pn_var_rent_inv_all

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')
9742: AND status <> 'APPROVED';
9743:

Line 9744: DELETE pn_var_rent_inv_all

9740: WHERE period_id = p_last_period_id
9741: AND NVL(actual_exp_code, 'N') <> 'Y')
9742: AND status <> 'APPROVED';
9743:
9744: DELETE pn_var_rent_inv_all
9745: WHERE period_id = p_last_period_id
9746: AND NVL(actual_exp_code, 'N') <> 'Y';
9747:
9748: pnp_debug_pkg.debug ('Loop for invoices for true up and for last year calculation. ');

Line 10996: FROM pn_var_rent_inv_all inv

10992: SELECT 1
10993: INTO l_inv_exp
10994: FROM dual
10995: WHERE EXISTS ( SELECT inv.var_rent_inv_id
10996: FROM pn_var_rent_inv_all inv
10997: WHERE inv.var_rent_id = p_var_rent_id
10998: AND inv.invoice_date = p_invoice_date
10999: AND (forecasted_exp_code = 'Y'));
11000: