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 1012: FROM pn_rec_arcl_dtlln_all dtl,

1008: dtl.area_class_dtl_line_id,
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

Line 1045: FROM pn_rec_arcl_dtlln_all

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