APPS.PN_REC_CALC_PKG dependencies on PN_REC_AGR_LINAREA_ALL

Line 2481: l_floor_pct pn_rec_agr_linarea_all.FLOOR_PCT%Type;

2477:
2478: l_tot_prop_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;
2479: l_total_occp_area pn_rec_arcl_dtl_all.TOTAL_OCCUPIED_AREA%Type;
2480: l_total_wgt_avg_area pn_rec_arcl_dtl_all.TOTAL_WEIGHTED_AVG%Type;
2481: l_floor_pct pn_rec_agr_linarea_all.FLOOR_PCT%Type;
2482: l_area_type pn_rec_agr_linarea_all.area_type%Type;
2483: l_area_class_dtl_id pn_rec_arcl_dtl_all.area_class_dtl_id%Type;
2484: l_asgn_area_contr pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2485: l_occp_area_contr pn_rec_arcl_dtlln_all.occupied_area%Type;

Line 2482: l_area_type pn_rec_agr_linarea_all.area_type%Type;

2478: l_tot_prop_area pn_rec_arcl_dtl_all.TOTAL_assignable_area%TYPE;
2479: l_total_occp_area pn_rec_arcl_dtl_all.TOTAL_OCCUPIED_AREA%Type;
2480: l_total_wgt_avg_area pn_rec_arcl_dtl_all.TOTAL_WEIGHTED_AVG%Type;
2481: l_floor_pct pn_rec_agr_linarea_all.FLOOR_PCT%Type;
2482: l_area_type pn_rec_agr_linarea_all.area_type%Type;
2483: l_area_class_dtl_id pn_rec_arcl_dtl_all.area_class_dtl_id%Type;
2484: l_asgn_area_contr pn_rec_arcl_dtlln_all.ASSIGNABLE_AREA%Type;
2485: l_occp_area_contr pn_rec_arcl_dtlln_all.occupied_area%Type;
2486: l_wgt_avg_area_contr pn_rec_arcl_dtlln_all.WEIGHTED_AVG%Type;

Line 2503: ,pn_rec_agr_linarea_all linearea

2499: ,linearea.area_type
2500: ,area_class_dtl_hdr.area_class_dtl_id
2501: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2502: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
2503: ,pn_rec_agr_linarea_all linearea
2504: ,pn_rec_arcl_all aclass
2505: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
2506: AND p_as_of_date between linearea.start_date and linearea.end_date
2507: AND linearea.area_class_id = aclass.area_class_id

Line 2650: ,pn_rec_agr_linarea_all linearea

2646: ,occupancy_pct
2647: INTO l_ten_recoverable_area_rec
2648: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2649: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
2650: ,pn_rec_agr_linarea_all linearea
2651: ,pn_rec_arcl_all aclass
2652: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
2653: AND p_as_of_date between linearea.start_date and linearea.end_date
2654: AND linearea.area_class_id = aclass.area_class_id

Line 2762: ,pn_rec_agr_linarea_all linearea

2758: WHERE area_class_dtl_id =
2759: (SELECT area_class_dtl_hdr.area_class_dtl_id
2760: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2761: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
2762: ,pn_rec_agr_linarea_all linearea
2763: ,pn_rec_arcl_all aclass
2764: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
2765: AND p_as_of_date between linearea.start_date
2766: and linearea.end_date

Line 2845: ,pn_rec_agr_linarea_all linearea

2841: WHERE area_class_dtl_id =
2842: (SELECT area_class_dtl_hdr.area_class_dtl_id
2843: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
2844: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
2845: ,pn_rec_agr_linarea_all linearea
2846: ,pn_rec_arcl_all aclass
2847: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
2848: AND p_as_of_date between linearea.start_date
2849: and linearea.end_date

Line 5216: ,pn_rec_agr_linarea_all linearea

5212: SELECT
5213: area_class_dtl_hdr.area_class_dtl_id as area_class_dtl_id
5214: FROM pn_rec_arcl_dtlln_all area_class_dtl_lines
5215: ,pn_rec_arcl_dtl_all area_class_dtl_hdr
5216: ,pn_rec_agr_linarea_all linearea
5217: ,pn_rec_arcl_all aclass
5218: WHERE linearea.rec_agr_line_id = p_rec_agr_line_id
5219: AND p_as_of_date between linearea.start_date and linearea.end_date
5220: AND aclass.area_class_id = linearea.area_class_id