APPS.PN_REC_CALC_PKG dependencies on PN_REC_AGR_LINABAT_ALL

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

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

Line 3290: RETURN pn_rec_agr_linabat_all.amount%TYPE IS

3286: FUNCTION get_line_abatements (
3287: p_rec_agr_line_id pn_rec_agr_lines_all.rec_agr_line_id%TYPE
3288: ,p_as_of_date pn_rec_calc_periods_all.as_of_date%TYPE
3289: )
3290: RETURN pn_rec_agr_linabat_all.amount%TYPE IS
3291:
3292:
3293: CURSOR csr_get_abate IS
3294: SELECT NVL(SUM(NVL(amount,0)),0)

Line 3295: FROM pn_rec_agr_linabat_all abate

3291:
3292:
3293: CURSOR csr_get_abate IS
3294: SELECT NVL(SUM(NVL(amount,0)),0)
3295: FROM pn_rec_agr_linabat_all abate
3296: WHERE abate.rec_agr_line_id = p_rec_agr_line_id
3297: AND p_as_of_date between abate.start_date AND abate.end_date;
3298:
3299: l_line_abatements pn_rec_agr_linabat_all.amount%TYPE;

Line 3299: l_line_abatements pn_rec_agr_linabat_all.amount%TYPE;

3295: FROM pn_rec_agr_linabat_all abate
3296: WHERE abate.rec_agr_line_id = p_rec_agr_line_id
3297: AND p_as_of_date between abate.start_date AND abate.end_date;
3298:
3299: l_line_abatements pn_rec_agr_linabat_all.amount%TYPE;
3300:
3301: BEGIN
3302:
3303: OPEN csr_get_abate;