APPS.PN_RECOVERY_EXTRACT_PKG dependencies on PN_REC_ARCL_ALL

Line 938: FROM pn_rec_arcl_all class,

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

Line 1014: pn_rec_arcl_all setup

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

Line 2953: FROM pn_rec_arcl_all

2949: IS
2950:
2951: CURSOR get_arcl_by_prop (l_propid pn_rec_exp_line.property_id%TYPE) IS
2952: SELECT area_class_id
2953: FROM pn_rec_arcl_all
2954: WHERE property_id = l_propid
2955: AND location_id IS NULL;
2956:
2957: CURSOR get_arcl_by_locn (l_locnid pn_rec_exp_line.location_id%TYPE) IS

Line 2959: FROM pn_rec_arcl_all

2955: AND location_id IS NULL;
2956:
2957: CURSOR get_arcl_by_locn (l_locnid pn_rec_exp_line.location_id%TYPE) IS
2958: SELECT area_class_id
2959: FROM pn_rec_arcl_all
2960: WHERE location_id = l_locnid;
2961:
2962: CURSOR get_locn_prop_id IS
2963: SELECT property_id,