APPS.PN_REC_CALC_PKG dependencies on PN_REC_AGR_LINCONST_ALL

Line 4: g_rec_agr_line_id pn_rec_agr_linconst_all.rec_agr_line_id%TYPE;

1: package PN_REC_CALC_PKG as
2: /* $Header: PNRECALS.pls 120.0.12010000.2 2008/09/04 12:26:31 mumohan ship $ */
3:
4: g_rec_agr_line_id pn_rec_agr_linconst_all.rec_agr_line_id%TYPE;
5: g_calc_period_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE;
6:
7: g_ext_precision number;
8: g_min_acct_unit number;

Line 35: FROM pn_rec_agr_linconst_all const

31: ,const.relation
32: ,const.value
33: ,const.cpi_index
34: ,const.base_year
35: FROM pn_rec_agr_linconst_all const
36: WHERE const.rec_agr_line_id = g_rec_agr_line_id
37: AND g_calc_period_as_of_date between const.start_date
38: AND const.end_date
39: ORDER BY const.constr_order ;