eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_COMPLAINTS2_PKG dependencies on GHR_COMPL_BASES

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 870: FROM ghr_compl_bases cba

866: --
867: --
868: CURSOR cur_cba IS
869: SELECT 1
870: FROM ghr_compl_bases cba
871: WHERE cba.compl_claim_id = p_compl_claim_id;
872: --
873: BEGIN
874: FOR cur_cba_rec IN cur_cba LOOP