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.

[Home] [Help]

APPS.PN_REC_CALC_PKG dependencies on PN_REC_AGR_LINCONST_ALL

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

829: l_ten_recoverable_area_rec ten_recoverable_area_rec;
830: l_ten_recoverable_area pn_rec_arcl_dtlln_all.occupied_area%TYPE:=0;
831: l_ten_occupancy_pct pn_rec_arcl_dtlln_all.occupancy_pct%TYPE:=0;
832: l_billed_recovery pn_rec_period_lines_all.billed_recovery%TYPE:=0;
833: l_line_constraints pn_rec_agr_linconst_all.value%TYPE:=0;
834: l_line_abatements pn_rec_agr_linabat_all.amount%TYPE:=0;
835: l_ten_actual_recovery pn_rec_period_lines_all.actual_recovery%TYPE:=0;
836: l_contr_actual_recovery pn_rec_period_lines_all.actual_recovery%TYPE:=0;
837: l_amount_per_sft NUMBER:=0;

Line 3203: FROM PN_REC_AGR_LINCONST_ALL lineconst

3199: RELATION,
3200: VALUE,
3201: CPI_INDEX,
3202: BASE_YEAR
3203: FROM PN_REC_AGR_LINCONST_ALL lineconst
3204: WHERE lineconst.rec_agr_line_id = p_rec_agr_line_id
3205: AND p_as_of_date between lineconst.start_date and lineconst.end_date
3206: ;
3207:

Line 4780: l_percent pn_rec_agr_linconst_all.value%TYPE;

4776: )
4777: RETURN pn_rec_period_lines_all.constrained_actual%TYPE IS
4778:
4779: l_prior_period_amount pn_rec_period_lines_all.actual_recovery%TYPE;
4780: l_percent pn_rec_agr_linconst_all.value%TYPE;
4781:
4782: CURSOR csr_get_curr_percent (p_as_of_date date) is
4783: SELECT lineconst.VALUE
4784: FROM pn_rec_agr_linconst_all lineconst

Line 4784: FROM pn_rec_agr_linconst_all lineconst

4780: l_percent pn_rec_agr_linconst_all.value%TYPE;
4781:
4782: CURSOR csr_get_curr_percent (p_as_of_date date) is
4783: SELECT lineconst.VALUE
4784: FROM pn_rec_agr_linconst_all lineconst
4785: WHERE lineconst.rec_agr_line_id = p_rec_agr_line_id
4786: AND p_as_of_date between lineconst.start_date and lineconst.end_date
4787: AND lineconst.RELATION = 'MAX'
4788: AND lineconst.SCOPE = 'OPYA';

Line 4891: l_percent pn_rec_agr_linconst_all.value%TYPE;

4887: ,p_called_from VARCHAR2
4888: )
4889: RETURN pn_rec_period_lines_all.actual_recovery%TYPE IS
4890:
4891: l_percent pn_rec_agr_linconst_all.value%TYPE;
4892: l_cap_amount pn_rec_period_lines_all.actual_recovery%TYPE;
4893: l_start_date pn_rec_period_lines_all.start_date%TYPE;
4894: l_end_date pn_rec_period_lines_all.end_date%TYPE;
4895:

Line 4907: pn_rec_agr_linconst_all lineconst,

4903:
4904: CURSOR csr_get_prior_periods (p_start_date date, p_fst_end_date date) is
4905: SELECT lineconst.VALUE
4906: FROM pn_rec_period_lines_all period_lines,
4907: pn_rec_agr_linconst_all lineconst,
4908: pn_rec_calc_periods_all recperiod
4909: WHERE period_lines.rec_agr_line_id = p_rec_agr_line_id
4910: AND recperiod.rec_calc_period_id = period_lines.rec_calc_period_id
4911: AND recperiod.start_date > p_fst_end_date

Line 4922: FROM pn_rec_agr_linconst_all lineconst

4918: AND lineconst.SCOPE = 'OPYC';
4919:
4920: CURSOR csr_get_curr_percent (p_start_date date, p_end_date date, p_as_of_date date) is
4921: SELECT lineconst.VALUE
4922: FROM pn_rec_agr_linconst_all lineconst
4923: WHERE lineconst.rec_agr_line_id = p_rec_agr_line_id
4924: AND p_as_of_date between lineconst.start_date and lineconst.end_date
4925: AND lineconst.RELATION = 'MAX'
4926: AND lineconst.SCOPE = 'OPYC';