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: -- 12-NOV-2010 vkatta o Bug#10269475. Included PN_VRA_CLIENT_EXTN.client_extension
3914: -- to modify the variable rent.

Line 4211: pn_var_trx_headers_all

4207:
4208: --- Bug#10269475
4209:
4210: UPDATE
4211: pn_var_trx_headers_all
4212: SET
4213: calculated_rent = round(l_trx_hrd_r.calculated_rent,g_precision)
4214: ,prorated_rent_due = round(l_trx_hrd_r.prorated_rent_due,g_precision)
4215: ,percent_rent_due = round(l_trx_hrd_r.percent_rent_due,g_precision)

Line 4223: pnp_debug_pkg.log (' After Update of pn_var_trx_headers_all - Actual Rents ');

4219: trx_header_id = l_trx_hrd_r.trx_header_id;
4220:
4221: --- Bug#10269475
4222:
4223: pnp_debug_pkg.log (' After Update of pn_var_trx_headers_all - Actual Rents ');
4224: pnp_debug_pkg.log (' l_trx_hrd_r.calculated_rent : ' || l_trx_hrd_r.calculated_rent);
4225: pnp_debug_pkg.log (' l_trx_hrd_r.prorated_rent_due : ' || l_trx_hrd_r.prorated_rent_due);
4226: pnp_debug_pkg.log (' l_trx_hrd_r.percent_rent_due : ' || l_trx_hrd_r.percent_rent_due);
4227: pnp_debug_pkg.log (' l_trx_hrd_r.ytd_percent_rent : ' || l_trx_hrd_r.ytd_percent_rent);

Line 4340: pn_var_trx_headers_all

4336:
4337: --- Bug#10269475
4338:
4339: UPDATE
4340: pn_var_trx_headers_all
4341: SET
4342: calculated_rent_for = round(l_trx_hrd_for_r.calculated_rent_for,g_precision)
4343: ,percent_rent_due_for = round(l_trx_hrd_for_r.percent_rent_due_for,g_precision)
4344: ,ytd_percent_rent_for = round(l_trx_hrd_for_r.ytd_percent_rent_for,g_precision)

Line 4350: pnp_debug_pkg.log (' After update of pn_var_trx_headers_all procedure - g_invoice_on = G_INV_ON_FORECASTED');

4346: trx_header_id = l_trx_hrd_for_r.trx_header_id;
4347:
4348: --- Bug#10269475
4349:
4350: pnp_debug_pkg.log (' After update of pn_var_trx_headers_all procedure - g_invoice_on = G_INV_ON_FORECASTED');
4351: pnp_debug_pkg.log (' l_trx_hrd_for_r.trx_header_id : ' || l_trx_hrd_for_r.trx_header_id);
4352: pnp_debug_pkg.log (' l_trx_hrd_for_r.calculated_rent_for : ' || l_trx_hrd_for_r.calculated_rent_for);
4353: pnp_debug_pkg.log (' l_trx_hrd_for_r.percent_rent_due_for : ' || l_trx_hrd_for_r.percent_rent_due_for);
4354: pnp_debug_pkg.log (' l_trx_hrd_for_r.ytd_percent_rent_for : ' || l_trx_hrd_for_r.ytd_percent_rent_for);

Line 5522: pn_var_trx_headers_all

5518: ,p_rst_grp_id IN NUMBER
5519: ,p_date IN DATE) IS
5520: SELECT NVL(SUM(percent_rent_due_for), 0) AS prev_billed_amt
5521: FROM
5522: pn_var_trx_headers_all
5523: WHERE
5524: var_rent_id = p_vr_id AND
5525: period_id = p_prd_id AND
5526: line_item_id = p_line_id AND

Line 5583: FROM pn_var_trx_headers_all hdr,

5579: dtls.blended_period_vol_start,
5580: dtls.blended_period_vol_end,
5581: hdr.prorated_group_sales_for,
5582: hdr.ytd_sales_for
5583: FROM pn_var_trx_headers_all hdr,
5584: pn_var_trx_details_all dtls
5585: WHERE hdr.trx_header_id=dtls.trx_header_id
5586: AND dtls.trx_detail_id = detail_id;
5587:

Line 6016: pn_var_trx_headers_all hdr

6012: , 0) AS rent
6013: ,NVL(SUM(hdr.prorated_group_sales_for)
6014: , 0) AS sales
6015: FROM
6016: pn_var_trx_headers_all hdr
6017: WHERE
6018: hdr.var_rent_id = p_vr_id AND
6019: hdr.period_id = p_prd_id AND
6020: hdr.line_item_id = p_line_id AND

Line 6131: pn_var_trx_headers_all hdr

6127:
6128: END IF;
6129:
6130: UPDATE
6131: pn_var_trx_headers_all hdr
6132: SET
6133: hdr.var_rent_summ_id = l_vr_summ_id
6134: WHERE
6135: hdr.var_rent_id = p_var_rent_id AND

Line 6213: pn_var_trx_headers_all hdr

6209: , 0) AS rent
6210: ,NVL(SUM(hdr.prorated_group_sales_for)
6211: , 0) AS sales
6212: FROM
6213: pn_var_trx_headers_all hdr
6214: WHERE
6215: hdr.var_rent_id = p_vr_id AND
6216: hdr.period_id = p_prd_id AND
6217: hdr.line_item_id = p_line_id AND

Line 6343: pn_var_trx_headers_all hdr

6339: l_vr_summ_id;
6340: pnp_debug_pkg.log('Inserted rent summ with id: '||l_vr_summ_id);
6341: END IF;
6342: UPDATE
6343: pn_var_trx_headers_all hdr
6344: SET
6345: hdr.var_rent_summ_id = l_vr_summ_id
6346: WHERE
6347: hdr.var_rent_id = p_var_rent_id AND

Line 6776: pn_var_trx_headers_all

6772: trx_header_id IN
6773: (SELECT
6774: trx_header_id
6775: FROM
6776: pn_var_trx_headers_all
6777: WHERE
6778: var_rent_id = p_vr_id AND
6779: line_item_group_id = p_line_item_grp_id AND
6780: calc_prd_end_date >= (ADD_MONTHS(p_vr_term_date, -12) + 1))

Line 6833: pn_var_trx_headers_all

6829: trx_header_id IN
6830: (SELECT
6831: trx_header_id
6832: FROM
6833: pn_var_trx_headers_all
6834: WHERE
6835: var_rent_id = p_vr_id AND
6836: line_item_group_id = p_line_item_grp_id AND
6837: calc_prd_start_date <= (ADD_MONTHS(p_vr_comm_date, 12) - 1))

Line 6906: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr

6902: dtls.bkpt_rate,
6903: hdr.var_rent_id,
6904: hdr.period_id,
6905: hdr.line_item_group_id
6906: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr
6907: WHERE dtls.trx_detail_id = p_trx_detail_id
6908: AND hdr.trx_header_id = dtls.trx_header_id;
6909:
6910: BEGIN

Line 7014: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr

7010: dtls.bkpt_rate,
7011: hdr.var_rent_id,
7012: hdr.period_id,
7013: hdr.line_item_group_id
7014: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr
7015: WHERE dtls.trx_detail_id = p_trx_detail_id
7016: AND hdr.trx_header_id = dtls.trx_header_id;
7017:
7018: BEGIN

Line 7100: FROM pn_var_trx_headers_all

7096:
7097: /* This cursor fetches applicable sales for cumulative */
7098: CURSOR total_sales_C (p_trx_header_id NUMBER) IS
7099: SELECT (NVL(ytd_sales, 0) - NVL(ytd_deductions, 0)) applicable_sales
7100: FROM pn_var_trx_headers_all
7101: WHERE trx_header_id = p_trx_header_id;
7102:
7103: -- Get the details of
7104: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS

Line 7145: FROM pn_var_trx_headers_all hdr,

7141: hdr.prorated_group_sales,
7142: hdr.ytd_sales,
7143: hdr.prorated_group_deductions,
7144: hdr.ytd_deductions
7145: FROM pn_var_trx_headers_all hdr,
7146: pn_var_trx_details_all dtls
7147: WHERE hdr.trx_header_id=dtls.trx_header_id
7148: AND dtls.trx_detail_id = detail_id;
7149:

Line 7284: pn_var_trx_headers_all

7280: ,p_line_item_grp_id IN NUMBER) IS
7281: SELECT
7282: NVL(SUM(fy_proration_sales - NVL(fy_proration_deductions,0) ),0) AS sales
7283: FROM
7284: pn_var_trx_headers_all
7285: WHERE
7286: var_rent_id = p_vr_id AND
7287: line_item_group_id = p_line_item_grp_id AND
7288: calc_prd_start_date <= (ADD_MONTHS(p_vr_comm_date, 12) - 1) ;

Line 7327: pn_var_trx_headers_all

7323: ,p_line_item_grp_id IN NUMBER) IS
7324: SELECT
7325: NVL(SUM(ly_proration_sales - NVL(ly_proration_deductions,0) ),0) AS sales
7326: FROM
7327: pn_var_trx_headers_all
7328: WHERE
7329: var_rent_id = p_vr_id AND
7330: line_item_group_id = p_line_item_grp_id AND
7331: calc_prd_end_date >= (ADD_MONTHS(p_vr_term_date, -12) + 1);

Line 7390: pn_var_trx_headers_all

7386: ,p_line_item_grp_id IN NUMBER) IS
7387: SELECT
7388: NVL(SUM(fy_proration_sales),0) AS sales
7389: FROM
7390: pn_var_trx_headers_all
7391: WHERE
7392: var_rent_id = p_vr_id AND
7393: line_item_group_id = p_line_item_grp_id AND
7394: calc_prd_start_date <= (ADD_MONTHS(p_vr_comm_date, 12) - 1) ;

Line 7403: pn_var_trx_headers_all

7399: ,p_line_item_grp_id IN NUMBER) IS
7400: SELECT
7401: NVL(SUM(ly_proration_sales),0) AS sales
7402: FROM
7403: pn_var_trx_headers_all
7404: WHERE
7405: var_rent_id = p_vr_id AND
7406: line_item_group_id = p_line_item_grp_id AND
7407: calc_prd_end_date >= (ADD_MONTHS(p_vr_term_date, -12) + 1);

Line 7417: FROM pn_var_trx_headers_all hdr,

7413: hdr.prorated_group_sales,
7414: hdr.line_item_group_id,
7415: hdr.period_id,
7416: hdr.var_rent_id
7417: FROM pn_var_trx_headers_all hdr,
7418: pn_var_trx_details_all dtls
7419: WHERE hdr.trx_header_id = dtls.trx_header_id
7420: AND dtls.trx_detail_id = p_trx_detail_id;
7421:

Line 7528: FROM pn_var_trx_headers_all hdr,

7524: hdr.reporting_group_deductions,
7525: hdr.ytd_deductions,
7526: hdr.period_id,
7527: hdr.var_rent_id
7528: FROM pn_var_trx_headers_all hdr,
7529: pn_var_trx_details_all dtls
7530: WHERE hdr.trx_header_id = dtls.trx_header_id
7531: AND dtls.trx_detail_id = p_trx_detail_id;
7532:

Line 7633: pn_var_trx_headers_all

7629: ,p_line_item_grp_id IN NUMBER) IS
7630: SELECT
7631: NVL(SUM(fy_proration_deductions),0) AS deductions
7632: FROM
7633: pn_var_trx_headers_all
7634: WHERE
7635: var_rent_id = p_vr_id AND
7636: line_item_group_id = p_line_item_grp_id AND
7637: calc_prd_start_date <= (ADD_MONTHS(p_vr_comm_date, 12) - 1) ;

Line 7646: pn_var_trx_headers_all

7642: ,p_line_item_grp_id IN NUMBER) IS
7643: SELECT
7644: NVL(SUM(ly_proration_deductions),0) AS deductions
7645: FROM
7646: pn_var_trx_headers_all
7647: WHERE
7648: var_rent_id = p_vr_id AND
7649: line_item_group_id = p_line_item_grp_id AND
7650: calc_prd_end_date >= (ADD_MONTHS(p_vr_term_date, -12) + 1);

Line 7660: FROM pn_var_trx_headers_all hdr,

7656: hdr.ytd_deductions,
7657: hdr.line_item_group_id,
7658: hdr.period_id,
7659: hdr.var_rent_id
7660: FROM pn_var_trx_headers_all hdr,
7661: pn_var_trx_details_all dtls
7662: WHERE hdr.trx_header_id = dtls.trx_header_id
7663: AND dtls.trx_detail_id = p_trx_detail_id;
7664:

Line 7769: FROM pn_var_trx_headers_all hdr,

7765: hdr.var_rent_id,
7766: hdr.trx_header_id,
7767: hdr.calc_prd_start_date,
7768: hdr.line_item_id
7769: FROM pn_var_trx_headers_all hdr,
7770: pn_var_trx_details_all dtls
7771: WHERE hdr.trx_header_id = dtls.trx_header_id
7772: AND dtls.trx_detail_id = p_trx_detail_id;
7773:

Line 7779: FROM pn_var_trx_headers_all hdr

7775: /*CURSOR cum_sales_cur (p_period_id NUMBER,
7776: p_line_item_id NUMBER,
7777: p_calc_period_start_date DATE) IS
7778: SELECT NVL(SUM(hdr.prorated_group_sales), 0) - NVL(SUM(hdr.prorated_group_deductions), 0) sales
7779: FROM pn_var_trx_headers_all hdr
7780: WHERE hdr.period_id = p_period_id
7781: AND hdr.line_item_id = p_line_item_id
7782: AND hdr.calc_prd_start_date <= p_calc_period_start_date
7783: ORDER BY calc_prd_start_date;*/

Line 7892: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr

7888: dtls.bkpt_rate,
7889: hdr.var_rent_id,
7890: hdr.period_id,
7891: hdr.line_item_group_id
7892: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr
7893: WHERE dtls.trx_detail_id = p_trx_detail_id
7894: AND hdr.trx_header_id = dtls.trx_header_id;
7895:
7896: CURSOR blended_prd_csr (p_period_id IN NUMBER, p_bkpt_rate IN NUMBER) IS

Line 7899: pn_var_trx_headers_all hdr

7895:
7896: CURSOR blended_prd_csr (p_period_id IN NUMBER, p_bkpt_rate IN NUMBER) IS
7897: SELECT sum(dtls.prorated_grp_vol_start) bkpt_start
7898: FROM pn_var_trx_details_all dtls,
7899: pn_var_trx_headers_all hdr
7900: WHERE hdr.trx_header_id = dtls.trx_header_id
7901: AND hdr.period_id = p_period_id
7902: AND dtls.bkpt_rate = p_bkpt_rate;
7903:

Line 8038: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr

8034: dtls.bkpt_rate,
8035: hdr.var_rent_id,
8036: hdr.period_id,
8037: hdr.line_item_group_id
8038: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr
8039: WHERE dtls.trx_detail_id = p_trx_detail_id
8040: AND hdr.trx_header_id = dtls.trx_header_id;
8041:
8042: CURSOR blended_prd_csr (p_period_id IN NUMBER, p_bkpt_rate IN NUMBER) IS

Line 8046: pn_var_trx_headers_all hdr

8042: CURSOR blended_prd_csr (p_period_id IN NUMBER, p_bkpt_rate IN NUMBER) IS
8043: SELECT sum(prorated_grp_vol_start) bkpt_start,
8044: sum(prorated_grp_vol_end) bkpt_end
8045: FROM pn_var_trx_details_all dtls,
8046: pn_var_trx_headers_all hdr
8047: WHERE hdr.trx_header_id = dtls.trx_header_id
8048: AND hdr.period_id = p_period_id
8049: AND dtls.bkpt_rate = p_bkpt_rate;
8050:

Line 8181: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr,

8177: bkpts.group_bkpt_vol_start,
8178: hdr.var_rent_id,
8179: hdr.period_id,
8180: hdr.line_item_group_id
8181: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr,
8182: pn_var_bkpts_det_all bkpts
8183: WHERE dtls.trx_detail_id = p_trx_detail_id
8184: AND hdr.trx_header_id = dtls.trx_header_id
8185: AND bkpts.bkpt_detail_id = dtls.bkpt_detail_id;

Line 8292: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr,

8288: bkpts.group_bkpt_vol_end,
8289: hdr.var_rent_id,
8290: hdr.period_id,
8291: hdr.line_item_group_id
8292: FROM pn_var_trx_details_all dtls, pn_var_trx_headers_all hdr,
8293: pn_var_bkpts_det_all bkpts
8294: WHERE dtls.trx_detail_id = p_trx_detail_id
8295: AND hdr.trx_header_id = dtls.trx_header_id
8296: AND bkpts.bkpt_detail_id = dtls.bkpt_detail_id;

Line 8393: FROM pn_var_trx_headers_all hdr,

8389: SELECT hdr.percent_rent_due,
8390: hdr.first_yr_rent,
8391: hdr.period_id,
8392: hdr.var_rent_id
8393: FROM pn_var_trx_headers_all hdr,
8394: pn_var_trx_details_all dtls
8395: WHERE hdr.trx_header_id = dtls.trx_header_id
8396: AND dtls.trx_detail_id = p_trx_detail_id;
8397:

Line 8401: FROM pn_var_trx_headers_all

8397:
8398: -- Get the details of
8399: CURSOR first_yr_rent (p_var_rent_id NUMBER) IS
8400: SELECT SUM(first_yr_rent) first_yr_rent
8401: FROM pn_var_trx_headers_all
8402: WHERE var_rent_id = p_var_rent_id;
8403:
8404: -- Get the details of
8405: CURSOR last_yr_rent (p_period_id NUMBER) IS

Line 8407: FROM pn_var_trx_headers_all

8403:
8404: -- Get the details of
8405: CURSOR last_yr_rent (p_period_id NUMBER) IS
8406: SELECT (SUM(NVL(prorated_rent_due, 0)) - SUM(NVL(first_yr_rent, 0))) last_yr_rent
8407: FROM pn_var_trx_headers_all
8408: WHERE period_id = p_period_id;
8409:
8410:
8411:

Line 8493: FROM pn_var_trx_headers_all hdr,

8489: SELECT hdr.ytd_percent_rent,
8490: hdr.first_yr_rent,
8491: hdr.period_id,
8492: hdr.var_rent_id
8493: FROM pn_var_trx_headers_all hdr,
8494: pn_var_trx_details_all dtls
8495: WHERE hdr.trx_header_id = dtls.trx_header_id
8496: AND dtls.trx_detail_id = p_trx_detail_id;
8497:

Line 8501: FROM pn_var_trx_headers_all

8497:
8498: -- Get the details of
8499: CURSOR first_yr_rent (p_var_rent_id NUMBER) IS
8500: SELECT SUM(first_yr_rent) first_yr_rent
8501: FROM pn_var_trx_headers_all
8502: WHERE var_rent_id = p_var_rent_id;
8503:
8504: -- Get the details of
8505: CURSOR last_yr_rent (p_period_id NUMBER) IS

Line 8507: FROM pn_var_trx_headers_all

8503:
8504: -- Get the details of
8505: CURSOR last_yr_rent (p_period_id NUMBER) IS
8506: SELECT (SUM(NVL(prorated_rent_due, 0)) - SUM(NVL(first_yr_rent, 0))) last_yr_rent
8507: FROM pn_var_trx_headers_all
8508: WHERE period_id = p_period_id;
8509:
8510: l_rent NUMBER := 0;
8511: l_first_period VARCHAR2(1) := 'N';

Line 8574: pn_var_trx_headers_all

8570: ,p_line_item_grp_id IN NUMBER) IS
8571: SELECT
8572: NVL(SUM(fy_proration_sales - NVL(fy_proration_deductions,0) ),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_sales),0) AS sales
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 8684: pn_var_trx_headers_all

8680: ,p_line_item_grp_id IN NUMBER) IS
8681: SELECT
8682: NVL(SUM(fy_proration_deductions),0) AS deductions
8683: FROM
8684: pn_var_trx_headers_all
8685: WHERE
8686: var_rent_id = p_vr_id AND
8687: line_item_group_id = p_line_item_grp_id AND
8688: calc_prd_start_date <= (ADD_MONTHS(p_vr_comm_date, 12) - 1) ;

Line 8692: FROM pn_var_trx_headers_all trx,

8688: calc_prd_start_date <= (ADD_MONTHS(p_vr_comm_date, 12) - 1) ;
8689:
8690: CURSOR line_item_cur IS
8691: SELECT trx.line_item_group_id, pvr.commencement_date
8692: FROM pn_var_trx_headers_all trx,
8693: pn_var_rents_all pvr
8694: WHERE trx.var_rent_id = p_var_rent_id
8695: AND trx.var_rent_id = pvr.var_rent_id
8696: AND trx.line_item_id = p_line_item_id;

Line 8744: FROM pn_var_trx_headers_all hdr,

8740: SELECT dtls.ytd_group_vol_start AS trueup_bkpt_vol_start
8741: ,dtls.ytd_group_vol_end AS trueup_bkpt_vol_end
8742: ,hdr.ytd_sales AS trueup_volume
8743: ,hdr.ytd_deductions AS deductions
8744: FROM pn_var_trx_headers_all hdr,
8745: pn_var_trx_details_all dtls
8746: WHERE dtls.trx_detail_id = p_trx_detail_id
8747: AND dtls.bkpt_rate = p_rate
8748: AND dtls.trx_header_id = hdr.trx_header_id;

Line 9817: pn_var_trx_headers_all hdr

9813: ,NVL(SUM(hdr.prorated_group_deductions)
9814: , 0) AS ded
9815: ,NVL(SUM(hdr.first_yr_rent), 0) AS first_yr_rent
9816: FROM
9817: pn_var_trx_headers_all hdr
9818: WHERE
9819: hdr.var_rent_id = p_vr_id AND
9820: hdr.period_id = p_prd_id AND
9821: hdr.line_item_id = p_line_id AND

Line 9968: pn_var_trx_headers_all hdr

9964:
9965: END IF;
9966:
9967: UPDATE
9968: pn_var_trx_headers_all hdr
9969: SET
9970: hdr.var_rent_summ_id = l_vr_summ_id
9971: WHERE
9972: hdr.var_rent_id = p_var_rent_id AND

Line 10100: FROM pn_var_trx_headers_All

10096: -- Get the details of
10097: CURSOR trx_cur
10098: IS
10099: SELECT var_rent_id,period_id,grp_date_id,calc_prd_start_date
10100: FROM pn_var_trx_headers_All
10101: WHERE trx_header_id=p_trx_hdr_id;
10102:
10103: -- Get the details of
10104: CURSOR grp_date_cur(p_prd_id IN NUMBER,

Line 10117: FROM pn_var_trx_headers_all trx

10113: CURSOR calc_prd_cur(p_prd_id IN NUMBER,
10114: p_inv_end_dt IN DATE
10115: ) IS
10116: SELECT max(calc_prd_start_date) calc_prd_st_dt
10117: FROM pn_var_trx_headers_all trx
10118: WHERE trx.calc_prd_end_date <= p_inv_end_dt
10119: AND trx.period_id = p_prd_id;
10120:
10121: l_vr_id NUMBER :=NULL;

Line 10178: FROM pn_var_trx_headers_All

10174: -- Get the details of
10175: CURSOR trx_cur
10176: IS
10177: SELECT var_rent_id,period_id,grp_date_id,calc_prd_start_date
10178: FROM pn_var_trx_headers_All
10179: WHERE trx_header_id=p_trx_hdr_id;
10180:
10181: -- Get the details of
10182: CURSOR grp_date_cur(p_prd_id IN NUMBER,

Line 10268: FROM pn_var_trx_headers_All

10264: -- Get the details of
10265: CURSOR trx_cur
10266: IS
10267: SELECT var_rent_id,period_id,grp_date_id,calc_prd_start_date
10268: FROM pn_var_trx_headers_All
10269: WHERE trx_header_id=p_trx_hdr_id;
10270:
10271: -- Get the details of
10272: CURSOR grp_date_cur(p_prd_id IN NUMBER,

Line 10725: pn_var_trx_headers_all

10721: SUM(trueup_rent_due) AS trueup_rent
10722: ,MAX(calc_prd_end_date) AS trueup_date
10723: ,line_item_id
10724: FROM
10725: pn_var_trx_headers_all
10726: WHERE
10727: var_rent_id = p_var_rent_id AND
10728: period_id = p_period_id
10729: GROUP BY

Line 10789: pn_var_trx_headers_all hdr

10785: CURSOR get_blended_bkpt_csr(p_var_rent_id IN NUMBER) IS
10786: SELECT sum(pr_grp_blended_vol_start) bkpt_start,
10787: sum(pr_grp_blended_vol_end) bkpt_end
10788: FROM pn_var_trx_details_all dtls,
10789: pn_var_trx_headers_all hdr
10790: WHERE var_rent_id = p_var_rent_id
10791: AND hdr.trx_header_id = dtls.trx_header_id
10792: AND dtls.bkpt_rate = p_bkpt_rate
10793: GROUP BY dtls.bkpt_rate;

Line 10880: FROM pn_var_trx_headers_all

10876: IS
10877:
10878: CURSOR trx_header_cur IS
10879: SELECT max(calc_prd_end_date) end_date
10880: FROM pn_var_trx_headers_all
10881: WHERE period_id = p_period_id
10882: GROUP BY reset_group_id;
10883:
10884: CURSOR true_up_cur IS

Line 10886: FROM pn_var_trx_headers_all

10882: GROUP BY reset_group_id;
10883:
10884: CURSOR true_up_cur IS
10885: SELECT trueup_rent_due
10886: FROM pn_var_trx_headers_all
10887: WHERE trx_header_id = p_trx_hdr_id;
10888:
10889: l_true_up VARCHAR2(30) := 'N';
10890: