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_CHG_CAL_PKG dependencies on PN_VAR_GRP_DATES_ALL

Line 555: from pn_var_grp_dates_all a,

551: c.end_date,
552: a.group_date,
553: a.invoice_date invoicing_date,
554: a.reptg_due_date reporting_date
555: from pn_var_grp_dates_all a,
556: pn_var_lines_all b,
557: pn_var_periods_all c
558: where a.var_rent_id = l_var_rent_id
559: and a.period_id = b.period_id

Line 599: from pn_var_grp_dates_all a,

595: d.attribute13 attribute13,
596: d.attribute14 attribute14,
597: d.attribute15 attribute15,
598: d.org_id org_id
599: from pn_var_grp_dates_all a,
600: pn_var_lines_all b,
601: pn_var_periods_all c,
602: pn_var_vol_hist_all d
603: where a.var_rent_id = l_chg_var_rent_id

Line 788: FROM pn_var_grp_dates_all a

784: ,b.start_date
785: ,b.end_date
786: ,c.commencement_date
787: ,c.proration_rule --Chris.T. 10FEB2004
788: FROM pn_var_grp_dates_all a
789: ,pn_var_periods_all b
790: ,pn_var_rents_all c
791: WHERE c.var_rent_id = ip_var_rent_id
792: AND c.var_rent_id = a.var_rent_id

Line 869: FROM pn_var_grp_dates_all

865: SELECT min(grp_start_date) fy_start_date
866: , ADD_MONTHS(min(grp_start_date), 12) - 1 fy_end_date
867: , ADD_MONTHS(max(grp_end_date), -12) + 1 ly_start_date
868: , max(grp_end_date) ly_end_date
869: FROM pn_var_grp_dates_all
870: WHERE var_rent_id = p_var_rent_id;
871: /* Srini 14JUL2004
872: SELECT min(grp_start_date)
873: , min(grp_start_date)+364

Line 1891: FROM pn_var_grp_dates_all

1887: pvt.bkpt_start_date,pvt.pr_grp_blended_vol_start;*/
1888:
1889: CURSOR pn_var_grp_dt (p_var_rent_id NUMBER) IS
1890: SELECT max(group_date), min(group_date), min(grp_start_date)+364
1891: FROM pn_var_grp_dates_all
1892: WHERE var_rent_id = p_var_rent_id;
1893:
1894: CURSOR get_max_per_grp_dt (p_var_rent_id NUMBER --Chris.T. 19-NOV-03
1895: ,p_period_id NUMBER) IS

Line 1897: FROM pn_var_grp_dates_all

1893:
1894: CURSOR get_max_per_grp_dt (p_var_rent_id NUMBER --Chris.T. 19-NOV-03
1895: ,p_period_id NUMBER) IS
1896: SELECT max(group_date)
1897: FROM pn_var_grp_dates_all
1898: WHERE var_rent_id = p_var_rent_id
1899: AND period_id = p_period_id;
1900:
1901:

Line 1906: FROM pn_var_grp_dates_all

1902: CURSOR get_invoice_grp_dt (p_var_rent_id NUMBER
1903: ,p_period_id NUMBER
1904: ,p_min_grp_dt_364 DATE) IS
1905: SELECT group_date
1906: FROM pn_var_grp_dates_all
1907: WHERE var_rent_id = p_var_rent_id
1908: --AND period_id = p_period_id
1909: AND grp_start_date <= p_min_grp_dt_364
1910: AND grp_end_date >= p_min_grp_dt_364;

Line 1951: l_max_per_grp_dt pn_var_grp_dates_all.group_date%TYPE; --Chris.T 19-NOV-03

1947: l_old_partial_period VARCHAR2(1);
1948: /*l_old_grp_date_id pn_var_transactions_all.grp_date_id%TYPE; --Chris.T 19-NOV-03
1949: l_old_bkpt_start_date pn_var_transactions_all.bkpt_start_date%TYPE; --Chris.T 19-NOV-03
1950: l_old_bkpt_detail_id pn_var_transactions_all.bkpt_detail_id%TYPE; --Chris.T 19-NOV-03
1951: l_max_per_grp_dt pn_var_grp_dates_all.group_date%TYPE; --Chris.T 19-NOV-03
1952: l_old_group_date pn_var_transactions_all.group_date%TYPE; --Chris.T 19-NOV-03 */
1953: l_ly_365_start_date DATE;
1954: l_fy_365_end_Date DATE;
1955: BEGIN

Line 2764: FROM pn_var_grp_dates_all grp

2760: AND trx.group_date <= p_max_grp_dt
2761: AND trx.proration_reset_group_id = p_pr_re_grp_id
2762: AND trx.bkpt_rate = p_bkpt_rate
2763: AND EXISTS (SELECT 'Partial Month'
2764: FROM pn_var_grp_dates_all grp
2765: WHERE grp.grp_date_id = trx.grp_date_id
2766: AND grp.grp_end_date > p_vr_term_dt);
2767:
2768: CURSOR process_first_cynp_cur(p_var_rent_id NUMBER,

Line 2882: FROM pn_var_grp_dates_all

2878:
2879: BEGIN
2880: SELECT grp_end_date
2881: INTO l_grp_end_dt
2882: FROM pn_var_grp_dates_all
2883: WHERE var_rent_id = p_var_rent_id
2884: AND group_date = annual_blended_bkpts_rec.max_group_date;
2885: EXCEPTION
2886: WHEN OTHERS THEN

Line 3423: FROM pn_var_grp_dates_all

3419: IS
3420:
3421: CURSOR get_group_date(ip_grp_date DATE) IS
3422: SELECT group_date
3423: FROM pn_var_grp_dates_all
3424: WHERE var_rent_id = p_var_rent_id
3425: AND ip_grp_date between grp_start_date and grp_end_date;
3426:
3427:

Line 3430: FROM pn_var_grp_dates_all

3426:
3427:
3428: CURSOR get_365_end_cur IS
3429: SELECT min(grp_start_date) + 364 enddate
3430: FROM pn_var_grp_dates_all
3431: WHERE var_rent_id = p_var_rent_id ;
3432:
3433:
3434: l_fy_365_end_date DATE;

Line 3458: FROM pn_var_grp_dates_all

3454: IS
3455:
3456: CURSOR get_group_date(ip_grp_date DATE) IS
3457: SELECT group_date
3458: FROM pn_var_grp_dates_all
3459: WHERE var_rent_id = p_var_rent_id
3460: AND ip_grp_date between grp_start_date and grp_end_date;
3461:
3462:

Line 3465: FROM pn_var_grp_dates_all

3461:
3462:
3463: CURSOR get_365_start_cur IS
3464: SELECT max(grp_end_date) - 364 startdate
3465: FROM pn_var_grp_dates_all
3466: WHERE var_rent_id = p_var_rent_id ;
3467:
3468:
3469: L_ly_365_start_date DATE;

Line 3756: FROM pn_var_grp_dates_all

3752: SELECT invoice_date,
3753: inv_start_date
3754: ,inv_end_date
3755: ,inv_schedule_date
3756: FROM pn_var_grp_dates_all
3757: WHERE var_rent_id = p_var_rent_id
3758: AND ip_date between inv_start_date and inv_end_date;
3759:
3760: CURSOR invoices_cur (ip_invoice_date DATE) IS

Line 3769: FROM pn_var_grp_dates_all

3765: AND invoice_date >= ip_invoice_date;
3766:
3767: CURSOR max_invoice_date_cur Is
3768: SELECT max(invoice_date) invoice_date
3769: FROM pn_var_grp_dates_all
3770: WHERE var_rent_id = p_var_rent_id;
3771:
3772: CURSOR get_periods_cur(ip_date DATE) Is
3773:

Line 3796: from pn_var_grp_dates_all

3792: l_adjust_num NUMBER;
3793:
3794: CURSOR get_invoice_date_cur IS
3795: SELECT invoice_date
3796: from pn_var_grp_dates_all
3797: where var_rent_id = p_var_rent_id
3798: and p_effective_date between inv_start_date and inv_end_date ;
3799:
3800: BEGIN