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

861: --
862: --
863: CURSOR cur_cba IS
864: SELECT 1
865: FROM ghr_compl_bases cba
866: WHERE cba.compl_claim_id = p_compl_claim_id;
867: --
868: BEGIN
869: FOR cur_cba_rec IN cur_cba LOOP