APPS.PN_REC_CALC_PKG dependencies on PN_REC_AGR_LINCONST_ALL

Line 858: l_line_constraints pn_rec_agr_linconst_all.value%TYPE:=0;

854: l_ten_recoverable_area_rec ten_recoverable_area_rec;
855: l_ten_recoverable_area pn_rec_arcl_dtlln_all.occupied_area%TYPE:=0;
856: l_ten_occupancy_pct pn_rec_arcl_dtlln_all.occupancy_pct%TYPE:=0;
857: l_billed_recovery pn_rec_period_lines_all.billed_recovery%TYPE:=0;
858: l_line_constraints pn_rec_agr_linconst_all.value%TYPE:=0;
859: l_line_abatements pn_rec_agr_linabat_all.amount%TYPE:=0;
860: l_ten_actual_recovery pn_rec_period_lines_all.actual_recovery%TYPE:=0;
861: l_contr_actual_recovery pn_rec_period_lines_all.actual_recovery%TYPE:=0;
862: l_amount_per_sft NUMBER:=0;

Line 3288: FROM PN_REC_AGR_LINCONST_ALL lineconst

3284: RELATION,
3285: VALUE,
3286: CPI_INDEX,
3287: BASE_YEAR
3288: FROM PN_REC_AGR_LINCONST_ALL lineconst
3289: WHERE lineconst.rec_agr_line_id = p_rec_agr_line_id
3290: AND p_as_of_date between lineconst.start_date and lineconst.end_date
3291: ;
3292:

Line 4865: l_percent pn_rec_agr_linconst_all.value%TYPE;

4861: )
4862: RETURN pn_rec_period_lines_all.constrained_actual%TYPE IS
4863:
4864: l_prior_period_amount pn_rec_period_lines_all.actual_recovery%TYPE;
4865: l_percent pn_rec_agr_linconst_all.value%TYPE;
4866:
4867: CURSOR csr_get_curr_percent (p_as_of_date date) is
4868: SELECT lineconst.VALUE
4869: FROM pn_rec_agr_linconst_all lineconst

Line 4869: FROM pn_rec_agr_linconst_all lineconst

4865: l_percent pn_rec_agr_linconst_all.value%TYPE;
4866:
4867: CURSOR csr_get_curr_percent (p_as_of_date date) is
4868: SELECT lineconst.VALUE
4869: FROM pn_rec_agr_linconst_all lineconst
4870: WHERE lineconst.rec_agr_line_id = p_rec_agr_line_id
4871: AND p_as_of_date between lineconst.start_date and lineconst.end_date
4872: AND lineconst.RELATION = 'MAX'
4873: AND lineconst.SCOPE = 'OPYA';

Line 4976: l_percent pn_rec_agr_linconst_all.value%TYPE;

4972: ,p_called_from VARCHAR2
4973: )
4974: RETURN pn_rec_period_lines_all.actual_recovery%TYPE IS
4975:
4976: l_percent pn_rec_agr_linconst_all.value%TYPE;
4977: l_cap_amount pn_rec_period_lines_all.actual_recovery%TYPE;
4978: l_start_date pn_rec_period_lines_all.start_date%TYPE;
4979: l_end_date pn_rec_period_lines_all.end_date%TYPE;
4980:

Line 4992: pn_rec_agr_linconst_all lineconst,

4988:
4989: CURSOR csr_get_prior_periods (p_start_date date, p_fst_end_date date) is
4990: SELECT lineconst.VALUE
4991: FROM pn_rec_period_lines_all period_lines,
4992: pn_rec_agr_linconst_all lineconst,
4993: pn_rec_calc_periods_all recperiod
4994: WHERE period_lines.rec_agr_line_id = p_rec_agr_line_id
4995: AND recperiod.rec_calc_period_id = period_lines.rec_calc_period_id
4996: AND recperiod.start_date > p_fst_end_date

Line 5007: FROM pn_rec_agr_linconst_all lineconst

5003: AND lineconst.SCOPE = 'OPYC';
5004:
5005: CURSOR csr_get_curr_percent (p_start_date date, p_end_date date, p_as_of_date date) is
5006: SELECT lineconst.VALUE
5007: FROM pn_rec_agr_linconst_all lineconst
5008: WHERE lineconst.rec_agr_line_id = p_rec_agr_line_id
5009: AND p_as_of_date between lineconst.start_date and lineconst.end_date
5010: AND lineconst.RELATION = 'MAX'
5011: AND lineconst.SCOPE = 'OPYC';