APPS.PN_VAR_CHG_CAL_PKG dependencies on PN_VAR_RENTS_ALL

Line 543: from pn_var_rents_all

539: l_actual_amount NUMBER := 0;
540:
541: cursor c_start is
542: select commencement_date
543: from pn_var_rents_all
544: where var_rent_id = l_var_rent_id;
545:
546: cursor c_new_grplineperiod is
547: select a.grp_date_id,

Line 790: ,pn_var_rents_all c

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
794: AND a.period_id = NVL(ip_period_id,a.period_id)

Line 932: l_cumulative_vol PN_VAR_RENTS_ALL.CUMULATIVE_VOL%TYPE;

928: l_last_complete_period_id NUMBER;
929: l_ly_365_start_date DATE;
930: l_fy_365_end_date DATE;
931: l_vr_term_dt DATE;
932: l_cumulative_vol PN_VAR_RENTS_ALL.CUMULATIVE_VOL%TYPE;
933: v_reset_grp_id NUMBER;
934: l_bkpt_days1 NUMBER;
935: l_bkpt_days2 NUMBER;
936: l_cnt NUMBER;

Line 964: FROM pn_var_rents_all

960: pnp_debug_pkg.debug('Proration Rule = '||l_proration_rule);
961:
962: SELECT termination_date, cumulative_vol
963: INTO l_vr_term_dt, l_cumulative_vol
964: FROM pn_var_rents_all
965: WHERE var_rent_id = p_var_rent_id;
966: pnp_debug_pkg.log(' Variable Rent Termination Date:'||l_vr_term_dt||' Cumulative Volume:'||l_cumulative_vol);
967: pnp_debug_pkg.debug(' Variable Rent Termination Date:'||l_vr_term_dt);
968:

Line 1834: ,pn_var_rents_all pvr

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;
1838: /* Chris.T. 13-Aug-03 -- To accomodate Proration rules -- End*/

Line 1852: ,pn_var_rents_all pvr

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
1856: AND pvt.period_id = pvl.period_id

Line 1875: ,pn_var_rents_all pvr

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
1879: AND pvt.period_id = pvl.period_id

Line 2813: FROM pn_var_rents_all

2809: BEGIN
2810: /*
2811: SELECT termination_date
2812: INTO l_vr_term_dt
2813: FROM pn_var_rents_all
2814: WHERE var_rent_id = p_var_rent_id;
2815: pnp_debug_pkg.log(' Variable Rent Termination Date:'||l_vr_term_dt);
2816: pnp_debug_pkg.debug(' Variable Rent Termination Date:'||l_vr_term_dt);
2817:

Line 3229: FROM pn_var_rents_all

3225: x_var_rent_num OUT NOCOPY VARCHAR2) IS
3226:
3227: CURSOR var_rent_cur IS
3228: SELECT *
3229: FROM pn_var_rents_all
3230: WHERE var_rent_id = p_old_var_rent_id;
3231:
3232: CURSOR var_rent_dates_cur IS
3233: SELECT *

Line 3304: FROM pn_var_rents_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
3304: FROM pn_var_rents_all
3305: WHERE var_rent_id = p_var_rent_id;
3306:
3307: l_period_exists BOOLEAN := FALSE;
3308: l_defaults_exists BOOLEAN := FALSE;