APPS.PN_REC_CALC_PKG dependencies on PN_REC_AGR_LINABAT_ALL

Line 859: l_line_abatements pn_rec_agr_linabat_all.amount%TYPE:=0;

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;
863: l_budget_amount_per_sft NUMBER:=0;

Line 3375: RETURN pn_rec_agr_linabat_all.amount%TYPE IS

3371: FUNCTION get_line_abatements (
3372: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
3373: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
3374: )
3375: RETURN pn_rec_agr_linabat_all.amount%TYPE IS
3376:
3377:
3378: CURSOR csr_get_abate IS
3379: SELECT NVL(SUM(NVL(amount,0)),0)

Line 3380: FROM pn_rec_agr_linabat_all abate

3376:
3377:
3378: CURSOR csr_get_abate IS
3379: SELECT NVL(SUM(NVL(amount,0)),0)
3380: FROM pn_rec_agr_linabat_all abate
3381: WHERE abate.rec_agr_line_id = p_rec_agr_line_id
3382: AND p_as_of_date between abate.start_date AND abate.end_date;
3383:
3384: l_line_abatements pn_rec_agr_linabat_all.amount%TYPE;

Line 3384: l_line_abatements pn_rec_agr_linabat_all.amount%TYPE;

3380: FROM pn_rec_agr_linabat_all abate
3381: WHERE abate.rec_agr_line_id = p_rec_agr_line_id
3382: AND p_as_of_date between abate.start_date AND abate.end_date;
3383:
3384: l_line_abatements pn_rec_agr_linabat_all.amount%TYPE;
3385:
3386: BEGIN
3387:
3388: OPEN csr_get_abate;