APPS.PN_RECOVERY_EXTRACT_PKG dependencies on PN_REC_ARCL_ALL

Line 940: FROM pn_rec_arcl_all class,

936: excl_dtl.area,
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:

Line 1016: pn_rec_arcl_all setup

1012: hdr.status,
1013: setup.area_class_name
1014: FROM pn_rec_arcl_dtlln_all dtl,
1015: pn_rec_arcl_dtl_all hdr,
1016: pn_rec_arcl_all setup
1017: WHERE dtl.area_class_dtl_id (+) = hdr.area_class_dtl_id
1018: AND hdr.area_class_id = p_area_class_id
1019: AND TRUNC(hdr.as_of_date) = TRUNC(fnd_date.canonical_to_date(p_as_of_date))
1020: AND TRUNC(hdr.from_date) = TRUNC(fnd_date.canonical_to_date(p_from_date))

Line 2965: FROM pn_rec_arcl_all

2961: IS
2962:
2963: CURSOR get_arcl_by_prop (l_propid pn_rec_exp_line.property_id%TYPE) IS
2964: SELECT area_class_id
2965: FROM pn_rec_arcl_all
2966: WHERE property_id = l_propid
2967: AND location_id IS NULL;
2968:
2969: CURSOR get_arcl_by_locn (l_locnid pn_rec_exp_line.location_id%TYPE) IS

Line 2971: FROM pn_rec_arcl_all

2967: AND location_id IS NULL;
2968:
2969: CURSOR get_arcl_by_locn (l_locnid pn_rec_exp_line.location_id%TYPE) IS
2970: SELECT area_class_id
2971: FROM pn_rec_arcl_all
2972: WHERE location_id = l_locnid;
2973:
2974: CURSOR get_locn_prop_id IS
2975: SELECT property_id,