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_PERIODS_ALL

Line 557: pn_var_periods_all c

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
560: and b.period_id = c.period_id;
561:

Line 601: pn_var_periods_all c,

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
604: and a.period_id = b.period_id
605: and b.period_id = c.period_id

Line 789: ,pn_var_periods_all b

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
793: AND a.period_id = b.period_id

Line 980: FROM pn_var_periods_all

976: CLOSE pn_var_grp_dt;
977:
978: SELECT MAX(end_date), ADD_MONTHS(MAX(end_date), -12)+1
979: INTO l_ly_365_end_dt, l_ly_365_start_dt
980: FROM pn_var_periods_all
981: WHERE var_rent_id = p_var_rent_id;
982:
983: --pnp_debug_pkg.log(' l_fy_start_date = '|| l_fy_start_date);
984: --pnp_debug_pkg.log(' l_fy_end_date = '|| l_fy_end_date);

Line 1292: FROM pn_var_periods_all

1288: IF l_proration_rule IN ('LY', 'FLY') THEN
1289: BEGIN
1290: SELECT MAX(period_id)
1291: INTO l_last_complete_period_id
1292: FROM pn_var_periods_all
1293: WHERE var_rent_id = p_var_rent_id
1294: AND l_ly_365_start_date BETWEEN start_date AND end_date;
1295: EXCEPTION
1296: WHEN OTHERS THEN

Line 1833: FROM pn_var_periods_all pvt

1829: /* Chris.T. 13-Aug-03 -- To accomodate Proration rules -- Start*/
1830: CURSOR get_periods_cur IS
1831: SELECT pvt.period_id,pvt.start_date,pvt.end_date,pvt.partial_period
1832: ,pvr.proration_rule
1833: FROM pn_var_periods_all pvt
1834: ,pn_var_rents_all pvr
1835: WHERE pvt.var_Rent_id = p_var_rent_id
1836: AND pvt.var_rent_id = pvr.var_rent_id
1837: ORDER by pvt.start_date;

Line 1851: ,pn_var_periods_all per

1847: ,per.start_date
1848: ,per.end_date
1849: FROM pn_var_transactions_all pvt
1850: ,pn_var_lines_all pvl
1851: ,pn_var_periods_all per
1852: ,pn_var_rents_all pvr
1853: WHERE pvt.var_rent_id = p_var_rent_id
1854: AND per.period_id = NVL(p_period_id,per.period_id)
1855: AND pvt.period_id = per.period_id

Line 1874: ,pn_var_periods_all per

1870: ,per.start_date
1871: ,per.end_date
1872: FROM pn_var_transactions_all pvt
1873: ,pn_var_lines_all pvl
1874: ,pn_var_periods_all per
1875: ,pn_var_rents_all pvr
1876: WHERE pvt.var_rent_id = p_var_rent_id
1877: AND per.period_id = NVL(p_period_id,per.period_id)
1878: AND pvt.period_id = per.period_id

Line 1915: FROM pn_var_periods_all

1911: /* Chris.T. 11-Aug-03 -- To accomodate Proration rules -- End*/
1912:
1913: Cursor is_last_year_partial IS
1914: SELECT period_id,partial_period
1915: FROM pn_var_periods_all
1916: WHERE period_id = (SELECT max(period_id)
1917: FROM pn_var_periods_all
1918: WHERE var_rent_id = p_var_rent_id);
1919:

Line 1917: FROM pn_var_periods_all

1913: Cursor is_last_year_partial IS
1914: SELECT period_id,partial_period
1915: FROM pn_var_periods_all
1916: WHERE period_id = (SELECT max(period_id)
1917: FROM pn_var_periods_all
1918: WHERE var_rent_id = p_var_rent_id);
1919:
1920: l_summ_vol_start NUMBER := 0;
1921: l_summ_vol_end NUMBER := 0;

Line 2687: FROM pn_var_periods_all

2683: l_invg_freq_code NUMBER;
2684:
2685: CURSOR first_partial_period_cur IS
2686: SELECT period_id,start_date,end_date,partial_period
2687: FROM pn_var_periods_all
2688: WHERE var_rent_id = p_var_rent_id
2689: AND start_Date = p_start_date ; -- p_start date = VR_agreement_start_date
2690:
2691: CURSOR first_complete_period_cur (p_date DATE) IS

Line 2693: FROM pn_var_periods_all

2689: AND start_Date = p_start_date ; -- p_start date = VR_agreement_start_date
2690:
2691: CURSOR first_complete_period_cur (p_date DATE) IS
2692: SELECT period_id,Start_date,end_date,partial_period
2693: FROM pn_var_periods_all
2694: WHERE var_rent_id = p_var_rent_id
2695: AND start_Date = p_date ; -- p_date = partial_period_end_date +1;
2696:
2697: /*CURSOR annual_blended_bkpts_cur (p_end_date DATE) IS

Line 3299: FROM pn_var_periods_all

3295: CURSOR period_exists_cur IS
3296: SELECT 'x' period_exists
3297: FROM dual
3298: WHERE EXISTS ( SELECT period_id
3299: FROM pn_var_periods_all
3300: WHERE var_rent_id = p_var_rent_id);
3301:
3302: CURSOR old_var_rent_cur IS
3303: SELECT chg_cal_var_rent_id

Line 3401: FROM pn_var_periods_all

3397: IS
3398:
3399: CURSOR last_period_cur IS
3400: SELECT max(period_id) period_id
3401: FROM pn_var_periods_all
3402: WHERE var_rent_id = p_var_rent_id
3403: AND partial_period = 'N';
3404:
3405: l_last_complete_period_id NUMBER;

Line 3775: FROM pn_var_periods_all

3771:
3772: CURSOR get_periods_cur(ip_date DATE) Is
3773:
3774: SELECT period_id
3775: FROM pn_var_periods_all
3776: WHERE var_rent_id = p_var_rent_id
3777: AND ip_date between start_date and end_date ;
3778:
3779: CURSOR get_adjust_num ( ip_period_id NUMBER , ip_invoice_date DATE) IS