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_APPEALS

Line 442: AND NOT EXISTS(SELECT 1 FROM GHR_COMPL_APPEALS ap

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
443: WHERE ap.complaint_id = cmp.complaint_id
444: AND ap.decision_date BETWEEN c_from_date AND c_to_date
445: AND ap.decision IN ('30','40')));
446:

Line 460: OR EXISTS(SELECT 1 FROM GHR_COMPL_APPEALS ap

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
461: WHERE ap.complaint_id = cmp.complaint_id
462: AND ap.decision_date BETWEEN c_from_date AND c_to_date
463: AND ap.decision IN ('30','40')));
464:

Line 485: AND NOT EXISTS(SELECT 1 FROM GHR_COMPL_APPEALS ap

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
486: WHERE ap.complaint_id = cmp.complaint_id
487: AND ap.decision_date BETWEEN c_from_date AND c_to_date
488: AND ap.decision IN ('30','40')))
489: UNION ALL

Line 500: OR EXISTS(SELECT 1 FROM GHR_COMPL_APPEALS ap

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
501: WHERE ap.complaint_id = cmp.complaint_id
502: AND ap.decision_date BETWEEN c_from_date AND c_to_date
503: AND ap.decision IN ('30','40')))
504: ) cmp1

Line 529: AND NOT EXISTS(SELECT 1 FROM GHR_COMPL_APPEALS ap

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
530: WHERE ap.complaint_id = cmp.complaint_id
531: AND ap.decision_date BETWEEN c_from_date AND c_to_date
532: AND ap.decision IN ('30','40')))
533: UNION ALL

Line 544: OR EXISTS(SELECT 1 FROM GHR_COMPL_APPEALS ap

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
545: WHERE ap.complaint_id = cmp.complaint_id
546: AND ap.decision_date BETWEEN c_from_date AND c_to_date
547: AND ap.decision IN ('30','40')))
548: ) cmp1

Line 570: AND NOT EXISTS(SELECT 1 FROM GHR_COMPL_APPEALS ap

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
571: WHERE ap.complaint_id = cmp.complaint_id
572: AND ap.decision_date BETWEEN c_from_date AND c_to_date
573: AND ap.decision IN ('30','40')))
574: UNION ALL

Line 585: OR EXISTS(SELECT 1 FROM GHR_COMPL_APPEALS ap

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
586: WHERE ap.complaint_id = cmp.complaint_id
587: AND ap.decision_date BETWEEN c_from_date AND c_to_date
588: AND ap.decision IN ('30','40')))
589: ) cmp1

Line 612: AND NOT EXISTS(SELECT 1 FROM GHR_COMPL_APPEALS ap

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
613: WHERE ap.complaint_id = cmp.complaint_id
614: AND ap.decision_date BETWEEN c_from_date AND c_to_date
615: AND ap.decision IN ('30','40')))
616: UNION ALL

Line 627: OR EXISTS(SELECT 1 FROM GHR_COMPL_APPEALS ap

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
628: WHERE ap.complaint_id = cmp.complaint_id
629: AND ap.decision_date BETWEEN c_from_date AND c_to_date
630: AND ap.decision IN ('30','40')))
631: ) cmp1