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_CLAIMS

Line 756: CURSOR cur_p4(c_from_date date, c_to_date date, c_claim GHR_COMPL_CLAIMS.claim%type, c_basis GHR_COMPL_BASES.basis%type, c_value GHR_COMPL_BASES.value%type,c_agency_code ghr_complaints2.agency_code%type) IS

752: p_from_date in date,
753: p_to_date in date,
754: p_agency_code in varchar2)
755: IS
756: CURSOR cur_p4(c_from_date date, c_to_date date, c_claim GHR_COMPL_CLAIMS.claim%type, c_basis GHR_COMPL_BASES.basis%type, c_value GHR_COMPL_BASES.value%type,c_agency_code ghr_complaints2.agency_code%type) IS
757: SELECT COUNT(*) p4_cnt
758: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases
759: WHERE bases.compl_claim_id = claims.compl_claim_id
760: AND claims.complaint_id = cmp.complaint_id

Line 758: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases

754: p_agency_code in varchar2)
755: IS
756: CURSOR cur_p4(c_from_date date, c_to_date date, c_claim GHR_COMPL_CLAIMS.claim%type, c_basis GHR_COMPL_BASES.basis%type, c_value GHR_COMPL_BASES.value%type,c_agency_code ghr_complaints2.agency_code%type) IS
757: SELECT COUNT(*) p4_cnt
758: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases
759: WHERE bases.compl_claim_id = claims.compl_claim_id
760: AND claims.complaint_id = cmp.complaint_id
761: AND claims.claim = c_claim
762: AND claims.phase IN (20,30)

Line 768: CURSOR cur_p4_novalue(c_from_date date, c_to_date date, c_claim GHR_COMPL_CLAIMS.claim%type, c_basis GHR_COMPL_BASES.basis%type,c_agency_code ghr_complaints2.agency_code%type) IS

764: AND bases.value = c_value
765: AND cmp.agency_code = c_agency_code
766: AND cmp.formal_com_filed BETWEEN c_from_date AND c_to_date;
767:
768: CURSOR cur_p4_novalue(c_from_date date, c_to_date date, c_claim GHR_COMPL_CLAIMS.claim%type, c_basis GHR_COMPL_BASES.basis%type,c_agency_code ghr_complaints2.agency_code%type) IS
769: SELECT COUNT(*) p4_cnt
770: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases
771: WHERE bases.compl_claim_id = claims.compl_claim_id
772: AND claims.complaint_id = cmp.complaint_id

Line 770: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases

766: AND cmp.formal_com_filed BETWEEN c_from_date AND c_to_date;
767:
768: CURSOR cur_p4_novalue(c_from_date date, c_to_date date, c_claim GHR_COMPL_CLAIMS.claim%type, c_basis GHR_COMPL_BASES.basis%type,c_agency_code ghr_complaints2.agency_code%type) IS
769: SELECT COUNT(*) p4_cnt
770: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases
771: WHERE bases.compl_claim_id = claims.compl_claim_id
772: AND claims.complaint_id = cmp.complaint_id
773: AND claims.claim = c_claim
774: AND claims.phase IN (20,30)

Line 780: CURSOR cur_p4_tot_pic_issue(c_from_date date, c_to_date date, c_claim GHR_COMPL_CLAIMS.claim%type,c_agency_code ghr_complaints2.agency_code%type) IS

776: AND cmp.agency_code = c_agency_code
777: AND cmp.formal_com_filed BETWEEN c_from_date AND c_to_date;
778:
779: -- Only for Pay including overtime
780: CURSOR cur_p4_tot_pic_issue(c_from_date date, c_to_date date, c_claim GHR_COMPL_CLAIMS.claim%type,c_agency_code ghr_complaints2.agency_code%type) IS
781: SELECT COUNT(distinct nvl(cmp.complainant_person_id,0)) p4_prsn_cnt, COUNT(distinct cmp.complaint_id) p4_cnt
782: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims
783: WHERE claims.complaint_id = cmp.complaint_id
784: AND claims.claim = c_claim

Line 782: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims

778:
779: -- Only for Pay including overtime
780: CURSOR cur_p4_tot_pic_issue(c_from_date date, c_to_date date, c_claim GHR_COMPL_CLAIMS.claim%type,c_agency_code ghr_complaints2.agency_code%type) IS
781: SELECT COUNT(distinct nvl(cmp.complainant_person_id,0)) p4_prsn_cnt, COUNT(distinct cmp.complaint_id) p4_cnt
782: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims
783: WHERE claims.complaint_id = cmp.complaint_id
784: AND claims.claim = c_claim
785: AND claims.phase IN (20,30)
786: AND cmp.agency_code = c_agency_code

Line 791: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims

787: AND cmp.formal_com_filed BETWEEN c_from_date AND c_to_date;
788:
789: CURSOR cur_p4_tot_discip_issue(c_from_date date, c_to_date date,c_agency_code ghr_complaints2.agency_code%type) IS
790: SELECT COUNT(distinct nvl(cmp.complainant_person_id,0)) p4_prsn_cnt, COUNT(distinct cmp.complaint_id) p4_cnt
791: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims
792: WHERE claims.complaint_id = cmp.complaint_id
793: AND claims.claim IN ('50','60','70','80','90')
794: AND claims.phase IN (20,30)
795: AND cmp.agency_code = c_agency_code

Line 800: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims

796: AND cmp.formal_com_filed BETWEEN c_from_date AND c_to_date;
797:
798: CURSOR cur_p4_tot_harass_issue(c_from_date date, c_to_date date,c_agency_code ghr_complaints2.agency_code%type) IS
799: SELECT COUNT(distinct nvl(cmp.complainant_person_id,0)) p4_prsn_cnt, COUNT(distinct cmp.complaint_id) p4_cnt
800: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims
801: WHERE claims.complaint_id = cmp.complaint_id
802: AND claims.claim IN ('130','140')
803: AND claims.phase IN (20,30)
804: AND cmp.agency_code = c_agency_code

Line 809: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases

805: AND cmp.formal_com_filed BETWEEN c_from_date AND c_to_date;
806:
807: /*CURSOR cur_p4_tot_harass_issue(c_from_date date, c_to_date date,c_agency_code ghr_complaints2.agency_code%type) IS
808: SELECT COUNT(distinct nvl(cmp.complainant_person_id,0)) p4_prsn_cnt, COUNT(distinct cmp.complaint_id) p4_cnt
809: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases
810: WHERE bases.compl_claim_id = claims.compl_claim_id
811: AND claims.complaint_id = cmp.complaint_id
812: AND claims.claim IN ('130','140')
813: AND claims.phase IN (20,30)

Line 821: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims

817: AND cmp.formal_com_filed BETWEEN c_from_date AND c_to_date;
818: */
819: CURSOR cur_p4_tot_reassign_issue(c_from_date date, c_to_date date,c_agency_code ghr_complaints2.agency_code%type) IS
820: SELECT COUNT(distinct nvl(cmp.complainant_person_id,0)) p4_prsn_cnt, COUNT(distinct cmp.complaint_id) p4_cnt
821: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims
822: WHERE claims.complaint_id = cmp.complaint_id
823: AND claims.claim IN ('180','190')
824: AND claims.phase IN (20,30)
825: AND cmp.agency_code = c_agency_code

Line 830: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases

826: AND cmp.formal_com_filed BETWEEN c_from_date AND c_to_date;
827:
828: CURSOR cur_p4_totprsn_basis(c_from_date date, c_to_date date, c_basis GHR_COMPL_BASES.basis%type,c_agency_code ghr_complaints2.agency_code%type) IS
829: SELECT COUNT(distinct nvl(cmp.complainant_person_id,0)) p4_prsn_cnt, COUNT(distinct cmp.complaint_id) p4_cnt
830: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases
831: WHERE bases.compl_claim_id = claims.compl_claim_id
832: AND claims.complaint_id = cmp.complaint_id
833: AND claims.phase IN (20,30)
834: AND bases.basis = c_basis

Line 840: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases

836: AND cmp.formal_com_filed BETWEEN c_from_date AND c_to_date;
837:
838: CURSOR cur_p4_totprsn_basis_value(c_from_date date, c_to_date date, c_basis GHR_COMPL_BASES.basis%type,c_value GHR_COMPL_BASES.value%type, c_agency_code ghr_complaints2.agency_code%type) IS
839: SELECT COUNT(distinct nvl(cmp.complainant_person_id,0)) p4_prsn_cnt,COUNT(distinct cmp.complaint_id) p4_cnt
840: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases
841: WHERE bases.compl_claim_id = claims.compl_claim_id
842: AND claims.complaint_id = cmp.complaint_id
843: AND claims.phase IN (20,30)
844: AND bases.basis = c_basis

Line 852: CURSOR cur_p4_totprsn_issue(c_from_date date, c_to_date date, c_claim GHR_COMPL_CLAIMS.claim%type,c_agency_code ghr_complaints2.agency_code%type) IS

848:
849: -------- Specific Total Cursors
850: -- Total By issues
851: -- For Most of the issues except pay including overtime, harassment, reassignment
852: CURSOR cur_p4_totprsn_issue(c_from_date date, c_to_date date, c_claim GHR_COMPL_CLAIMS.claim%type,c_agency_code ghr_complaints2.agency_code%type) IS
853: SELECT COUNT(distinct nvl(cmp.complainant_person_id,0)) p4_prsn_cnt, COUNT(distinct cmp.complaint_id) p4_cnt
854: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases
855: WHERE bases.compl_claim_id = claims.compl_claim_id
856: AND claims.complaint_id = cmp.complaint_id

Line 854: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases

850: -- Total By issues
851: -- For Most of the issues except pay including overtime, harassment, reassignment
852: CURSOR cur_p4_totprsn_issue(c_from_date date, c_to_date date, c_claim GHR_COMPL_CLAIMS.claim%type,c_agency_code ghr_complaints2.agency_code%type) IS
853: SELECT COUNT(distinct nvl(cmp.complainant_person_id,0)) p4_prsn_cnt, COUNT(distinct cmp.complaint_id) p4_cnt
854: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases
855: WHERE bases.compl_claim_id = claims.compl_claim_id
856: AND claims.complaint_id = cmp.complaint_id
857: AND claims.claim = c_claim
858: AND claims.phase IN (20,30)

Line 864: CURSOR cur_p4_tot_harass_sex_issue(c_from_date date, c_to_date date, c_claim GHR_COMPL_CLAIMS.claim%type,c_agency_code ghr_complaints2.agency_code%type) IS

860: AND cmp.agency_code = c_agency_code
861: AND cmp.formal_com_filed BETWEEN c_from_date AND c_to_date;
862:
863: -- For harassment Sexual
864: CURSOR cur_p4_tot_harass_sex_issue(c_from_date date, c_to_date date, c_claim GHR_COMPL_CLAIMS.claim%type,c_agency_code ghr_complaints2.agency_code%type) IS
865: SELECT COUNT(distinct nvl(cmp.complainant_person_id,0)) p4_prsn_cnt, COUNT(distinct cmp.complaint_id) p4_cnt
866: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases
867: WHERE bases.compl_claim_id = claims.compl_claim_id
868: AND claims.complaint_id = cmp.complaint_id

Line 866: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases

862:
863: -- For harassment Sexual
864: CURSOR cur_p4_tot_harass_sex_issue(c_from_date date, c_to_date date, c_claim GHR_COMPL_CLAIMS.claim%type,c_agency_code ghr_complaints2.agency_code%type) IS
865: SELECT COUNT(distinct nvl(cmp.complainant_person_id,0)) p4_prsn_cnt, COUNT(distinct cmp.complaint_id) p4_cnt
866: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases
867: WHERE bases.compl_claim_id = claims.compl_claim_id
868: AND claims.complaint_id = cmp.complaint_id
869: AND claims.claim = c_claim
870: AND claims.phase IN (20,30)

Line 876: CURSOR cur_p4_tot_reacc_issue(c_from_date date, c_to_date date, c_claim GHR_COMPL_CLAIMS.claim%type,c_agency_code ghr_complaints2.agency_code%type) IS

872: AND cmp.agency_code = c_agency_code
873: AND cmp.formal_com_filed BETWEEN c_from_date AND c_to_date;
874:
875: -- for reasonable accommodation
876: CURSOR cur_p4_tot_reacc_issue(c_from_date date, c_to_date date, c_claim GHR_COMPL_CLAIMS.claim%type,c_agency_code ghr_complaints2.agency_code%type) IS
877: SELECT COUNT(distinct nvl(cmp.complainant_person_id,0)) p4_prsn_cnt, COUNT(distinct cmp.complaint_id) p4_cnt
878: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases
879: WHERE bases.compl_claim_id = claims.compl_claim_id
880: AND claims.complaint_id = cmp.complaint_id

Line 878: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases

874:
875: -- for reasonable accommodation
876: CURSOR cur_p4_tot_reacc_issue(c_from_date date, c_to_date date, c_claim GHR_COMPL_CLAIMS.claim%type,c_agency_code ghr_complaints2.agency_code%type) IS
877: SELECT COUNT(distinct nvl(cmp.complainant_person_id,0)) p4_prsn_cnt, COUNT(distinct cmp.complaint_id) p4_cnt
878: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases
879: WHERE bases.compl_claim_id = claims.compl_claim_id
880: AND claims.complaint_id = cmp.complaint_id
881: AND claims.claim = c_claim
882: AND claims.phase IN (20,30)

Line 891: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases

887: -- For Race, National Origin
888:
889: CURSOR cur_p4_totprsn_rcno_value(c_from_date date, c_to_date date, c_basis GHR_COMPL_BASES.basis%type,c_value GHR_COMPL_BASES.value%type, c_agency_code ghr_complaints2.agency_code%type) IS
890: SELECT COUNT(distinct nvl(cmp.complainant_person_id,0)) p4_prsn_cnt,COUNT(distinct cmp.complaint_id) p4_cnt
891: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases
892: WHERE bases.compl_claim_id = claims.compl_claim_id
893: AND claims.complaint_id = cmp.complaint_id
894: AND claims.phase IN (20,30)
895: AND claims.claim NOT IN ('140','200')

Line 904: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases

900:
901: --Color, Age
902: CURSOR cur_p4_tot_colage_basis(c_from_date date, c_to_date date, c_basis GHR_COMPL_BASES.basis%type,c_agency_code ghr_complaints2.agency_code%type) IS
903: SELECT COUNT(distinct nvl(cmp.complainant_person_id,0)) p4_prsn_cnt, COUNT(distinct cmp.complaint_id) p4_cnt
904: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases
905: WHERE bases.compl_claim_id = claims.compl_claim_id
906: AND claims.complaint_id = cmp.complaint_id
907: AND claims.phase IN (20,30)
908: AND claims.claim NOT IN ('140','200')

Line 916: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases

912:
913: -- For Religion
914: CURSOR cur_p4_tot_rel_basis(c_from_date date, c_to_date date, c_basis GHR_COMPL_BASES.basis%type,c_agency_code ghr_complaints2.agency_code%type) IS
915: SELECT COUNT(distinct nvl(cmp.complainant_person_id,0)) p4_prsn_cnt, COUNT(distinct cmp.complaint_id) p4_cnt
916: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases
917: WHERE bases.compl_claim_id = claims.compl_claim_id
918: AND claims.complaint_id = cmp.complaint_id
919: AND claims.phase IN (20,30)
920: AND claims.claim NOT IN ('140')

Line 928: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases

924:
925: -- Disability
926: CURSOR cur_p4_totprsn_disab_value(c_from_date date, c_to_date date, c_basis GHR_COMPL_BASES.basis%type,c_value GHR_COMPL_BASES.value%type, c_agency_code ghr_complaints2.agency_code%type) IS
927: SELECT COUNT(distinct nvl(cmp.complainant_person_id,0)) p4_prsn_cnt,COUNT(distinct cmp.complaint_id) p4_cnt
928: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases
929: WHERE bases.compl_claim_id = claims.compl_claim_id
930: AND claims.complaint_id = cmp.complaint_id
931: AND claims.phase IN (20,30)
932: AND claims.claim NOT IN ('140')

Line 941: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases

937:
938: -- For Sex
939: CURSOR cur_p4_tot_sex_basis(c_from_date date, c_to_date date, c_basis GHR_COMPL_BASES.basis%type,c_value GHR_COMPL_BASES.value%type, c_agency_code ghr_complaints2.agency_code%type) IS
940: SELECT COUNT(distinct nvl(cmp.complainant_person_id,0)) p4_prsn_cnt, COUNT(distinct cmp.complaint_id) p4_cnt
941: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases
942: WHERE bases.compl_claim_id = claims.compl_claim_id
943: AND claims.complaint_id = cmp.complaint_id
944: AND claims.phase IN (20,30)
945: AND claims.claim NOT IN ('200')

Line 955: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases

951:
952: -- For equal pay act
953: CURSOR cur_p4_tot_eqpay_basis(c_from_date date, c_to_date date, c_basis GHR_COMPL_BASES.basis%type,c_value GHR_COMPL_BASES.value%type,c_agency_code ghr_complaints2.agency_code%type) IS
954: SELECT COUNT(distinct nvl(cmp.complainant_person_id,0)) p4_prsn_cnt, COUNT(distinct cmp.complaint_id) p4_cnt
955: FROM GHR_COMPLAINTS2 cmp,GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases
956: WHERE bases.compl_claim_id = claims.compl_claim_id
957: AND claims.complaint_id = cmp.complaint_id
958: AND claims.phase IN (20,30)
959: AND claims.claim = '160'

Line 2915: FROM GHR_COMPLAINTS2 cmp, GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases

2911: p_agency_code in varchar2)
2912: IS
2913: CURSOR cur_p5(c_from_date date, c_to_date date, c_statute ghr_compl_bases.statute%type,c_agency_code ghr_complaints2.agency_code%type) IS
2914: SELECT COUNT(*) p5_cnt
2915: FROM GHR_COMPLAINTS2 cmp, GHR_COMPL_CLAIMS claims, GHR_COMPL_BASES bases
2916: WHERE bases.compl_claim_id = claims.compl_claim_id
2917: AND claims.complaint_id = cmp.complaint_id
2918: AND claims.phase IN (20,30)
2919: AND cmp.complaint_closed BETWEEN c_from_date AND c_to_date