APPS.PN_RECOVERY_EXTRACT_PKG dependencies on PN_REC_ARCL_DTLLN_ALL

Line 843: DELETE FROM pn_rec_arcl_dtlln_all

839: IF NOT l_is_in THEN delete_table(delete_table.COUNT) := p_old_data(i).area_class_dtl_line_id; END IF;
840: END LOOP;
841:
842: FORALL i IN 0 .. delete_table.COUNT - 1
843: DELETE FROM pn_rec_arcl_dtlln_all
844: WHERE area_class_dtl_line_id = delete_table(i);
845:
846: pnp_debug_pkg.log(l_desc ||' (-)');
847:

Line 1014: FROM pn_rec_arcl_dtlln_all dtl,

1010: dtl.area_class_dtl_line_id,
1011: hdr.area_class_dtl_id,
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

Line 1047: FROM pn_rec_arcl_dtlln_all

1043: exclude_area_flag,
1044: exclude_area_ovr_flag,
1045: recovery_space_std_code,
1046: recovery_type_code
1047: FROM pn_rec_arcl_dtlln_all
1048: WHERE area_class_dtl_id = p_prior_cls_dtl_id;
1049:
1050: l_area_class_dtl_id pn_rec_arcl_dtl.area_class_dtl_id%TYPE;
1051: l_area_class_dtl_line_id pn_rec_arcl_dtlln.area_class_dtl_line_id%TYPE;