APPS.GHR_COMPLAINTS2_PKG dependencies on GHR_COMPL_CA_HEADERS

Line 781: from ghr_compl_ca_headers

777: CURSOR cur_cdt IS
778: SELECT 1
779: FROM ghr_compl_ca_details cdt
780: WHERE cdt.compl_ca_header_id in (select compl_ca_header_id
781: from ghr_compl_ca_headers
782: where complaint_id = p_complaint_id);
783: --
784: BEGIN
785: FOR cur_cdt_rec IN cur_cdt LOOP