APPS.PN_REC_CALC_PKG dependencies on PN_REC_AGR_LINAREA_ALL

Line 2450: l_floor_pct pn_rec_agr_linarea_all.FLOOR_PCT%Type;

2446:
2447: l_tot_prop_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;
2448: l_total_occp_area pn_rec_arcl_dtl_all.TOTAL_OCCUPIED_AREA%Type;
2449: l_total_wgt_avg_area pn_rec_arcl_dtl_all.TOTAL_WEIGHTED_AVG%Type;
2450: l_floor_pct pn_rec_agr_linarea_all.FLOOR_PCT%Type;
2451: l_area_type pn_rec_agr_linarea_all.area_type%Type;
2452: l_area_class_dtl_id pn_rec_arcl_dtl_all.area_class_dtl_id%Type;
2453: l_asgn_area_contr pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2454: l_occp_area_contr pn_rec_arcl_dtlln_all.occupied_area%Type;

Line 2451: l_area_type pn_rec_agr_linarea_all.area_type%Type;

2447: l_tot_prop_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;
2448: l_total_occp_area pn_rec_arcl_dtl_all.TOTAL_OCCUPIED_AREA%Type;
2449: l_total_wgt_avg_area pn_rec_arcl_dtl_all.TOTAL_WEIGHTED_AVG%Type;
2450: l_floor_pct pn_rec_agr_linarea_all.FLOOR_PCT%Type;
2451: l_area_type pn_rec_agr_linarea_all.area_type%Type;
2452: l_area_class_dtl_id pn_rec_arcl_dtl_all.area_class_dtl_id%Type;
2453: l_asgn_area_contr pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2454: l_occp_area_contr pn_rec_arcl_dtlln_all.occupied_area%Type;
2455: l_wgt_avg_area_contr pn_rec_arcl_dtlln_all.WEIGHTED_AVG%Type;

Line 2472: ,pn_rec_agr_linarea_all linearea

2468: ,linearea.area_type
2469: ,area_class_dtl_hdr.area_class_dtl_id
2470: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2471: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
2472: ,pn_rec_agr_linarea_all linearea
2473: ,pn_rec_arcl_all aclass
2474: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
2475: AND p_as_of_date between linearea.start_date and linearea.end_date
2476: AND linearea.area_class_id = aclass.area_class_id

Line 2616: ,pn_rec_agr_linarea_all linearea

2612: ,occupancy_pct
2613: INTO l_ten_recoverable_area_rec
2614: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2615: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
2616: ,pn_rec_agr_linarea_all linearea
2617: ,pn_rec_arcl_all aclass
2618: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
2619: AND p_as_of_date between linearea.start_date and linearea.end_date
2620: AND linearea.area_class_id = aclass.area_class_id

Line 2728: ,pn_rec_agr_linarea_all linearea

2724: WHERE area_class_dtl_id =
2725: (SELECT area_class_dtl_hdr.area_class_dtl_id
2726: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2727: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
2728: ,pn_rec_agr_linarea_all linearea
2729: ,pn_rec_arcl_all aclass
2730: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
2731: AND p_as_of_date between linearea.start_date
2732: and linearea.end_date

Line 2811: ,pn_rec_agr_linarea_all linearea

2807: WHERE area_class_dtl_id =
2808: (SELECT area_class_dtl_hdr.area_class_dtl_id
2809: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2810: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
2811: ,pn_rec_agr_linarea_all linearea
2812: ,pn_rec_arcl_all aclass
2813: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
2814: AND p_as_of_date between linearea.start_date
2815: and linearea.end_date

Line 5131: ,pn_rec_agr_linarea_all linearea

5127: SELECT
5128: area_class_dtl_hdr.area_class_dtl_id as area_class_dtl_id
5129: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
5130: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
5131: ,pn_rec_agr_linarea_all linearea
5132: ,pn_rec_arcl_all aclass
5133: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
5134: AND p_as_of_date between linearea.start_date and linearea.end_date
5135: AND aclass.area_class_id = linearea.area_class_id