APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on IGC_CC_CLOSED_CANC_HDRS_V

Line 3181: FROM igc_cc_closed_canc_hdrs_v ICCCHV,

3177: ICCCHV.cc_num_val,
3178: ICCCHV.cc_act_id,
3179: ICCCHV.cc_pf_id,
3180: ICCCHV.max_dt
3181: FROM igc_cc_closed_canc_hdrs_v ICCCHV,
3182: igc_cc_headers_all ICH
3183: WHERE ICH.cc_header_id = ICCCHV.cc_hd_id
3184: AND ICH.set_of_books_id = g_sob_id
3185: AND ICH.org_id = g_org_id