APPS.GHR_COMPLAINTS2_PKG dependencies on GHR_COMPL_APPEALS

Line 668: FROM ghr_compl_appeals cap

664: --
665: -- Must use only Max Date Appeal for code test
666: CURSOR cur_rmd IS
667: SELECT 1
668: FROM ghr_compl_appeals cap
669: WHERE cap.complaint_id = p_complaint_id
670: AND cap.appeal_date = (SELECT MAX(cmp.appeal_date)
671: FROM ghr_compl_appeals cmp
672: WHERE cmp.complaint_id = p_complaint_id)

Line 671: FROM ghr_compl_appeals cmp

667: SELECT 1
668: FROM ghr_compl_appeals cap
669: WHERE cap.complaint_id = p_complaint_id
670: AND cap.appeal_date = (SELECT MAX(cmp.appeal_date)
671: FROM ghr_compl_appeals cmp
672: WHERE cmp.complaint_id = p_complaint_id)
673: AND cap.decision IN ('30', '40');
674: --
675: BEGIN