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 806: FROM ghr_compl_claims clm, ghr_compl_bases cba

802: --
803: --
804: CURSOR cur_clm IS
805: SELECT 1
806: FROM ghr_compl_claims clm, ghr_compl_bases cba
807: WHERE clm.complaint_id = p_complaint_id
808: AND clm.compl_claim_id = cba.compl_claim_id
809: AND clm.phase in ('20','30')
810: AND cba.basis is NOT NULL;

Line 828: FROM ghr_compl_claims clm, ghr_compl_bases cba

824: --
825: --
826: CURSOR cur_clm2 IS
827: SELECT 1
828: FROM ghr_compl_claims clm, ghr_compl_bases cba
829: WHERE clm.complaint_id = p_complaint_id
830: AND clm.compl_claim_id = cba.compl_claim_id
831: AND clm.phase in ('10','30')
832: AND cba.basis is NOT NULL;

Line 889: FROM ghr_compl_claims clm

885: --
886: --
887: CURSOR cur_clm IS
888: SELECT 1
889: FROM ghr_compl_claims clm
890: WHERE clm.complaint_id = p_complaint_id;
891: --
892: BEGIN
893: FOR cur_clm_rec IN cur_clm LOOP