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_CALC_PKG dependencies on PN_VAR_TRX_HEADERS_ALL

Line 269: pn_var_trx_headers_all

265: ,p_rst_grp_id IN NUMBER
266: ,p_date IN DATE) IS
267: SELECT NVL(SUM(percent_rent_due), 0) AS prev_billed_amt
268: FROM
269: pn_var_trx_headers_all
270: WHERE
271: var_rent_id = p_vr_id AND
272: period_id = p_prd_id AND
273: line_item_id = p_line_id AND

Line 327: pn_var_trx_headers_all

323: ,p_rst_grp_id IN NUMBER
324: ,p_date IN DATE) IS
325: SELECT NVL(SUM(percent_rent_due), 0) AS prev_billed_amt
326: FROM
327: pn_var_trx_headers_all
328: WHERE
329: var_rent_id = p_vr_id AND
330: period_id IN (p_part_prd_id, p_full_prd_id) AND
331: line_item_group_id = p_line_grp_id AND

Line 437: pn_var_trx_headers_all

433: ,p_line_item_grp_id IN NUMBER) IS
434: SELECT
435: NVL(SUM(fy_proration_sales - NVL(fy_proration_deductions,0) ),0) AS sales
436: FROM
437: pn_var_trx_headers_all
438: WHERE
439: var_rent_id = p_vr_id AND
440: line_item_group_id = p_line_item_grp_id AND
441: calc_prd_start_date <= (ADD_MONTHS(p_vr_comm_date, 12) - 1) ;

Line 458: pn_var_trx_headers_all

454: trx_header_id IN
455: (SELECT
456: trx_header_id
457: FROM
458: pn_var_trx_headers_all
459: WHERE
460: var_rent_id = p_vr_id AND
461: line_item_group_id = p_line_item_grp_id AND
462: calc_prd_start_date <= (ADD_MONTHS(p_vr_comm_date, 12) - 1))

Line 491: pn_var_trx_headers_all

487: ,p_line_item_grp_id IN NUMBER) IS
488: SELECT
489: NVL(SUM(ly_proration_sales - NVL(ly_proration_deductions,0) ),0) AS sales
490: FROM
491: pn_var_trx_headers_all
492: WHERE
493: var_rent_id = p_vr_id AND
494: line_item_group_id = p_line_item_grp_id AND
495: calc_prd_end_date >= (ADD_MONTHS(p_vr_term_date, -12) + 1);

Line 512: pn_var_trx_headers_all

508: trx_header_id IN
509: (SELECT
510: trx_header_id
511: FROM
512: pn_var_trx_headers_all
513: WHERE
514: var_rent_id = p_vr_id AND
515: line_item_group_id = p_line_item_grp_id AND
516: calc_prd_end_date >= (ADD_MONTHS(p_vr_term_date, -12) + 1))

Line 1429: pn_var_trx_headers_all hdr

1425: , 0) AS sales
1426: ,NVL(SUM(hdr.prorated_group_deductions)
1427: , 0) AS ded
1428: FROM
1429: pn_var_trx_headers_all hdr
1430: WHERE
1431: hdr.var_rent_id = p_vr_id AND
1432: hdr.period_id = p_prd_id AND
1433: hdr.line_item_id = p_line_id AND

Line 1554: pn_var_trx_headers_all hdr

1550:
1551: END IF;
1552:
1553: UPDATE
1554: pn_var_trx_headers_all hdr
1555: SET
1556: hdr.var_rent_summ_id = l_vr_summ_id
1557: WHERE
1558: hdr.var_rent_id = p_var_rent_id AND

Line 1620: FROM pn_var_trx_headers_all trx

1616: -- Get the details of
1617: CURSOR line_item_cur ( p_period_id NUMBER,
1618: p_line_item_id NUMBER) IS
1619: SELECT trx.line_item_id
1620: FROM pn_var_trx_headers_all trx
1621: WHERE trx.period_id = p_period_id
1622: AND trx.line_item_group_id IN (SELECT line_item_group_id
1623: FROM pn_var_trx_headers_all
1624: WHERE line_item_id = p_line_item_id);

Line 1623: FROM pn_var_trx_headers_all

1619: SELECT trx.line_item_id
1620: FROM pn_var_trx_headers_all trx
1621: WHERE trx.period_id = p_period_id
1622: AND trx.line_item_group_id IN (SELECT line_item_group_id
1623: FROM pn_var_trx_headers_all
1624: WHERE line_item_id = p_line_item_id);
1625:
1626: -- Get the details of
1627: CURSOR first_period_cur IS

Line 1728: pn_var_trx_headers_all hdr

1724: l_vr_summ_id;
1725: END IF;
1726:
1727: UPDATE
1728: pn_var_trx_headers_all hdr
1729: SET
1730: hdr.var_rent_summ_id = l_vr_summ_id
1731: WHERE
1732: hdr.var_rent_id = p_var_rent_id AND

Line 1841: pn_var_trx_headers_all

1837: ,p_vr_comm_date IN DATE) IS
1838: SELECT
1839: NVL(SUM(fy_proration_sales - NVL(fy_proration_deductions,0) ),0) AS sales
1840: FROM
1841: pn_var_trx_headers_all
1842: WHERE
1843: var_rent_id = p_vr_id AND
1844: calc_prd_start_date <= (ADD_MONTHS(p_vr_comm_date, 12) - 1) ;
1845:

Line 2214: pn_var_trx_headers_all

2210: ,p_vr_term_date IN DATE) IS
2211: SELECT
2212: NVL(SUM(ly_proration_sales - NVL(ly_proration_deductions,0) ),0) AS sales
2213: FROM
2214: pn_var_trx_headers_all
2215: WHERE
2216: var_rent_id = p_vr_id AND
2217: calc_prd_end_date >= (ADD_MONTHS(p_vr_term_date, -12) + 1);
2218:

Line 3910: -- pn_var_trx_headers_all

3906: -- records are created. Not doing this cause wrong true_up
3907: --
3908: -- dd-mon-yyyy name o Created
3909: -- 23/05/07 Lokesh o Added rounding off for bug # 6031202 in
3910: -- pn_var_trx_headers_all
3911: -- 21-AUG-2008 acprakas o Bug#6849764. Modified cursor periods_c to get details
3912: -- for only the period id passed as paramater.
3913: --------------------------------------------------------------------------------
3914: PROCEDURE calculate_rent( p_var_rent_id IN NUMBER

Line 4180: pn_var_trx_headers_all

4176: <> NVL(l_trx_hrd_r.first_yr_rent, 0)
4177: THEN
4178:
4179: UPDATE
4180: pn_var_trx_headers_all
4181: SET
4182: calculated_rent = round(l_trx_hrd_r.calculated_rent,g_precision)
4183: ,prorated_rent_due = round(l_trx_hrd_r.prorated_rent_due,g_precision)
4184: ,percent_rent_due = round(l_trx_hrd_r.percent_rent_due,g_precision)

Line 4274: pn_var_trx_headers_all

4270: pnp_debug_pkg.log('l_trx_hrd_for_r.calculated_rent_for'||l_trx_hrd_for_r.calculated_rent_for);
4271: pnp_debug_pkg.log('l_trx_hrd_for_r.trx_header_id'||l_trx_hrd_for_r.trx_header_id);
4272:
4273: UPDATE
4274: pn_var_trx_headers_all
4275: SET
4276: calculated_rent_for = round(l_trx_hrd_for_r.calculated_rent_for,g_precision)
4277: ,percent_rent_due_for = round(l_trx_hrd_for_r.percent_rent_due_for,g_precision)
4278: ,ytd_percent_rent_for = round(l_trx_hrd_for_r.ytd_percent_rent_for,g_precision)

Line 5433: pn_var_trx_headers_all

5429: ,p_rst_grp_id IN NUMBER
5430: ,p_date IN DATE) IS
5431: SELECT NVL(SUM(percent_rent_due_for), 0) AS prev_billed_amt
5432: FROM
5433: pn_var_trx_headers_all
5434: WHERE
5435: var_rent_id = p_vr_id AND
5436: period_id = p_prd_id AND
5437: line_item_id = p_line_id AND

Line 5494: FROM pn_var_trx_headers_all hdr,

5490: dtls.blended_period_vol_start,
5491: dtls.blended_period_vol_end,
5492: hdr.prorated_group_sales_for,
5493: hdr.ytd_sales_for
5494: FROM pn_var_trx_headers_all hdr,
5495: pn_var_trx_details_all dtls
5496: WHERE hdr.trx_header_id=dtls.trx_header_id
5497: AND dtls.trx_detail_id = detail_id;
5498:

Line 5927: pn_var_trx_headers_all hdr

5923: , 0) AS rent
5924: ,NVL(SUM(hdr.prorated_group_sales_for)
5925: , 0) AS sales
5926: FROM
5927: pn_var_trx_headers_all hdr
5928: WHERE
5929: hdr.var_rent_id = p_vr_id AND
5930: hdr.period_id = p_prd_id AND
5931: hdr.line_item_id = p_line_id AND

Line 6042: pn_var_trx_headers_all hdr

6038:
6039: END IF;
6040:
6041: UPDATE
6042: pn_var_trx_headers_all hdr
6043: SET
6044: hdr.var_rent_summ_id = l_vr_summ_id
6045: WHERE
6046: hdr.var_rent_id = p_var_rent_id AND

Line 6124: pn_var_trx_headers_all hdr

6120: , 0) AS rent
6121: ,NVL(SUM(hdr.prorated_group_sales_for)
6122: , 0) AS sales
6123: FROM
6124: pn_var_trx_headers_all hdr
6125: WHERE
6126: hdr.var_rent_id = p_vr_id AND
6127: hdr.period_id = p_prd_id AND
6128: hdr.line_item_id = p_line_id AND

Line 6254: pn_var_trx_headers_all hdr

6250: l_vr_summ_id;
6251: pnp_debug_pkg.log('Inserted rent summ with id: '||l_vr_summ_id);
6252: END IF;
6253: UPDATE
6254: pn_var_trx_headers_all hdr
6255: SET
6256: hdr.var_rent_summ_id = l_vr_summ_id
6257: WHERE
6258: hdr.var_rent_id = p_var_rent_id AND

Line 6297: FROM pn_var_trx_headers_all trx, pn_var_rent_summ_all summ

6293: /* Fetch the summary id and transaction id from respective tables */
6294: CURSOR summ_id_cur (p_var_rent_id NUMBER) IS
6295: SELECT /*+ leading(trx) */
6296: summ.var_rent_summ_id, trx.trx_header_id
6297: FROM pn_var_trx_headers_all trx, pn_var_rent_summ_all summ
6298: WHERE trx.grp_date_id = summ.grp_date_id
6299: AND trx.var_rent_id = p_var_rent_id
6300: AND trx.var_rent_summ_id IS NULL;
6301:

Line 6302: TYPE summ_id_tab_type IS TABLE OF pn_var_trx_headers_all.var_rent_summ_id%TYPE

6298: WHERE trx.grp_date_id = summ.grp_date_id
6299: AND trx.var_rent_id = p_var_rent_id
6300: AND trx.var_rent_summ_id IS NULL;
6301:
6302: TYPE summ_id_tab_type IS TABLE OF pn_var_trx_headers_all.var_rent_summ_id%TYPE
6303: INDEX BY BINARY_INTEGER;
6304:
6305: TYPE trx_id_tab_type IS TABLE OF pn_var_trx_headers_all.trx_header_id%TYPE
6306: INDEX BY BINARY_INTEGER;

Line 6305: TYPE trx_id_tab_type IS TABLE OF pn_var_trx_headers_all.trx_header_id%TYPE

6301:
6302: TYPE summ_id_tab_type IS TABLE OF pn_var_trx_headers_all.var_rent_summ_id%TYPE
6303: INDEX BY BINARY_INTEGER;
6304:
6305: TYPE trx_id_tab_type IS TABLE OF pn_var_trx_headers_all.trx_header_id%TYPE
6306: INDEX BY BINARY_INTEGER;
6307:
6308: l_summ_id_tab summ_id_tab_type;
6309: l_trx_id_tab trx_id_tab_type;

Line 6323: UPDATE pn_var_trx_headers_all

6319: FETCH summ_id_cur BULK COLLECT INTO l_summ_id_tab,l_trx_id_tab;
6320: CLOSE summ_id_cur;
6321:
6322: FORALL i IN 1.. l_trx_id_tab.COUNT
6323: UPDATE pn_var_trx_headers_all
6324: SET var_rent_summ_id = l_summ_id_tab(i)
6325: WHERE trx_header_id = l_trx_id_tab(i);
6326:
6327: END update_summ_id;

Line 6721: pn_var_trx_headers_all

6717: trx_header_id IN
6718: (SELECT
6719: trx_header_id
6720: FROM
6721: pn_var_trx_headers_all
6722: WHERE
6723: var_rent_id = p_vr_id AND
6724: line_item_group_id = p_line_item_grp_id AND
6725: calc_prd_end_date >= (ADD_MONTHS(p_vr_term_date, -12) + 1))

Line 6778: pn_var_trx_headers_all

6774: trx_header_id IN
6775: (SELECT
6776: trx_header_id
6777: FROM
6778: pn_var_trx_headers_all
6779: WHERE
6780: var_rent_id = p_vr_id AND
6781: line_item_group_id = p_line_item_grp_id AND
6782: calc_prd_start_date <= (ADD_MONTHS(p_vr_comm_date, 12) - 1))

Line 6851: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr

6847: dtls.bkpt_rate,
6848: hdr.var_rent_id,
6849: hdr.period_id,
6850: hdr.line_item_group_id
6851: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr
6852: WHERE dtls.trx_detail_id = p_trx_detail_id
6853: AND hdr.trx_header_id = dtls.trx_header_id;
6854:
6855: BEGIN

Line 6959: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr

6955: dtls.bkpt_rate,
6956: hdr.var_rent_id,
6957: hdr.period_id,
6958: hdr.line_item_group_id
6959: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr
6960: WHERE dtls.trx_detail_id = p_trx_detail_id
6961: AND hdr.trx_header_id = dtls.trx_header_id;
6962:
6963: BEGIN

Line 7045: FROM pn_var_trx_headers_all

7041:
7042: /* This cursor fetches applicable sales for cumulative */
7043: CURSOR total_sales_C (p_trx_header_id NUMBER) IS
7044: SELECT (NVL(ytd_sales, 0) - NVL(ytd_deductions, 0)) applicable_sales
7045: FROM pn_var_trx_headers_all
7046: WHERE trx_header_id = p_trx_header_id;
7047:
7048: -- Get the details of
7049: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS

Line 7090: FROM pn_var_trx_headers_all hdr,

7086: hdr.prorated_group_sales,
7087: hdr.ytd_sales,
7088: hdr.prorated_group_deductions,
7089: hdr.ytd_deductions
7090: FROM pn_var_trx_headers_all hdr,
7091: pn_var_trx_details_all dtls
7092: WHERE hdr.trx_header_id=dtls.trx_header_id
7093: AND dtls.trx_detail_id = detail_id;
7094:

Line 7229: pn_var_trx_headers_all

7225: ,p_line_item_grp_id IN NUMBER) IS
7226: SELECT
7227: NVL(SUM(fy_proration_sales - NVL(fy_proration_deductions,0) ),0) AS sales
7228: FROM
7229: pn_var_trx_headers_all
7230: WHERE
7231: var_rent_id = p_vr_id AND
7232: line_item_group_id = p_line_item_grp_id AND
7233: calc_prd_start_date <= (ADD_MONTHS(p_vr_comm_date, 12) - 1) ;

Line 7272: pn_var_trx_headers_all

7268: ,p_line_item_grp_id IN NUMBER) IS
7269: SELECT
7270: NVL(SUM(ly_proration_sales - NVL(ly_proration_deductions,0) ),0) AS sales
7271: FROM
7272: pn_var_trx_headers_all
7273: WHERE
7274: var_rent_id = p_vr_id AND
7275: line_item_group_id = p_line_item_grp_id AND
7276: calc_prd_end_date >= (ADD_MONTHS(p_vr_term_date, -12) + 1);

Line 7335: pn_var_trx_headers_all

7331: ,p_line_item_grp_id IN NUMBER) IS
7332: SELECT
7333: NVL(SUM(fy_proration_sales),0) AS sales
7334: FROM
7335: pn_var_trx_headers_all
7336: WHERE
7337: var_rent_id = p_vr_id AND
7338: line_item_group_id = p_line_item_grp_id AND
7339: calc_prd_start_date <= (ADD_MONTHS(p_vr_comm_date, 12) - 1) ;

Line 7348: pn_var_trx_headers_all

7344: ,p_line_item_grp_id IN NUMBER) IS
7345: SELECT
7346: NVL(SUM(ly_proration_sales),0) AS sales
7347: FROM
7348: pn_var_trx_headers_all
7349: WHERE
7350: var_rent_id = p_vr_id AND
7351: line_item_group_id = p_line_item_grp_id AND
7352: calc_prd_end_date >= (ADD_MONTHS(p_vr_term_date, -12) + 1);

Line 7362: FROM pn_var_trx_headers_all hdr,

7358: hdr.prorated_group_sales,
7359: hdr.line_item_group_id,
7360: hdr.period_id,
7361: hdr.var_rent_id
7362: FROM pn_var_trx_headers_all hdr,
7363: pn_var_trx_details_all dtls
7364: WHERE hdr.trx_header_id = dtls.trx_header_id
7365: AND dtls.trx_detail_id = p_trx_detail_id;
7366:

Line 7473: FROM pn_var_trx_headers_all hdr,

7469: hdr.reporting_group_deductions,
7470: hdr.ytd_deductions,
7471: hdr.period_id,
7472: hdr.var_rent_id
7473: FROM pn_var_trx_headers_all hdr,
7474: pn_var_trx_details_all dtls
7475: WHERE hdr.trx_header_id = dtls.trx_header_id
7476: AND dtls.trx_detail_id = p_trx_detail_id;
7477:

Line 7578: pn_var_trx_headers_all

7574: ,p_line_item_grp_id IN NUMBER) IS
7575: SELECT
7576: NVL(SUM(fy_proration_deductions),0) AS deductions
7577: FROM
7578: pn_var_trx_headers_all
7579: WHERE
7580: var_rent_id = p_vr_id AND
7581: line_item_group_id = p_line_item_grp_id AND
7582: calc_prd_start_date <= (ADD_MONTHS(p_vr_comm_date, 12) - 1) ;

Line 7591: pn_var_trx_headers_all

7587: ,p_line_item_grp_id IN NUMBER) IS
7588: SELECT
7589: NVL(SUM(ly_proration_deductions),0) AS deductions
7590: FROM
7591: pn_var_trx_headers_all
7592: WHERE
7593: var_rent_id = p_vr_id AND
7594: line_item_group_id = p_line_item_grp_id AND
7595: calc_prd_end_date >= (ADD_MONTHS(p_vr_term_date, -12) + 1);

Line 7605: FROM pn_var_trx_headers_all hdr,

7601: hdr.ytd_deductions,
7602: hdr.line_item_group_id,
7603: hdr.period_id,
7604: hdr.var_rent_id
7605: FROM pn_var_trx_headers_all hdr,
7606: pn_var_trx_details_all dtls
7607: WHERE hdr.trx_header_id = dtls.trx_header_id
7608: AND dtls.trx_detail_id = p_trx_detail_id;
7609:

Line 7714: FROM pn_var_trx_headers_all hdr,

7710: hdr.var_rent_id,
7711: hdr.trx_header_id,
7712: hdr.calc_prd_start_date,
7713: hdr.line_item_id
7714: FROM pn_var_trx_headers_all hdr,
7715: pn_var_trx_details_all dtls
7716: WHERE hdr.trx_header_id = dtls.trx_header_id
7717: AND dtls.trx_detail_id = p_trx_detail_id;
7718:

Line 7724: FROM pn_var_trx_headers_all hdr

7720: /*CURSOR cum_sales_cur (p_period_id NUMBER,
7721: p_line_item_id NUMBER,
7722: p_calc_period_start_date DATE) IS
7723: SELECT NVL(SUM(hdr.prorated_group_sales), 0) - NVL(SUM(hdr.prorated_group_deductions), 0) sales
7724: FROM pn_var_trx_headers_all hdr
7725: WHERE hdr.period_id = p_period_id
7726: AND hdr.line_item_id = p_line_item_id
7727: AND hdr.calc_prd_start_date <= p_calc_period_start_date
7728: ORDER BY calc_prd_start_date;*/

Line 7837: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr

7833: dtls.bkpt_rate,
7834: hdr.var_rent_id,
7835: hdr.period_id,
7836: hdr.line_item_group_id
7837: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr
7838: WHERE dtls.trx_detail_id = p_trx_detail_id
7839: AND hdr.trx_header_id = dtls.trx_header_id;
7840:
7841: CURSOR blended_prd_csr (p_period_id IN NUMBER, p_bkpt_rate IN NUMBER) IS

Line 7844: pn_var_trx_headers_all hdr

7840:
7841: CURSOR blended_prd_csr (p_period_id IN NUMBER, p_bkpt_rate IN NUMBER) IS
7842: SELECT sum(dtls.prorated_grp_vol_start) bkpt_start
7843: FROM pn_var_trx_details_all dtls,
7844: pn_var_trx_headers_all hdr
7845: WHERE hdr.trx_header_id = dtls.trx_header_id
7846: AND hdr.period_id = p_period_id
7847: AND dtls.bkpt_rate = p_bkpt_rate;
7848:

Line 7983: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr

7979: dtls.bkpt_rate,
7980: hdr.var_rent_id,
7981: hdr.period_id,
7982: hdr.line_item_group_id
7983: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr
7984: WHERE dtls.trx_detail_id = p_trx_detail_id
7985: AND hdr.trx_header_id = dtls.trx_header_id;
7986:
7987: CURSOR blended_prd_csr (p_period_id IN NUMBER, p_bkpt_rate IN NUMBER) IS

Line 7991: pn_var_trx_headers_all hdr

7987: CURSOR blended_prd_csr (p_period_id IN NUMBER, p_bkpt_rate IN NUMBER) IS
7988: SELECT sum(prorated_grp_vol_start) bkpt_start,
7989: sum(prorated_grp_vol_end) bkpt_end
7990: FROM pn_var_trx_details_all dtls,
7991: pn_var_trx_headers_all hdr
7992: WHERE hdr.trx_header_id = dtls.trx_header_id
7993: AND hdr.period_id = p_period_id
7994: AND dtls.bkpt_rate = p_bkpt_rate;
7995:

Line 8126: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr,

8122: bkpts.group_bkpt_vol_start,
8123: hdr.var_rent_id,
8124: hdr.period_id,
8125: hdr.line_item_group_id
8126: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr,
8127: pn_var_bkpts_det_all bkpts
8128: WHERE dtls.trx_detail_id = p_trx_detail_id
8129: AND hdr.trx_header_id = dtls.trx_header_id
8130: AND bkpts.bkpt_detail_id = dtls.bkpt_detail_id;

Line 8237: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr,

8233: bkpts.group_bkpt_vol_end,
8234: hdr.var_rent_id,
8235: hdr.period_id,
8236: hdr.line_item_group_id
8237: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr,
8238: pn_var_bkpts_det_all bkpts
8239: WHERE dtls.trx_detail_id = p_trx_detail_id
8240: AND hdr.trx_header_id = dtls.trx_header_id
8241: AND bkpts.bkpt_detail_id = dtls.bkpt_detail_id;

Line 8338: FROM pn_var_trx_headers_all hdr,

8334: SELECT hdr.percent_rent_due,
8335: hdr.first_yr_rent,
8336: hdr.period_id,
8337: hdr.var_rent_id
8338: FROM pn_var_trx_headers_all hdr,
8339: pn_var_trx_details_all dtls
8340: WHERE hdr.trx_header_id = dtls.trx_header_id
8341: AND dtls.trx_detail_id = p_trx_detail_id;
8342:

Line 8346: FROM pn_var_trx_headers_all

8342:
8343: -- Get the details of
8344: CURSOR first_yr_rent (p_var_rent_id NUMBER) IS
8345: SELECT SUM(first_yr_rent) first_yr_rent
8346: FROM pn_var_trx_headers_all
8347: WHERE var_rent_id = p_var_rent_id;
8348:
8349: -- Get the details of
8350: CURSOR last_yr_rent (p_period_id NUMBER) IS

Line 8352: FROM pn_var_trx_headers_all

8348:
8349: -- Get the details of
8350: CURSOR last_yr_rent (p_period_id NUMBER) IS
8351: SELECT (SUM(NVL(prorated_rent_due, 0)) - SUM(NVL(first_yr_rent, 0))) last_yr_rent
8352: FROM pn_var_trx_headers_all
8353: WHERE period_id = p_period_id;
8354:
8355:
8356:

Line 8438: FROM pn_var_trx_headers_all hdr,

8434: SELECT hdr.ytd_percent_rent,
8435: hdr.first_yr_rent,
8436: hdr.period_id,
8437: hdr.var_rent_id
8438: FROM pn_var_trx_headers_all hdr,
8439: pn_var_trx_details_all dtls
8440: WHERE hdr.trx_header_id = dtls.trx_header_id
8441: AND dtls.trx_detail_id = p_trx_detail_id;
8442:

Line 8446: FROM pn_var_trx_headers_all

8442:
8443: -- Get the details of
8444: CURSOR first_yr_rent (p_var_rent_id NUMBER) IS
8445: SELECT SUM(first_yr_rent) first_yr_rent
8446: FROM pn_var_trx_headers_all
8447: WHERE var_rent_id = p_var_rent_id;
8448:
8449: -- Get the details of
8450: CURSOR last_yr_rent (p_period_id NUMBER) IS

Line 8452: FROM pn_var_trx_headers_all

8448:
8449: -- Get the details of
8450: CURSOR last_yr_rent (p_period_id NUMBER) IS
8451: SELECT (SUM(NVL(prorated_rent_due, 0)) - SUM(NVL(first_yr_rent, 0))) last_yr_rent
8452: FROM pn_var_trx_headers_all
8453: WHERE period_id = p_period_id;
8454:
8455: l_rent NUMBER := 0;
8456: l_first_period VARCHAR2(1) := 'N';

Line 8519: pn_var_trx_headers_all

8515: ,p_line_item_grp_id IN NUMBER) IS
8516: SELECT
8517: NVL(SUM(fy_proration_sales - NVL(fy_proration_deductions,0) ),0) AS sales
8518: FROM
8519: pn_var_trx_headers_all
8520: WHERE
8521: var_rent_id = p_vr_id AND
8522: line_item_group_id = p_line_item_grp_id AND
8523: calc_prd_start_date <= (ADD_MONTHS(p_vr_comm_date, 12) - 1) ;

Line 8527: FROM pn_var_trx_headers_all trx,

8523: calc_prd_start_date <= (ADD_MONTHS(p_vr_comm_date, 12) - 1) ;
8524:
8525: CURSOR line_item_cur IS
8526: SELECT trx.line_item_group_id, pvr.commencement_date
8527: FROM pn_var_trx_headers_all trx,
8528: pn_var_rents_all pvr
8529: WHERE trx.var_rent_id = p_var_rent_id
8530: AND trx.var_rent_id = pvr.var_rent_id
8531: AND trx.line_item_id = p_line_item_id;

Line 8574: pn_var_trx_headers_all

8570: ,p_line_item_grp_id IN NUMBER) IS
8571: SELECT
8572: NVL(SUM(fy_proration_sales),0) AS sales
8573: FROM
8574: pn_var_trx_headers_all
8575: WHERE
8576: var_rent_id = p_vr_id AND
8577: line_item_group_id = p_line_item_grp_id AND
8578: calc_prd_start_date <= (ADD_MONTHS(p_vr_comm_date, 12) - 1) ;

Line 8582: FROM pn_var_trx_headers_all trx,

8578: calc_prd_start_date <= (ADD_MONTHS(p_vr_comm_date, 12) - 1) ;
8579:
8580: CURSOR line_item_cur IS
8581: SELECT trx.line_item_group_id, pvr.commencement_date
8582: FROM pn_var_trx_headers_all trx,
8583: pn_var_rents_all pvr
8584: WHERE trx.var_rent_id = p_var_rent_id
8585: AND trx.var_rent_id = pvr.var_rent_id
8586: AND trx.line_item_id = p_line_item_id;

Line 8629: pn_var_trx_headers_all

8625: ,p_line_item_grp_id IN NUMBER) IS
8626: SELECT
8627: NVL(SUM(fy_proration_deductions),0) AS deductions
8628: FROM
8629: pn_var_trx_headers_all
8630: WHERE
8631: var_rent_id = p_vr_id AND
8632: line_item_group_id = p_line_item_grp_id AND
8633: calc_prd_start_date <= (ADD_MONTHS(p_vr_comm_date, 12) - 1) ;

Line 8637: FROM pn_var_trx_headers_all trx,

8633: calc_prd_start_date <= (ADD_MONTHS(p_vr_comm_date, 12) - 1) ;
8634:
8635: CURSOR line_item_cur IS
8636: SELECT trx.line_item_group_id, pvr.commencement_date
8637: FROM pn_var_trx_headers_all trx,
8638: pn_var_rents_all pvr
8639: WHERE trx.var_rent_id = p_var_rent_id
8640: AND trx.var_rent_id = pvr.var_rent_id
8641: AND trx.line_item_id = p_line_item_id;

Line 8689: FROM pn_var_trx_headers_all hdr,

8685: SELECT dtls.ytd_group_vol_start AS trueup_bkpt_vol_start
8686: ,dtls.ytd_group_vol_end AS trueup_bkpt_vol_end
8687: ,hdr.ytd_sales AS trueup_volume
8688: ,hdr.ytd_deductions AS deductions
8689: FROM pn_var_trx_headers_all hdr,
8690: pn_var_trx_details_all dtls
8691: WHERE dtls.trx_detail_id = p_trx_detail_id
8692: AND dtls.bkpt_rate = p_rate
8693: AND dtls.trx_header_id = hdr.trx_header_id;

Line 9762: pn_var_trx_headers_all hdr

9758: ,NVL(SUM(hdr.prorated_group_deductions)
9759: , 0) AS ded
9760: ,NVL(SUM(hdr.first_yr_rent), 0) AS first_yr_rent
9761: FROM
9762: pn_var_trx_headers_all hdr
9763: WHERE
9764: hdr.var_rent_id = p_vr_id AND
9765: hdr.period_id = p_prd_id AND
9766: hdr.line_item_id = p_line_id AND

Line 9913: pn_var_trx_headers_all hdr

9909:
9910: END IF;
9911:
9912: UPDATE
9913: pn_var_trx_headers_all hdr
9914: SET
9915: hdr.var_rent_summ_id = l_vr_summ_id
9916: WHERE
9917: hdr.var_rent_id = p_var_rent_id AND

Line 10045: FROM pn_var_trx_headers_All

10041: -- Get the details of
10042: CURSOR trx_cur
10043: IS
10044: SELECT var_rent_id,period_id,grp_date_id,calc_prd_start_date
10045: FROM pn_var_trx_headers_All
10046: WHERE trx_header_id=p_trx_hdr_id;
10047:
10048: -- Get the details of
10049: CURSOR grp_date_cur(p_prd_id IN NUMBER,

Line 10062: FROM pn_var_trx_headers_all trx

10058: CURSOR calc_prd_cur(p_prd_id IN NUMBER,
10059: p_inv_end_dt IN DATE
10060: ) IS
10061: SELECT max(calc_prd_start_date) calc_prd_st_dt
10062: FROM pn_var_trx_headers_all trx
10063: WHERE trx.calc_prd_end_date <= p_inv_end_dt
10064: AND trx.period_id = p_prd_id;
10065:
10066: l_vr_id NUMBER :=NULL;

Line 10123: FROM pn_var_trx_headers_All

10119: -- Get the details of
10120: CURSOR trx_cur
10121: IS
10122: SELECT var_rent_id,period_id,grp_date_id,calc_prd_start_date
10123: FROM pn_var_trx_headers_All
10124: WHERE trx_header_id=p_trx_hdr_id;
10125:
10126: -- Get the details of
10127: CURSOR grp_date_cur(p_prd_id IN NUMBER,

Line 10213: FROM pn_var_trx_headers_All

10209: -- Get the details of
10210: CURSOR trx_cur
10211: IS
10212: SELECT var_rent_id,period_id,grp_date_id,calc_prd_start_date
10213: FROM pn_var_trx_headers_All
10214: WHERE trx_header_id=p_trx_hdr_id;
10215:
10216: -- Get the details of
10217: CURSOR grp_date_cur(p_prd_id IN NUMBER,

Line 10670: pn_var_trx_headers_all

10666: SUM(trueup_rent_due) AS trueup_rent
10667: ,MAX(calc_prd_end_date) AS trueup_date
10668: ,line_item_id
10669: FROM
10670: pn_var_trx_headers_all
10671: WHERE
10672: var_rent_id = p_var_rent_id AND
10673: period_id = p_period_id
10674: GROUP BY

Line 10734: pn_var_trx_headers_all hdr

10730: CURSOR get_blended_bkpt_csr(p_var_rent_id IN NUMBER) IS
10731: SELECT sum(pr_grp_blended_vol_start) bkpt_start,
10732: sum(pr_grp_blended_vol_end) bkpt_end
10733: FROM pn_var_trx_details_all dtls,
10734: pn_var_trx_headers_all hdr
10735: WHERE var_rent_id = p_var_rent_id
10736: AND hdr.trx_header_id = dtls.trx_header_id
10737: AND dtls.bkpt_rate = p_bkpt_rate
10738: GROUP BY dtls.bkpt_rate;

Line 10825: FROM pn_var_trx_headers_all

10821: IS
10822:
10823: CURSOR trx_header_cur IS
10824: SELECT max(calc_prd_end_date) end_date
10825: FROM pn_var_trx_headers_all
10826: WHERE period_id = p_period_id
10827: GROUP BY reset_group_id;
10828:
10829: CURSOR true_up_cur IS

Line 10831: FROM pn_var_trx_headers_all

10827: GROUP BY reset_group_id;
10828:
10829: CURSOR true_up_cur IS
10830: SELECT trueup_rent_due
10831: FROM pn_var_trx_headers_all
10832: WHERE trx_header_id = p_trx_hdr_id;
10833:
10834: l_true_up VARCHAR2(30) := 'N';
10835: