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 4644: FROM pn_var_grp_dates_all

4640: SELECT vol_hist_id
4641: FROM pn_var_vol_hist_all
4642: WHERE grp_date_id in(
4643: SELECT grp_date_id
4644: FROM pn_var_grp_dates_all
4645: WHERE var_rent_id = ip_var_rent_id
4646: AND invoice_date = ip_invoice_date));
4647:
4648: l_invoice_on VARCHAR2(30);

Line 5623: FROM pn_var_grp_dates_all

5619:
5620:
5621: CURSOR inv_ed_dt_cur (p_inv_start_date DATE) IS
5622: SELECT DISTINCT inv_end_date
5623: FROM pn_var_grp_dates_all
5624: WHERE var_rent_id = vr_id
5625: AND inv_start_date = p_inv_start_date;
5626:
5627: CURSOR period_cur IS

Line 5910: pn_var_grp_dates_all grp

5906: ,grp.group_date
5907: ,grp.invoice_date
5908: ,grp.org_id
5909: FROM
5910: pn_var_grp_dates_all grp
5911: WHERE
5912: grp.var_rent_id = p_vr_id AND
5913: grp.period_id = p_prd_id AND
5914: grp.grp_date_id = p_grp_id;

Line 6102: pn_var_grp_dates_all grp

6098: ,grp.group_date
6099: ,grp.invoice_date
6100: ,grp.org_id
6101: FROM
6102: pn_var_grp_dates_all grp
6103: ,pn_var_periods_all prd
6104: WHERE
6105: prd.var_rent_id = p_vr_id AND
6106: prd.period_id = p_prd_id AND

Line 8787: FROM pn_var_grp_dates_all gd1,

8783: -- Get the all invoice_dates
8784: CURSOR get_inv_dates_cur(p_vrent_id IN NUMBER,p_status IN VARCHAR2)
8785: IS
8786: SELECT distinct gd1.invoice_date,gd1.period_id,decode(temp.inv_dt,NULL,'N','Y')
8787: FROM pn_var_grp_dates_all gd1,
8788: (SELECT gd.invoice_date inv_dt
8789: FROM pn_var_grp_dates_all gd
8790: WHERE EXISTS (SELECT NULL from pn_var_vol_hist_all vol
8791: WHERE vol_hist_status_code = p_status

Line 8789: FROM pn_var_grp_dates_all gd

8785: IS
8786: SELECT distinct gd1.invoice_date,gd1.period_id,decode(temp.inv_dt,NULL,'N','Y')
8787: FROM pn_var_grp_dates_all gd1,
8788: (SELECT gd.invoice_date inv_dt
8789: FROM pn_var_grp_dates_all gd
8790: WHERE EXISTS (SELECT NULL from pn_var_vol_hist_all vol
8791: WHERE vol_hist_status_code = p_status
8792: AND vol.period_id = gd.period_id
8793: AND vol.invoicing_date= gd.invoice_date

Line 8854: FROM pn_var_grp_dates_all gd1,

8850: -- Get invoice dates from 2nd annual period for FY/FLY proration rules
8851: CURSOR get_partial_prd_inv_dates(p_vrent_id IN NUMBER,p_status IN VARCHAR2)
8852: IS
8853: SELECT distinct gd1.invoice_date ,gd1.period_id, decode(temp.inv_dt,NULL,'N','Y')
8854: FROM pn_var_grp_dates_all gd1,
8855: pn_var_periods_all vp,
8856: (SELECT gd.invoice_date inv_dt
8857: FROM pn_var_grp_dates_all gd
8858: WHERE EXISTS(select NULL from pn_var_vol_hist_all vol

Line 8857: FROM pn_var_grp_dates_all gd

8853: SELECT distinct gd1.invoice_date ,gd1.period_id, decode(temp.inv_dt,NULL,'N','Y')
8854: FROM pn_var_grp_dates_all gd1,
8855: pn_var_periods_all vp,
8856: (SELECT gd.invoice_date inv_dt
8857: FROM pn_var_grp_dates_all gd
8858: WHERE EXISTS(select NULL from pn_var_vol_hist_all vol
8859: where vol_hist_status_code = p_status
8860: and vol.period_id = gd.period_id
8861: and vol.invoicing_date= gd.invoice_date

Line 8934: FROM pn_var_grp_dates_all gd

8930: WHERE vrent.lease_id = pterm.lease_id
8931: AND vrent.var_rent_id = vinv.var_rent_id
8932: AND pterm.start_date <=
8933: (SELECT MAX(gd.grp_end_date)
8934: FROM pn_var_grp_dates_all gd
8935: WHERE gd.period_id = vinv.period_id
8936: AND gd.invoice_date = vinv.invoice_date
8937: )
8938: AND pterm.end_date >=

Line 8940: FROM pn_var_grp_dates_all gd1

8936: AND gd.invoice_date = vinv.invoice_date
8937: )
8938: AND pterm.end_date >=
8939: (SELECT MIN(gd1.grp_start_date)
8940: FROM pn_var_grp_dates_all gd1
8941: WHERE gd1.period_id = vinv.period_id
8942: AND gd1.invoice_date = vinv.invoice_date
8943: )
8944: AND pterm.var_rent_inv_id IS NULL

Line 9151: FROM pn_var_grp_dates_all

9147: -- Get the invoice_date for an invoice with a given grp_end_dt
9148: CURSOR get_inv_date(p_var_rent_id IN NUMBER,p_prd_id IN NUMBER,p_end_dt IN DATE)
9149: IS
9150: SELECT invoice_date
9151: FROM pn_var_grp_dates_all
9152: WHERE var_rent_id = p_var_rent_id
9153: AND period_id = p_prd_id
9154: AND grp_end_date = p_end_dt;
9155:

Line 9284: FROM pn_var_grp_dates_all

9280:
9281: /* Cursor to get 1st invoice date*/
9282: CURSOR get_min_inv(p_var_rent_id IN NUMBER) IS
9283: SELECT min(invoice_date) fst_inv_dt
9284: FROM pn_var_grp_dates_all
9285: WHERE var_rent_id= p_var_rent_id ;
9286:
9287:
9288: /*Cursor to get all pmt terms for a particular invoice*/

Line 9298: FROM pn_var_grp_dates_all gd

9294: WHERE vrent.lease_id = pterm.lease_id
9295: AND vrent.var_rent_id = vinv.var_rent_id
9296: AND pterm.start_date <=
9297: (SELECT MAX(gd.grp_end_date)
9298: FROM pn_var_grp_dates_all gd
9299: WHERE gd.period_id = vinv.period_id
9300: AND gd.invoice_date = vinv.invoice_date
9301: )
9302: AND pterm.end_date >=

Line 9304: FROM pn_var_grp_dates_all gd1

9300: AND gd.invoice_date = vinv.invoice_date
9301: )
9302: AND pterm.end_date >=
9303: (SELECT MIN(gd1.grp_start_date)
9304: FROM pn_var_grp_dates_all gd1
9305: WHERE gd1.period_id = vinv.period_id
9306: AND gd1.invoice_date = vinv.invoice_date
9307: )
9308: AND pterm.var_rent_inv_id IS NULL

Line 9469: FROM pn_var_grp_dates_all gd

9465: AND pil.lease_id = ppt.lease_id
9466: AND pilt.index_period_id = ppt.index_period_id
9467: AND pilt.rent_increase_term_id = ppt.payment_term_id
9468: AND ppt.start_date <= (SELECT MAX(gd.grp_end_date)
9469: FROM pn_var_grp_dates_all gd
9470: WHERE gd.period_id = vinv.period_id
9471: )
9472: AND ppt.end_date >= (SELECT MIN(gd1.grp_start_date)
9473: FROM pn_var_grp_dates_all gd1

Line 9473: FROM pn_var_grp_dates_all gd1

9469: FROM pn_var_grp_dates_all gd
9470: WHERE gd.period_id = vinv.period_id
9471: )
9472: AND ppt.end_date >= (SELECT MIN(gd1.grp_start_date)
9473: FROM pn_var_grp_dates_all gd1
9474: WHERE gd1.period_id = vinv.period_id
9475: )
9476: AND pilt.lease_term_id = p_term_id
9477: AND ppt.status='APPROVED'

Line 9596: FROM pn_var_grp_dates_all gd

9592: AND pil.lease_id = ppt.lease_id
9593: AND pilt.index_period_id = ppt.index_period_id
9594: AND pilt.rent_increase_term_id = ppt.payment_term_id
9595: AND ppt.start_date <= (SELECT MAX(gd.grp_end_date)
9596: FROM pn_var_grp_dates_all gd
9597: WHERE gd.period_id = vinv.period_id
9598: AND gd.invoice_date = vinv.invoice_date
9599: )
9600: AND ppt.end_date >= (SELECT MIN(gd1.grp_start_date)

Line 9601: FROM pn_var_grp_dates_all gd1

9597: WHERE gd.period_id = vinv.period_id
9598: AND gd.invoice_date = vinv.invoice_date
9599: )
9600: AND ppt.end_date >= (SELECT MIN(gd1.grp_start_date)
9601: FROM pn_var_grp_dates_all gd1
9602: WHERE gd1.period_id = vinv.period_id
9603: AND gd1.invoice_date = vinv.invoice_date
9604: )
9605: AND pilt.lease_term_id = p_term_id

Line 9733: pn_var_grp_dates_all grp

9729: ,grp.group_date
9730: ,grp.invoice_date
9731: ,grp.org_id
9732: FROM
9733: pn_var_grp_dates_all grp
9734: ,pn_var_periods_all prd
9735: WHERE
9736: prd.var_rent_id = p_vr_id AND
9737: prd.period_id = p_prd_id AND

Line 10053: FROM pn_var_grp_dates_all gd

10049: CURSOR grp_date_cur(p_prd_id IN NUMBER,
10050: p_grp_dt_id IN NUMBER
10051: ) IS
10052: SELECT inv_start_date
10053: FROM pn_var_grp_dates_all gd
10054: WHERE gd.period_id = p_prd_id
10055: AND gd.grp_date_id = p_grp_dt_id;
10056:
10057: -- Get the details of

Line 10132: FROM pn_var_grp_dates_all gd

10128: p_grp_dt_id IN NUMBER
10129: )
10130: IS
10131: SELECT invoice_date
10132: FROM pn_var_grp_dates_all gd
10133: WHERE gd.period_id = p_prd_id
10134: AND gd.grp_date_id = p_grp_dt_id;
10135:
10136: CURSOR period_cur(vr_id IN NUMBER) IS

Line 10222: FROM pn_var_grp_dates_all gd

10218: p_grp_dt_id IN NUMBER
10219: )
10220: IS
10221: SELECT invoice_date
10222: FROM pn_var_grp_dates_all gd
10223: WHERE gd.period_id = p_prd_id
10224: AND gd.grp_date_id = p_grp_dt_id;
10225:
10226: CURSOR period_cur(vr_id IN NUMBER)

Line 10682: FROM pn_var_grp_dates_all

10678:
10679: -- Get the details of
10680: CURSOR trueup_end_date_c IS
10681: SELECT grp_end_date
10682: FROM pn_var_grp_dates_all
10683: WHERE grp_date_id = p_grp_date_id;
10684:
10685: l_trueup_rent NUMBER := 0;
10686: l_trueup_date DATE;