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_462 dependencies on GHR_COMPL_AGENCY_APPEALS

Line 198: FROM GHR_COMPLAINTS2 cmp , GHR_COMPL_AGENCY_APPEALS apa

194:
195: -- Cursor to populate Part 1.D
196: CURSOR cur_p1_d(c_from_date IN DATE,c_to_date IN DATE, c_agency_code ghr_complaints2.agency_code%type) IS
197: SELECT COUNT(*) p1_d_cnt
198: FROM GHR_COMPLAINTS2 cmp , GHR_COMPL_AGENCY_APPEALS apa
199: WHERE apa.complaint_id = cmp.complaint_id
200: AND apa.decision IN ('30','40')
201: AND cmp.init_counselor_interview >= cmp.formal_com_filed
202: AND cmp.init_counselor_interview BETWEEN c_from_date AND c_to_date

Line 438: AND (NOT EXISTS(SELECT 1 FROM GHR_COMPL_AGENCY_APPEALS apa

434: SELECT COUNT(*) p2_2_cnt
435: FROM GHR_COMPLAINTS2 cmp
436: WHERE cmp.formal_com_filed BETWEEN c_from_date AND c_to_date
437: AND cmp.agency_code = c_agency_code
438: AND (NOT EXISTS(SELECT 1 FROM GHR_COMPL_AGENCY_APPEALS apa
439: WHERE apa.complaint_id = cmp.complaint_id
440: AND apa.decision_date BETWEEN c_from_date AND c_to_date
441: AND apa.decision IN ('30','40'))
442: AND NOT EXISTS(SELECT 1 FROM GHR_COMPL_APPEALS ap

Line 456: AND (EXISTS(SELECT 1 FROM GHR_COMPL_AGENCY_APPEALS apa

452: WHERE cmp.formal_com_filed BETWEEN c_from_date AND c_to_date
453: AND cmp.agency_code = c_agency_code
454: AND (cmp.complaint_closed NOT BETWEEN c_from_date AND c_to_date
455: OR cmp.complaint_closed IS NULL)
456: AND (EXISTS(SELECT 1 FROM GHR_COMPL_AGENCY_APPEALS apa
457: WHERE apa.complaint_id = cmp.complaint_id
458: AND apa.decision_date BETWEEN c_from_date AND c_to_date
459: AND apa.decision IN ('30','40'))
460: OR EXISTS(SELECT 1 FROM GHR_COMPL_APPEALS ap

Line 481: AND (NOT EXISTS(SELECT 1 FROM GHR_COMPL_AGENCY_APPEALS apa

477: SELECT cmp.*
478: FROM GHR_COMPLAINTS2 cmp
479: WHERE cmp.formal_com_filed BETWEEN c_from_date AND c_to_date
480: AND cmp.agency_code = c_agency_code
481: AND (NOT EXISTS(SELECT 1 FROM GHR_COMPL_AGENCY_APPEALS apa
482: WHERE apa.complaint_id = cmp.complaint_id
483: AND apa.decision_date BETWEEN c_from_date AND c_to_date
484: AND apa.decision IN ('30','40'))
485: AND NOT EXISTS(SELECT 1 FROM GHR_COMPL_APPEALS ap

Line 496: AND (EXISTS(SELECT 1 FROM GHR_COMPL_AGENCY_APPEALS apa

492: WHERE cmp.formal_com_filed BETWEEN c_from_date AND c_to_date
493: AND cmp.agency_code = c_agency_code
494: AND (cmp.complaint_closed NOT BETWEEN c_from_date AND c_to_date
495: OR cmp.complaint_closed IS NULL)
496: AND (EXISTS(SELECT 1 FROM GHR_COMPL_AGENCY_APPEALS apa
497: WHERE apa.complaint_id = cmp.complaint_id
498: AND apa.decision_date BETWEEN c_from_date AND c_to_date
499: AND apa.decision IN ('30','40'))
500: OR EXISTS(SELECT 1 FROM GHR_COMPL_APPEALS ap

Line 525: AND (NOT EXISTS(SELECT 1 FROM GHR_COMPL_AGENCY_APPEALS apa

521: SELECT cmp.*
522: FROM GHR_COMPLAINTS2 cmp
523: WHERE cmp.formal_com_filed BETWEEN c_from_date AND c_to_date
524: AND cmp.agency_code = c_agency_code
525: AND (NOT EXISTS(SELECT 1 FROM GHR_COMPL_AGENCY_APPEALS apa
526: WHERE apa.complaint_id = cmp.complaint_id
527: AND apa.decision_date BETWEEN c_from_date AND c_to_date
528: AND apa.decision IN ('30','40'))
529: AND NOT EXISTS(SELECT 1 FROM GHR_COMPL_APPEALS ap

Line 540: AND (EXISTS(SELECT 1 FROM GHR_COMPL_AGENCY_APPEALS apa

536: WHERE cmp.formal_com_filed BETWEEN c_from_date AND c_to_date
537: AND cmp.agency_code = c_agency_code
538: AND (cmp.complaint_closed NOT BETWEEN c_from_date AND c_to_date
539: OR cmp.complaint_closed IS NULL)
540: AND (EXISTS(SELECT 1 FROM GHR_COMPL_AGENCY_APPEALS apa
541: WHERE apa.complaint_id = cmp.complaint_id
542: AND apa.decision_date BETWEEN c_from_date AND c_to_date
543: AND apa.decision IN ('30','40'))
544: OR EXISTS(SELECT 1 FROM GHR_COMPL_APPEALS ap

Line 566: AND (NOT EXISTS(SELECT 1 FROM GHR_COMPL_AGENCY_APPEALS apa

562: SELECT cmp.*
563: FROM GHR_COMPLAINTS2 cmp
564: WHERE cmp.formal_com_filed BETWEEN c_from_date AND c_to_date
565: AND cmp.agency_code = c_agency_code
566: AND (NOT EXISTS(SELECT 1 FROM GHR_COMPL_AGENCY_APPEALS apa
567: WHERE apa.complaint_id = cmp.complaint_id
568: AND apa.decision_date BETWEEN c_from_date AND c_to_date
569: AND apa.decision IN ('30','40'))
570: AND NOT EXISTS(SELECT 1 FROM GHR_COMPL_APPEALS ap

Line 581: AND (EXISTS(SELECT 1 FROM GHR_COMPL_AGENCY_APPEALS apa

577: WHERE cmp.formal_com_filed BETWEEN c_from_date AND c_to_date
578: AND cmp.agency_code = c_agency_code
579: AND (cmp.complaint_closed NOT BETWEEN c_from_date AND c_to_date
580: OR cmp.complaint_closed IS NULL)
581: AND (EXISTS(SELECT 1 FROM GHR_COMPL_AGENCY_APPEALS apa
582: WHERE apa.complaint_id = cmp.complaint_id
583: AND apa.decision_date BETWEEN c_from_date AND c_to_date
584: AND apa.decision IN ('30','40'))
585: OR EXISTS(SELECT 1 FROM GHR_COMPL_APPEALS ap

Line 608: AND (NOT EXISTS(SELECT 1 FROM GHR_COMPL_AGENCY_APPEALS apa

604: SELECT cmp.*
605: FROM GHR_COMPLAINTS2 cmp
606: WHERE cmp.formal_com_filed BETWEEN c_from_date AND c_to_date
607: AND cmp.agency_code = c_agency_code
608: AND (NOT EXISTS(SELECT 1 FROM GHR_COMPL_AGENCY_APPEALS apa
609: WHERE apa.complaint_id = cmp.complaint_id
610: AND apa.decision_date BETWEEN c_from_date AND c_to_date
611: AND apa.decision IN ('30','40'))
612: AND NOT EXISTS(SELECT 1 FROM GHR_COMPL_APPEALS ap

Line 623: AND (EXISTS(SELECT 1 FROM GHR_COMPL_AGENCY_APPEALS apa

619: WHERE cmp.formal_com_filed BETWEEN c_from_date AND c_to_date
620: AND cmp.agency_code = c_agency_code
621: AND (cmp.complaint_closed NOT BETWEEN c_from_date AND c_to_date
622: OR cmp.complaint_closed IS NULL)
623: AND (EXISTS(SELECT 1 FROM GHR_COMPL_AGENCY_APPEALS apa
624: WHERE apa.complaint_id = cmp.complaint_id
625: AND apa.decision_date BETWEEN c_from_date AND c_to_date
626: AND apa.decision IN ('30','40'))
627: OR EXISTS(SELECT 1 FROM GHR_COMPL_APPEALS ap