APPS.PN_RECOVERY_EXTRACT_PKG dependencies on PN_REC_ARCL_EXC

Line 13: TYPE area_cls_exc_tbl IS TABLE OF pn_rec_arcl_exc%ROWTYPE INDEX BY BINARY_INTEGER;

9: TYPE exp_cls_line_mst_tbl IS TABLE OF pn_rec_expcl_dtlln%ROWTYPE INDEX BY BINARY_INTEGER;
10: TYPE exp_cls_line_dtl_tbl IS TABLE OF pn_rec_expcl_dtlacc%ROWTYPE INDEX BY BINARY_INTEGER;
11: TYPE area_cls_line_dtl_tbl IS TABLE OF pn_rec_arcl_dtlln%ROWTYPE INDEX BY BINARY_INTEGER;
12: TYPE area_cls_line_hdr_tbl IS TABLE OF pn_rec_arcl_dtl%ROWTYPE INDEX BY BINARY_INTEGER;
13: TYPE area_cls_exc_tbl IS TABLE OF pn_rec_arcl_exc%ROWTYPE INDEX BY BINARY_INTEGER;
14:
15: bad_input_exception EXCEPTION;
16: uom_exception EXCEPTION;
17: currency_exception EXCEPTION;

Line 941: pn_rec_arcl_exc_all excl_dtl

937: excl_dtl.area_class_exclusion_id,
938: excl_dtl.recovery_space_std_code,
939: excl_dtl.recovery_type_code
940: FROM pn_rec_arcl_all class,
941: pn_rec_arcl_exc_all excl_dtl
942: WHERE class.area_class_id = excl_dtl.area_class_id (+)
943: AND class.area_class_id = p_area_class_id;
944:
945: CURSOR get_location_info(

Line 1068: l_excl_type pn_rec_arcl_exc.exclusion_type_code%TYPE;

1064: l_to_date pn_rec_arcl_dtlln.to_date%TYPE;
1065: l_occup_pct pn_rec_arcl_dtlln.occupancy_pct%TYPE;
1066: l_weighted_avg pn_rec_arcl_dtlln.weighted_avg%TYPE;
1067: l_occup_area pn_rec_arcl_dtlln.occupied_area%TYPE;
1068: l_excl_type pn_rec_arcl_exc.exclusion_type_code%TYPE;
1069: l_excl_prorata_flag pn_rec_arcl_dtlln.exclude_prorata_flag%TYPE;
1070: l_excl_area_flag pn_rec_arcl_dtlln.exclude_area_flag%TYPE;
1071: l_include_flag pn_rec_arcl_dtlln.include_flag%TYPE;
1072: l_occup_area_ovr pn_rec_arcl_dtlln.occupied_area_ovr%TYPE;