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_GRP_DATES_ALL

Line 8: inv_date pn_var_grp_dates_all.invoice_date%TYPE,

4: ------------------------- COMMON DATA STRUCTURES ------------------------
5: ------------------------------------------------------------------------- */
6: TYPE NUM_T IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
7: TYPE inv_date_rec IS RECORD(
8: inv_date pn_var_grp_dates_all.invoice_date%TYPE,
9: period_id pn_var_periods_all.period_id%TYPE,
10: inv_flag VARCHAR2(1));
11:
12: TYPE inv_date_type IS

Line 474: pn_var_grp_dates_all

470: ,p_vr_comm_date IN DATE) IS
471: SELECT
472: NVL(SUM(proration_factor),0) proration_factor_sum
473: FROM
474: pn_var_grp_dates_all
475: WHERE
476: period_id IN (SELECT
477: period_id
478: FROM

Line 528: pn_var_grp_dates_all

524: ,p_vr_term_date IN DATE) IS
525: SELECT
526: NVL(SUM(proration_factor),0) proration_factor_sum
527: FROM
528: pn_var_grp_dates_all
529: WHERE
530: period_id IN (SELECT
531: period_id
532: FROM

Line 1406: pn_var_grp_dates_all grp

1402: ,grp.group_date
1403: ,grp.invoice_date
1404: ,grp.org_id
1405: FROM
1406: pn_var_grp_dates_all grp
1407: WHERE
1408: grp.var_rent_id = p_vr_id AND
1409: grp.period_id = p_prd_id AND
1410: grp.grp_date_id = p_grp_id;

Line 2187: FROM pn_var_grp_dates_all

2183: SELECT vol_hist_id
2184: FROM pn_var_vol_hist_all
2185: WHERE grp_date_id in(
2186: SELECT grp_date_id
2187: FROM pn_var_grp_dates_all
2188: WHERE var_rent_id = ip_var_rent_id
2189: AND invoice_date = ip_invoice_date)
2190: AND vol_hist_status_code = pn_var_rent_calc_pkg.G_SALESVOL_STATUS_APPROVED);
2191:

Line 2529: pn_var_grp_dates_all grp

2525: amount,
2526: cons.constr_start_date const,
2527: grp.inv_start_date grpst
2528: FROM pn_var_constraints_all cons,
2529: pn_var_grp_dates_all grp
2530: WHERE cons.period_id = p_period_id
2531: AND cons.period_id = grp.period_id
2532: AND cons.constr_start_date <= grp.inv_start_date
2533: AND cons.constr_end_date >= grp.inv_end_date

Line 2911: FROM pn_var_grp_dates_all

2907:
2908: CURSOR csr_last_inv(p_var_rent_id NUMBER)
2909: IS
2910: SELECT MAX(invoice_date) inv_date
2911: FROM pn_var_grp_dates_all
2912: WHERE var_rent_id = p_var_rent_id;
2913:
2914: CURSOR csr_neg_avail (ip_var_rent_id NUMBER,
2915: ip_invoice_date DATE) IS

Line 3069: FROM pn_var_grp_dates_all

3065:
3066: CURSOR csr_last_inv(p_var_rent_id NUMBER)
3067: IS
3068: SELECT MAX(invoice_date) inv_date
3069: FROM pn_var_grp_dates_all
3070: WHERE var_rent_id = p_var_rent_id
3071: AND period_id = (SELECT max(period_id)
3072: FROM pn_var_periods_all
3073: WHERE var_rent_id = p_var_rent_id

Line 3216: FROM pn_var_grp_dates_all

3212:
3213: CURSOR csr_last_inv(p_var_rent_id NUMBER)
3214: IS
3215: SELECT MAX(invoice_date) inv_date
3216: FROM pn_var_grp_dates_all
3217: WHERE var_rent_id = p_var_rent_id
3218: AND period_id = (SELECT max(period_id)
3219: FROM pn_var_periods_all
3220: WHERE var_rent_id = p_var_rent_id

Line 3339: FROM pn_var_grp_dates_all

3335: CURSOR invoice_dates_c(ip_var_rent_id NUMBER,
3336: ip_invoice_date DATE
3337: ) IS
3338: SELECT inv_start_date, inv_end_date
3339: FROM pn_var_grp_dates_all
3340: WHERE var_rent_id = ip_var_rent_id
3341: AND invoice_date = ip_invoice_date;
3342: -- Get the details of actual start and end date for FY/LY/FLY
3343: CURSOR invoice_dates_fyly_c(ip_var_rent_inv_id NUMBER

Line 3601: FROM pn_var_grp_dates_all

3597: CURSOR invoice_dates_c(ip_var_rent_id NUMBER,
3598: ip_invoice_date DATE
3599: ) IS
3600: SELECT inv_start_date, inv_end_date
3601: FROM pn_var_grp_dates_all
3602: WHERE var_rent_id = ip_var_rent_id
3603: AND invoice_date = ip_invoice_date;
3604: -- Get the details of actual start and end date for FY/LY/FLY
3605: CURSOR invoice_dates_fyly_c(ip_var_rent_inv_id NUMBER

Line 4732: FROM pn_var_grp_dates_all

4728: SELECT vol_hist_id
4729: FROM pn_var_vol_hist_all
4730: WHERE grp_date_id in(
4731: SELECT grp_date_id
4732: FROM pn_var_grp_dates_all
4733: WHERE var_rent_id = ip_var_rent_id
4734: AND invoice_date = ip_invoice_date));
4735:
4736: l_invoice_on VARCHAR2(30);

Line 5712: FROM pn_var_grp_dates_all

5708:
5709:
5710: CURSOR inv_ed_dt_cur (p_inv_start_date DATE) IS
5711: SELECT DISTINCT inv_end_date
5712: FROM pn_var_grp_dates_all
5713: WHERE var_rent_id = vr_id
5714: AND inv_start_date = p_inv_start_date;
5715:
5716: CURSOR period_cur IS

Line 5999: pn_var_grp_dates_all grp

5995: ,grp.group_date
5996: ,grp.invoice_date
5997: ,grp.org_id
5998: FROM
5999: pn_var_grp_dates_all grp
6000: WHERE
6001: grp.var_rent_id = p_vr_id AND
6002: grp.period_id = p_prd_id AND
6003: grp.grp_date_id = p_grp_id;

Line 6191: pn_var_grp_dates_all grp

6187: ,grp.group_date
6188: ,grp.invoice_date
6189: ,grp.org_id
6190: FROM
6191: pn_var_grp_dates_all grp
6192: ,pn_var_periods_all prd
6193: WHERE
6194: prd.var_rent_id = p_vr_id AND
6195: prd.period_id = p_prd_id AND

Line 8842: FROM pn_var_grp_dates_all gd1,

8838: -- Get the all invoice_dates
8839: CURSOR get_inv_dates_cur(p_vrent_id IN NUMBER,p_status IN VARCHAR2)
8840: IS
8841: SELECT distinct gd1.invoice_date,gd1.period_id,decode(temp.inv_dt,NULL,'N','Y')
8842: FROM pn_var_grp_dates_all gd1,
8843: (SELECT gd.invoice_date inv_dt
8844: FROM pn_var_grp_dates_all gd
8845: WHERE EXISTS (SELECT NULL from pn_var_vol_hist_all vol
8846: WHERE vol_hist_status_code = p_status

Line 8844: FROM pn_var_grp_dates_all gd

8840: IS
8841: SELECT distinct gd1.invoice_date,gd1.period_id,decode(temp.inv_dt,NULL,'N','Y')
8842: FROM pn_var_grp_dates_all gd1,
8843: (SELECT gd.invoice_date inv_dt
8844: FROM pn_var_grp_dates_all gd
8845: WHERE EXISTS (SELECT NULL from pn_var_vol_hist_all vol
8846: WHERE vol_hist_status_code = p_status
8847: AND vol.period_id = gd.period_id
8848: AND vol.invoicing_date= gd.invoice_date

Line 8909: FROM pn_var_grp_dates_all gd1,

8905: -- Get invoice dates from 2nd annual period for FY/FLY proration rules
8906: CURSOR get_partial_prd_inv_dates(p_vrent_id IN NUMBER,p_status IN VARCHAR2)
8907: IS
8908: SELECT distinct gd1.invoice_date ,gd1.period_id, decode(temp.inv_dt,NULL,'N','Y')
8909: FROM pn_var_grp_dates_all gd1,
8910: pn_var_periods_all vp,
8911: (SELECT gd.invoice_date inv_dt
8912: FROM pn_var_grp_dates_all gd
8913: WHERE EXISTS(select NULL from pn_var_vol_hist_all vol

Line 8912: FROM pn_var_grp_dates_all gd

8908: SELECT distinct gd1.invoice_date ,gd1.period_id, decode(temp.inv_dt,NULL,'N','Y')
8909: FROM pn_var_grp_dates_all gd1,
8910: pn_var_periods_all vp,
8911: (SELECT gd.invoice_date inv_dt
8912: FROM pn_var_grp_dates_all gd
8913: WHERE EXISTS(select NULL from pn_var_vol_hist_all vol
8914: where vol_hist_status_code = p_status
8915: and vol.period_id = gd.period_id
8916: and vol.invoicing_date= gd.invoice_date

Line 8989: FROM pn_var_grp_dates_all gd

8985: WHERE vrent.lease_id = pterm.lease_id
8986: AND vrent.var_rent_id = vinv.var_rent_id
8987: AND pterm.start_date <=
8988: (SELECT MAX(gd.grp_end_date)
8989: FROM pn_var_grp_dates_all gd
8990: WHERE gd.period_id = vinv.period_id
8991: AND gd.invoice_date = vinv.invoice_date
8992: )
8993: AND pterm.end_date >=

Line 8995: FROM pn_var_grp_dates_all gd1

8991: AND gd.invoice_date = vinv.invoice_date
8992: )
8993: AND pterm.end_date >=
8994: (SELECT MIN(gd1.grp_start_date)
8995: FROM pn_var_grp_dates_all gd1
8996: WHERE gd1.period_id = vinv.period_id
8997: AND gd1.invoice_date = vinv.invoice_date
8998: )
8999: AND pterm.var_rent_inv_id IS NULL

Line 9206: FROM pn_var_grp_dates_all

9202: -- Get the invoice_date for an invoice with a given grp_end_dt
9203: CURSOR get_inv_date(p_var_rent_id IN NUMBER,p_prd_id IN NUMBER,p_end_dt IN DATE)
9204: IS
9205: SELECT invoice_date
9206: FROM pn_var_grp_dates_all
9207: WHERE var_rent_id = p_var_rent_id
9208: AND period_id = p_prd_id
9209: AND grp_end_date = p_end_dt;
9210:

Line 9339: FROM pn_var_grp_dates_all

9335:
9336: /* Cursor to get 1st invoice date*/
9337: CURSOR get_min_inv(p_var_rent_id IN NUMBER) IS
9338: SELECT min(invoice_date) fst_inv_dt
9339: FROM pn_var_grp_dates_all
9340: WHERE var_rent_id= p_var_rent_id ;
9341:
9342:
9343: /*Cursor to get all pmt terms for a particular invoice*/

Line 9353: FROM pn_var_grp_dates_all gd

9349: WHERE vrent.lease_id = pterm.lease_id
9350: AND vrent.var_rent_id = vinv.var_rent_id
9351: AND pterm.start_date <=
9352: (SELECT MAX(gd.grp_end_date)
9353: FROM pn_var_grp_dates_all gd
9354: WHERE gd.period_id = vinv.period_id
9355: AND gd.invoice_date = vinv.invoice_date
9356: )
9357: AND pterm.end_date >=

Line 9359: FROM pn_var_grp_dates_all gd1

9355: AND gd.invoice_date = vinv.invoice_date
9356: )
9357: AND pterm.end_date >=
9358: (SELECT MIN(gd1.grp_start_date)
9359: FROM pn_var_grp_dates_all gd1
9360: WHERE gd1.period_id = vinv.period_id
9361: AND gd1.invoice_date = vinv.invoice_date
9362: )
9363: AND pterm.var_rent_inv_id IS NULL

Line 9524: FROM pn_var_grp_dates_all gd

9520: AND pil.lease_id = ppt.lease_id
9521: AND pilt.index_period_id = ppt.index_period_id
9522: AND pilt.rent_increase_term_id = ppt.payment_term_id
9523: AND ppt.start_date <= (SELECT MAX(gd.grp_end_date)
9524: FROM pn_var_grp_dates_all gd
9525: WHERE gd.period_id = vinv.period_id
9526: )
9527: AND ppt.end_date >= (SELECT MIN(gd1.grp_start_date)
9528: FROM pn_var_grp_dates_all gd1

Line 9528: FROM pn_var_grp_dates_all gd1

9524: FROM pn_var_grp_dates_all gd
9525: WHERE gd.period_id = vinv.period_id
9526: )
9527: AND ppt.end_date >= (SELECT MIN(gd1.grp_start_date)
9528: FROM pn_var_grp_dates_all gd1
9529: WHERE gd1.period_id = vinv.period_id
9530: )
9531: AND pilt.lease_term_id = p_term_id
9532: AND ppt.status='APPROVED'

Line 9651: FROM pn_var_grp_dates_all gd

9647: AND pil.lease_id = ppt.lease_id
9648: AND pilt.index_period_id = ppt.index_period_id
9649: AND pilt.rent_increase_term_id = ppt.payment_term_id
9650: AND ppt.start_date <= (SELECT MAX(gd.grp_end_date)
9651: FROM pn_var_grp_dates_all gd
9652: WHERE gd.period_id = vinv.period_id
9653: AND gd.invoice_date = vinv.invoice_date
9654: )
9655: AND ppt.end_date >= (SELECT MIN(gd1.grp_start_date)

Line 9656: FROM pn_var_grp_dates_all gd1

9652: WHERE gd.period_id = vinv.period_id
9653: AND gd.invoice_date = vinv.invoice_date
9654: )
9655: AND ppt.end_date >= (SELECT MIN(gd1.grp_start_date)
9656: FROM pn_var_grp_dates_all gd1
9657: WHERE gd1.period_id = vinv.period_id
9658: AND gd1.invoice_date = vinv.invoice_date
9659: )
9660: AND pilt.lease_term_id = p_term_id

Line 9788: pn_var_grp_dates_all grp

9784: ,grp.group_date
9785: ,grp.invoice_date
9786: ,grp.org_id
9787: FROM
9788: pn_var_grp_dates_all grp
9789: ,pn_var_periods_all prd
9790: WHERE
9791: prd.var_rent_id = p_vr_id AND
9792: prd.period_id = p_prd_id AND

Line 10108: FROM pn_var_grp_dates_all gd

10104: CURSOR grp_date_cur(p_prd_id IN NUMBER,
10105: p_grp_dt_id IN NUMBER
10106: ) IS
10107: SELECT inv_start_date
10108: FROM pn_var_grp_dates_all gd
10109: WHERE gd.period_id = p_prd_id
10110: AND gd.grp_date_id = p_grp_dt_id;
10111:
10112: -- Get the details of

Line 10187: FROM pn_var_grp_dates_all gd

10183: p_grp_dt_id IN NUMBER
10184: )
10185: IS
10186: SELECT invoice_date
10187: FROM pn_var_grp_dates_all gd
10188: WHERE gd.period_id = p_prd_id
10189: AND gd.grp_date_id = p_grp_dt_id;
10190:
10191: CURSOR period_cur(vr_id IN NUMBER) IS

Line 10277: FROM pn_var_grp_dates_all gd

10273: p_grp_dt_id IN NUMBER
10274: )
10275: IS
10276: SELECT invoice_date
10277: FROM pn_var_grp_dates_all gd
10278: WHERE gd.period_id = p_prd_id
10279: AND gd.grp_date_id = p_grp_dt_id;
10280:
10281: CURSOR period_cur(vr_id IN NUMBER)

Line 10737: FROM pn_var_grp_dates_all

10733:
10734: -- Get the details of
10735: CURSOR trueup_end_date_c IS
10736: SELECT grp_end_date
10737: FROM pn_var_grp_dates_all
10738: WHERE grp_date_id = p_grp_date_id;
10739:
10740: l_trueup_rent NUMBER := 0;
10741: l_trueup_date DATE;