APPS.GHR_COMPLAINTS2_PKG dependencies on GHR_COMPL_CA_HEADERS
Line 786: from ghr_compl_ca_headers
782: CURSOR cur_cdt IS
783: SELECT 1
784: FROM ghr_compl_ca_details cdt
785: WHERE cdt.compl_ca_header_id in (select compl_ca_header_id 786: from ghr_compl_ca_headers 787: where complaint_id = p_complaint_id);
788: --
789: BEGIN
790: FOR cur_cdt_rec IN cur_cdt LOOP