643: RETURN BOOLEAN IS
644: --
645: CURSOR cur_clm IS
646: SELECT 1
647: FROM ghr_compl_claims clm
648: WHERE clm.complaint_id = p_complaint_id
649: AND clm.mixed_flag = 'Y';
650: --
651: BEGIN
797: --
798: --
799: CURSOR cur_clm IS
800: SELECT 1
801: FROM ghr_compl_claims clm, ghr_compl_bases cba
802: WHERE clm.complaint_id = p_complaint_id
803: AND clm.compl_claim_id = cba.compl_claim_id
804: AND clm.phase in ('20','30')
805: AND cba.basis is NOT NULL;
819: --
820: --
821: CURSOR cur_clm2 IS
822: SELECT 1
823: FROM ghr_compl_claims clm, ghr_compl_bases cba
824: WHERE clm.complaint_id = p_complaint_id
825: AND clm.compl_claim_id = cba.compl_claim_id
826: AND clm.phase in ('10','30')
827: AND cba.basis is NOT NULL;
880: --
881: --
882: CURSOR cur_clm IS
883: SELECT 1
884: FROM ghr_compl_claims clm
885: WHERE clm.complaint_id = p_complaint_id;
886: --
887: BEGIN
888: FOR cur_clm_rec IN cur_clm LOOP