APPS.PN_VAR_RENT_CALC_PKG dependencies on PN_VAR_CONSTRAINTS_ALL

Line 2528: FROM pn_var_constraints_all cons,

2524: SELECT TYPE_code,
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

Line 2593: FROM pn_var_periods_all per, pn_var_constraints_all cons

2589: Cursor csr_get_constr(p_period_id NUMBER) is
2590: SELECT TYPE_code,
2591: amount,
2592: cons.constr_start_date const
2593: FROM pn_var_periods_all per, pn_var_constraints_all cons
2594: WHERE per.var_rent_id = (select var_rent_id from pn_var_periods_all where period_id=p_period_id)
2595: AND per.period_id = cons.period_id
2596: AND cons.constr_start_date=(select
2597: MAX(const1.constr_start_date) from pn_var_constraints_all const1

Line 2597: MAX(const1.constr_start_date) from pn_var_constraints_all const1

2593: FROM pn_var_periods_all per, pn_var_constraints_all cons
2594: WHERE per.var_rent_id = (select var_rent_id from pn_var_periods_all where period_id=p_period_id)
2595: AND per.period_id = cons.period_id
2596: AND cons.constr_start_date=(select
2597: MAX(const1.constr_start_date) from pn_var_constraints_all const1
2598: where const1.period_id = cons.period_id)
2599: AND period_num = 1;
2600:
2601: l_lower_bound NUMBER;