APPS.CLN_PO_CHANGE_RESPONSE_PKG dependencies on CLN_COLL_HIST_HDR

Line 330: FROM cln_coll_hist_hdr ch, cln_coll_hist_dtl cd

326: END IF;
327:
328: SELECT max(ch.collaboration_id)
329: INTO l_coll_id
330: FROM cln_coll_hist_hdr ch, cln_coll_hist_dtl cd
331: WHERE ch.collaboration_id = cd.collaboration_id
332: AND cd.xmlg_internal_control_number = l_xmlg_int_control_num
333: AND ch.collaboration_type = 'SUPP_CHANGE_ORDER';
334: