APPS.PN_RECOVERY_EXTRACT_PKG dependencies on PN_REC_ARCL_DTL_ALL

Line 1013: pn_rec_arcl_dtl_all hdr,

1009: hdr.area_class_dtl_id,
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))

Line 1024: FROM pn_rec_arcl_dtl_all

1020: AND setup.area_class_id = hdr.area_class_id;
1021:
1022: CURSOR get_prior_cls_dtl_id IS
1023: SELECT area_class_dtl_id
1024: FROM pn_rec_arcl_dtl_all
1025: WHERE from_date < fnd_date.canonical_to_date(p_to_date)
1026: AND to_date <= fnd_date.canonical_to_date(p_to_date)
1027: AND as_of_date < fnd_date.canonical_to_date(p_as_of_date)
1028: AND area_class_id = p_area_class_id