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

Line 2701: FROM pn_var_rent_inv_all

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
2703: )
2704: )
2705: )

Line 2714: FROM pn_var_rent_inv_all

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
2716: )
2717: )
2718: AND NVL(export_to_ar_flag,'N') <>'Y' ;

Line 2732: FROM pn_var_rent_inv_all

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)
2734: AND NOT EXISTS
2735: (SELECT 1
2736: FROM pn_payment_items

Line 2743: FROM PN_VAR_RENT_INV_ALL

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
2745: )
2746: )
2747: );

Line 2753: DELETE FROM pn_var_rent_inv

2749: IF SQL%NOTFOUND THEN
2750: NULL;
2751: END IF;
2752:
2753: DELETE FROM pn_var_rent_inv
2754: WHERE var_rent_id = p_var_rent_id;
2755:
2756: IF SQL%NOTFOUND THEN
2757: NULL;

Line 3432: FROM pn_var_rent_inv_all inv

3428: SELECT 1
3429: INTO l_calculation_exists
3430: FROM dual
3431: WHERE EXISTS ( SELECT inv.var_rent_inv_id
3432: FROM pn_var_rent_inv_all inv
3433: WHERE inv.var_rent_id = p_var_rent_id);
3434:
3435: RETURN l_calculation_exists;
3436:

Line 3483: FROM pn_var_rent_inv_all inv

3479: SELECT 1
3480: INTO l_invoice_exists
3481: FROM dual
3482: WHERE EXISTS ( SELECT inv.var_rent_inv_id
3483: FROM pn_var_rent_inv_all inv
3484: WHERE inv.var_rent_id = p_var_rent_id);
3485:
3486: RETURN l_invoice_exists;
3487:

Line 3558: FROM pn_var_rent_inv_all

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
3560: )
3561: )
3562: AND export_to_ar_flag <>'Y' ;

Line 3574: FROM pn_var_rent_inv_all

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
3576: )
3577: )
3578: )

Line 3591: FROM pn_var_rent_inv_all

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)
3593: AND NOT EXISTS
3594: (SELECT 1
3595: FROM pn_payment_items

Line 3602: FROM PN_VAR_RENT_INV_ALL

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
3604: )
3605: )
3606: );

Line 3612: DELETE FROM pn_var_rent_inv

3608: IF SQL%NOTFOUND THEN
3609: NULL;
3610: END IF;
3611:
3612: DELETE FROM pn_var_rent_inv
3613: WHERE var_rent_id = p_var_rent_id;
3614:
3615: IF SQL%NOTFOUND THEN
3616: NULL;

Line 4767: | pn_var_rent_inv_all table.

Line 4880: FROM pn_var_rent_inv_all

4876: SELECT 1
4877: INTO l_exported
4878: FROM dual
4879: WHERE EXISTS ( SELECT VAR_RENT_INV_ID
4880: FROM pn_var_rent_inv_all
4881: WHERE var_rent_inv_id = p_id
4882: AND (actual_exp_code = 'Y' OR
4883: variance_exp_code = 'Y')
4884: );

Line 5081: FROM pn_var_rent_inv_ALL inv1

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

Line 5124: FROM pn_var_rent_inv_all INv,

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

Line 5132: FROM pn_var_rent_inv_all pvri

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

Line 5212: FROM pn_var_rent_inv_all

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);
5214:
5215: IF SQL%NOTFOUND THEN
5216: NULL;

Line 5219: DELETE FROM pn_var_rent_inv_all

5215: IF SQL%NOTFOUND THEN
5216: NULL;
5217: END IF;
5218:
5219: DELETE FROM pn_var_rent_inv_all
5220: WHERE var_rent_id = p_var_rent_id;
5221:
5222: IF SQL%NOTFOUND THEN
5223: NULL;

Line 5229: FROM pn_var_rent_inv_all

5225:
5226: DELETE FROM pn_var_abatements_all
5227: WHERE var_rent_inv_id IN
5228: (SELECT var_rent_inv_id
5229: FROM pn_var_rent_inv_all
5230: WHERE var_rent_id = p_var_rent_id);
5231:
5232: IF SQL%NOTFOUND THEN
5233: NULL;

Line 5342: PN_VAR_RENT_INV_ALL pvri,

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

Line 5355: PN_VAR_RENT_INV_ALL pvri

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

Line 7949: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp

7945:
7946: /* This cursor fetches the distinct invoices for periods starting after new termination date */
7947: CURSOR invoice_date_cur IS
7948: SELECT DISTINCT pvi.invoice_date, pvi.period_id
7949: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp
7950: WHERE pvp.period_id = pvi.period_id
7951: AND pvp.start_date > p_new_termn_date
7952: AND pvp.var_rent_id = p_var_rent_id;
7953:

Line 7960: FROM pn_var_rent_inv_all

7956: CURSOR rent_inv_cur ( p_period_id NUMBER
7957: ,p_invoice_date DATE
7958: ,p_adjust_num NUMBER) IS
7959: SELECT *
7960: FROM pn_var_rent_inv_all
7961: WHERE period_id = p_period_id
7962: AND (NVL(actual_exp_code, 'N') = 'Y' OR
7963: NVL(variance_exp_code, 'N') = 'Y' OR
7964: NVL(forecasted_exp_code, 'N') = 'Y' OR

Line 7981: FROM pn_var_rent_inv_all

7977: CURSOR term_status_cur ( p_period_id NUMBER
7978: ,p_invoice_date DATE
7979: ,p_adjust_num NUMBER) IS
7980: SELECT variance_exp_code, forecasted_exp_code
7981: FROM pn_var_rent_inv_all
7982: WHERE period_id = p_period_id
7983: AND (NVL(actual_exp_code, 'N') = 'Y' OR
7984: NVL(variance_exp_code, 'N') = 'Y' OR
7985: NVL(forecasted_exp_code, 'N') = 'Y' OR

Line 8008: FROM pn_var_rent_inv_all

8004:
8005: /* this cursor fetches invoice for a particular period */
8006: CURSOR invoice_cur (p_period_id NUMBER) IS
8007: SELECT var_rent_inv_id
8008: FROM pn_var_rent_inv_all
8009: WHERE period_id = p_period_id;
8010:
8011: /* This cursor fetches periods staring after new termination date for which there exists invoices */
8012: CURSOR period_inv_cur IS

Line 8018: FROM pn_var_rent_inv_all

8014: FROM pn_var_periods_all per
8015: WHERE per.var_rent_id = p_var_rent_id
8016: AND per.start_date > p_new_termn_date
8017: AND EXISTS (SELECT var_rent_inv_id
8018: FROM pn_var_rent_inv_all
8019: WHERE period_id = per.period_id);
8020:
8021: /* Fetches payment term information for a invoice id */
8022: CURSOR payment_cur(p_invoice_date DATE) IS

Line 8026: FROM pn_var_rent_inv_all

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

Line 8034: FROM pn_var_rent_inv_all

8030: /* Fetches the maximum adjust num cursor */
8031: CURSOR max_adjust_num_cur (p_period_id NUMBER,
8032: p_invoice_date DATE) IS
8033: SELECT max(adjust_num) max_adjust_num
8034: FROM pn_var_rent_inv_all
8035: WHERE period_id = p_period_id
8036: AND invoice_date = p_invoice_date;
8037:
8038: /*Bug#6524437

Line 8048: FROM pn_var_rent_inv_all

8044: /* Fetches the amount for the particular invoice date */
8045: CURSOR actual_invoice_amount (p_period_id NUMBER,
8046: p_invoice_date DATE) IS
8047: SELECT SUM(actual_invoiced_amount) actual_amount
8048: FROM pn_var_rent_inv_all
8049: WHERE var_rent_inv_id IN ( SELECT var_rent_inv_id
8050: FROM pn_var_rent_inv_all
8051: WHERE period_id = p_period_id
8052: AND (NVL(actual_exp_code, 'N') = 'Y' OR

Line 8050: FROM pn_var_rent_inv_all

8046: p_invoice_date DATE) IS
8047: SELECT SUM(actual_invoiced_amount) actual_amount
8048: FROM pn_var_rent_inv_all
8049: WHERE var_rent_inv_id IN ( SELECT var_rent_inv_id
8050: FROM pn_var_rent_inv_all
8051: WHERE period_id = p_period_id
8052: AND (NVL(actual_exp_code, 'N') = 'Y' OR
8053: NVL(variance_exp_code, 'N') = 'Y' OR
8054: NVL(forecasted_exp_code, 'N') = 'Y' OR

Line 8060: l_actual_invoiced_amount pn_var_rent_inv_all.actual_invoiced_amount%TYPE;

8056: /*AND NVL(actual_invoiced_amount, 0) <> 0*/
8057: AND invoice_date = p_invoice_date);
8058:
8059: l_invoice_exists VARCHAR2(1) := 'N';
8060: l_actual_invoiced_amount pn_var_rent_inv_all.actual_invoiced_amount%TYPE;
8061: l_rowid ROWID;
8062: l_var_rent_inv_id NUMBER;
8063: l_date DATE := SYSDATE;
8064: l_errbuf VARCHAR2(250) := NULL;

Line 8084: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp

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
8086: AND pvp.var_rent_id = p_var_rent_id
8087: AND pvp.start_date > p_new_termn_date);
8088:

Line 8090: DELETE pn_var_rent_inv_all

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

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 8176: pn_var_rent_inv_pkg.insert_row ( x_rowid => l_rowid,

8172: l_var_rent_inv_id := NULL;
8173: l_rowid := NULL;
8174:
8175:
8176: pn_var_rent_inv_pkg.insert_row ( x_rowid => l_rowid,
8177: x_var_rent_inv_id => l_var_rent_inv_id,
8178: x_adjust_num => l_max_adjust_num + 1,
8179: x_invoice_date => rent_inv_rec.invoice_date,
8180: x_for_per_rent => rent_inv_rec.for_per_rent ,

Line 8530: FROM pn_var_rent_inv_all

8526:
8527: /* This cursor fetches the distinct invoices for periods starting after new termination date */
8528: CURSOR invoice_date_cur IS
8529: SELECT DISTINCT invoice_date
8530: FROM pn_var_rent_inv_all
8531: WHERE period_id = p_period_id
8532: AND invoice_date > p_new_termn_date;
8533:
8534: /* This cursor fetches the invoices existing after the new termination date */

Line 8539: FROM pn_var_rent_inv_all

8535: CURSOR invoice_cur ( p_period_id NUMBER
8536: ,p_invoice_date DATE
8537: ,p_adjust_num NUMBER) IS
8538: SELECT *
8539: FROM pn_var_rent_inv_all
8540: WHERE period_id = p_period_id
8541: AND (NVL(actual_exp_code, 'N') = 'Y' OR
8542: NVL(variance_exp_code, 'N') = 'Y' OR
8543: NVL(forecasted_exp_code, 'N') = 'Y')

Line 8557: FROM pn_var_rent_inv_all

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

Line 8574: FROM pn_var_rent_inv_all

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

Line 8582: FROM pn_var_rent_inv_all

8578: /* Fetches the maximum adjust num cursor */
8579: CURSOR max_adjust_num_cur (p_period_id NUMBER,
8580: p_invoice_date DATE) IS
8581: SELECT max(adjust_num) max_adjust_num
8582: FROM pn_var_rent_inv_all
8583: WHERE period_id = p_period_id
8584: AND invoice_date = p_invoice_date
8585: AND true_up_amt IS NULL
8586: AND true_up_status IS NULL

Line 8593: FROM pn_var_rent_inv_all

8589: /* Fetches the amount for the particular invoice date */
8590: CURSOR actual_invoice_amount (p_period_id NUMBER,
8591: p_invoice_date DATE) IS
8592: SELECT SUM(actual_invoiced_amount) actual_amount
8593: FROM pn_var_rent_inv_all
8594: WHERE var_rent_inv_id IN ( SELECT var_rent_inv_id
8595: FROM pn_var_rent_inv_all
8596: WHERE period_id = p_period_id
8597: AND (NVL(actual_exp_code, 'N') = 'Y' OR

Line 8595: FROM pn_var_rent_inv_all

8591: p_invoice_date DATE) IS
8592: SELECT SUM(actual_invoiced_amount) actual_amount
8593: FROM pn_var_rent_inv_all
8594: WHERE var_rent_inv_id IN ( SELECT var_rent_inv_id
8595: FROM pn_var_rent_inv_all
8596: WHERE period_id = p_period_id
8597: AND (NVL(actual_exp_code, 'N') = 'Y' OR
8598: NVL(variance_exp_code, 'N') = 'Y' OR
8599: NVL(forecasted_exp_code, 'N') = 'Y')

Line 8604: l_actual_invoiced_amount pn_var_rent_inv_all.actual_invoiced_amount%TYPE;

8600: /*AND NVL(actual_invoiced_amount, 0) <> 0*/
8601: AND invoice_date = p_invoice_date);
8602:
8603:
8604: l_actual_invoiced_amount pn_var_rent_inv_all.actual_invoiced_amount%TYPE;
8605: l_rowid ROWID;
8606: l_var_rent_inv_id NUMBER;
8607: l_date DATE := SYSDATE;
8608: l_errbuf VARCHAR2(250) := NULL;

Line 8627: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp

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 );
8629:
8630: /* Delete invoices for which there are no terms */
8631: DELETE pn_var_rent_inv_all

Line 8631: DELETE pn_var_rent_inv_all

8627: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp
8628: WHERE pvi.period_id = p_period_id );
8629:
8630: /* Delete invoices for which there are no terms */
8631: DELETE pn_var_rent_inv_all
8632: WHERE period_id = p_period_id
8633: AND actual_exp_code = 'N'
8634: AND forecasted_exp_code = 'N'
8635: AND variance_exp_code = 'N';

Line 8680: pn_var_rent_inv_pkg.insert_row ( x_rowid => l_rowid,

8676: /* Set var rent inv id to null before inserting a row */
8677: l_var_rent_inv_id := NULL;
8678: l_rowid := NULL;
8679:
8680: pn_var_rent_inv_pkg.insert_row ( x_rowid => l_rowid,
8681: x_var_rent_inv_id => l_var_rent_inv_id,
8682: x_adjust_num => l_max_adjust_num + 1,
8683: x_invoice_date => invoice_rec.invoice_date,
8684: x_for_per_rent => invoice_rec.for_per_rent,

Line 8804: FROM pn_var_rent_inv_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:
8807: DELETE pn_var_rent_inv_all
8808: WHERE var_rent_id = p_var_rent_id;

Line 8807: DELETE pn_var_rent_inv_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:
8807: DELETE pn_var_rent_inv_all
8808: WHERE var_rent_id = p_var_rent_id;
8809:
8810: DELETE pn_var_grp_dates_all
8811: WHERE var_rent_id = p_var_rent_id;

Line 8885: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp,

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
8887: WHERE pvi.period_id = pvp.period_id
8888: AND pvr.var_rent_id = pvp.var_rent_id
8889: AND pvr.var_rent_id = p_var_rent_id);

Line 9662: FROM pn_var_rent_inv_all

9658:
9659: /* This cursor fetches the invoices for LY/FLY calculation */
9660: CURSOR invoice_date_cur (p_period_id NUMBER) IS
9661: SELECT DISTINCT invoice_date
9662: FROM pn_var_rent_inv_all
9663: WHERE period_id = p_period_id
9664: AND NVL(actual_exp_code, 'N') = 'Y'
9665: AND NVL(actual_invoiced_amount, 0) <> 0;
9666:

Line 9672: FROM pn_var_rent_inv_all

9668: CURSOR invoice_cur ( p_period_id NUMBER
9669: ,p_invoice_date DATE
9670: ,p_adjust_num NUMBER) IS
9671: SELECT *
9672: FROM pn_var_rent_inv_all
9673: WHERE period_id = p_period_id
9674: AND (NVL(actual_exp_code, 'N') = 'Y' OR
9675: NVL(variance_exp_code, 'N') = 'Y')
9676: AND NVL(actual_invoiced_amount, 0) <> 0

Line 9684: FROM pn_var_rent_inv_all

9680: /* Fetches the amount for the particular invoice date */
9681: CURSOR actual_invoice_amount (p_period_id NUMBER,
9682: p_invoice_date DATE) IS
9683: SELECT SUM(actual_invoiced_amount) actual_amount
9684: FROM pn_var_rent_inv_all
9685: WHERE var_rent_inv_id IN ( SELECT var_rent_inv_id
9686: FROM pn_var_rent_inv_all
9687: WHERE period_id = p_period_id
9688: AND (NVL(actual_exp_code, 'N') = 'Y' OR

Line 9686: FROM pn_var_rent_inv_all

9682: p_invoice_date DATE) IS
9683: SELECT SUM(actual_invoiced_amount) actual_amount
9684: FROM pn_var_rent_inv_all
9685: WHERE var_rent_inv_id IN ( SELECT var_rent_inv_id
9686: FROM pn_var_rent_inv_all
9687: WHERE period_id = p_period_id
9688: AND (NVL(actual_exp_code, 'N') = 'Y' OR
9689: NVL(variance_exp_code, 'N') = 'Y')
9690: AND NVL(actual_invoiced_amount, 0) <> 0

Line 9698: FROM pn_var_rent_inv_all

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

Line 9707: FROM pn_var_rent_inv_all

9703: /* Fetches the maximum adjust num cursor */
9704: CURSOR max_adjust_num_cur (p_period_id NUMBER,
9705: p_invoice_date DATE) IS
9706: SELECT max(adjust_num) max_adjust_num
9707: FROM pn_var_rent_inv_all
9708: WHERE period_id = p_period_id
9709: AND invoice_date = p_invoice_date;
9710:
9711: l_rowid ROWID;

Line 9722: FROM pn_var_rent_inv_all

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')
9725: AND status <> 'APPROVED';
9726:

Line 9727: DELETE pn_var_rent_inv_all

9723: WHERE period_id = p_last_period_id
9724: AND NVL(actual_exp_code, 'N') <> 'Y')
9725: AND status <> 'APPROVED';
9726:
9727: DELETE pn_var_rent_inv_all
9728: WHERE period_id = p_last_period_id
9729: AND NVL(actual_exp_code, 'N') <> 'Y';
9730:
9731: pnp_debug_pkg.debug ('Loop for invoices for true up and for last year calculation. ');

Line 9756: pn_var_rent_inv_pkg.insert_row ( x_rowid => l_rowid,

9752: /* Set var rent inv id to null before inserting a row */
9753: l_var_rent_inv_id := NULL;
9754: l_rowid := NULL;
9755:
9756: pn_var_rent_inv_pkg.insert_row ( x_rowid => l_rowid,
9757: x_var_rent_inv_id => l_var_rent_inv_id,
9758: x_adjust_num => l_max_adjust_num + 1,
9759: x_invoice_date => invoice_rec.invoice_date,
9760: x_for_per_rent => invoice_rec.for_per_rent,

Line 10979: FROM pn_var_rent_inv_all inv

10975: SELECT 1
10976: INTO l_inv_exp
10977: FROM dual
10978: WHERE EXISTS ( SELECT inv.var_rent_inv_id
10979: FROM pn_var_rent_inv_all inv
10980: WHERE inv.var_rent_id = p_var_rent_id
10981: AND inv.invoice_date = p_invoice_date
10982: AND (forecasted_exp_code = 'Y'));
10983: