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 939: pn_rec_arcl_exc_all excl_dtl

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

Line 1066: l_excl_type pn_rec_arcl_exc.exclusion_type_code%TYPE;

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