APPS.GHR_COMPLAINTS2_PKG dependencies on GHR_COMPL_CLAIMS

Line 647: FROM ghr_compl_claims clm

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

Line 801: FROM ghr_compl_claims clm, ghr_compl_bases cba

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;

Line 823: FROM ghr_compl_claims clm, ghr_compl_bases cba

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;

Line 884: FROM ghr_compl_claims clm

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