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.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_PE_HZ_PARTIES

Line 35: FROM igs_pe_hz_parties ihp,

31: ***************************************************************/
32:
33: CURSOR c_get_instid IS
34: SELECT ihp.oi_govt_institution_cd govt_institution_cd
35: FROM igs_pe_hz_parties ihp,
36: igs_or_inst_stat st
37: WHERE ihp.oi_institution_status = st.institution_status AND
38: st.s_institution_status= 'ACTIVE' AND
39: ihp.oi_local_institution_ind = 'Y' AND

Line 2993: igs_pe_hz_parties ihpou,

2989: -- updated cursor for HZ_PARTIES.PARTY_NUMBER issue - bug #4401841
2990: CURSOR c_awdbdy (p_award_cd VARCHAR2) IS
2991: SELECT ihpinst.oi_govt_institution_cd govt_institution_cd
2992: FROM igs_ps_awd_own a,
2993: igs_pe_hz_parties ihpou,
2994: igs_pe_hz_parties ihpinst
2995: WHERE a.course_cd = p_course_cd
2996: AND a.version_number = p_version_number
2997: AND a.award_cd = p_award_cd

Line 2994: igs_pe_hz_parties ihpinst

2990: CURSOR c_awdbdy (p_award_cd VARCHAR2) IS
2991: SELECT ihpinst.oi_govt_institution_cd govt_institution_cd
2992: FROM igs_ps_awd_own a,
2993: igs_pe_hz_parties ihpou,
2994: igs_pe_hz_parties ihpinst
2995: WHERE a.course_cd = p_course_cd
2996: AND a.version_number = p_version_number
2997: AND a.award_cd = p_award_cd
2998: AND a.org_unit_cd = ihpou.oss_org_unit_cd

Line 4063: FROM igs_pe_hz_parties ihp

4059: -- anwest 09-Jun-05
4060: -- updated cursor for HZ_PARTIES.PARTY_NUMBER issue - bug #4401841
4061: CURSOR c_inst (p_inst_cd VARCHAR2) IS
4062: SELECT ihp.oi_govt_institution_cd govt_institution_cd
4063: FROM igs_pe_hz_parties ihp
4064: WHERE ihp.oss_org_unit_cd = p_inst_cd;
4065:
4066: CURSOR c_un_inst IS
4067: SELECT ihpinst.oi_govt_institution_cd govt_institution_cd

Line 4070: igs_pe_hz_parties ihpou,

4066: CURSOR c_un_inst IS
4067: SELECT ihpinst.oi_govt_institution_cd govt_institution_cd
4068: FROM igs_en_su_attempt a,
4069: igs_ps_tch_resp b,
4070: igs_pe_hz_parties ihpou,
4071: igs_pe_hz_parties ihpinst,
4072: igs_he_st_unt_vs_all hunt
4073: WHERE a.course_cd = p_course_cd
4074: AND a.person_id = p_person_id

Line 4071: igs_pe_hz_parties ihpinst,

4067: SELECT ihpinst.oi_govt_institution_cd govt_institution_cd
4068: FROM igs_en_su_attempt a,
4069: igs_ps_tch_resp b,
4070: igs_pe_hz_parties ihpou,
4071: igs_pe_hz_parties ihpinst,
4072: igs_he_st_unt_vs_all hunt
4073: WHERE a.course_cd = p_course_cd
4074: AND a.person_id = p_person_id
4075: AND b.unit_cd = a.unit_cd

Line 4182: igs_pe_hz_parties ihpou,

4178: CURSOR c_other_inst_cp IS
4179: SELECT SUM( NVL(override_enrolled_cp,NVL(cps.enrolled_credit_points,e.enrolled_credit_points)) * b.percentage / 100 ) other_inst_cp
4180: FROM igs_en_su_attempt a,
4181: igs_ps_tch_resp b,
4182: igs_pe_hz_parties ihpou,
4183: igs_pe_hz_parties ihpinst,
4184: igs_ps_unit_ver e,
4185: igs_ps_usec_cps cps,
4186: igs_he_st_unt_vs_all hunt

Line 4183: igs_pe_hz_parties ihpinst,

4179: SELECT SUM( NVL(override_enrolled_cp,NVL(cps.enrolled_credit_points,e.enrolled_credit_points)) * b.percentage / 100 ) other_inst_cp
4180: FROM igs_en_su_attempt a,
4181: igs_ps_tch_resp b,
4182: igs_pe_hz_parties ihpou,
4183: igs_pe_hz_parties ihpinst,
4184: igs_ps_unit_ver e,
4185: igs_ps_usec_cps cps,
4186: igs_he_st_unt_vs_all hunt
4187: WHERE a.course_cd = p_course_cd

Line 5813: FROM igs_pe_hz_parties ihp

5809: -- anwest 09-Jun-05
5810: -- updated cursor for HZ_PARTIES.PARTY_NUMBER issue - bug #4401841
5811: CURSOR c_gvinst (p_inst_cd VARCHAR2) IS
5812: SELECT ihp.oi_govt_institution_cd govt_institution_cd
5813: FROM igs_pe_hz_parties ihp
5814: WHERE ihp.oss_org_unit_cd = p_inst_cd;
5815:
5816: l_oss_inst_cd igs_ad_acad_history_v.institution_code%TYPE;
5817: l_year DATE;

Line 5820: l_govt_institution_cd igs_pe_hz_parties.oi_govt_institution_cd%TYPE;

5816: l_oss_inst_cd igs_ad_acad_history_v.institution_code%TYPE;
5817: l_year DATE;
5818: l_creation_date DATE;
5819: l_org_alternate_id igs_or_org_alt_ids_v.org_alternate_id%TYPE;
5820: l_govt_institution_cd igs_pe_hz_parties.oi_govt_institution_cd%TYPE;
5821: l_he_code_map_val igs_he_code_map_val%ROWTYPE;
5822:
5823: BEGIN
5824:

Line 6599: igs_pe_hz_parties ihpou,

6595: -- updated cursor for HZ_PARTIES.PARTY_NUMBER issue - bug #4401841
6596: CURSOR c_perc IS
6597: SELECT SUM(percentage)
6598: FROM igs_ps_tch_resp a,
6599: igs_pe_hz_parties ihpou,
6600: igs_pe_hz_parties ihpinst
6601: WHERE a.unit_cd = p_unit_cd
6602: AND a.version_number = p_version_number
6603: AND a.org_unit_cd = ihpou.oss_org_unit_cd

Line 6600: igs_pe_hz_parties ihpinst

6596: CURSOR c_perc IS
6597: SELECT SUM(percentage)
6598: FROM igs_ps_tch_resp a,
6599: igs_pe_hz_parties ihpou,
6600: igs_pe_hz_parties ihpinst
6601: WHERE a.unit_cd = p_unit_cd
6602: AND a.version_number = p_version_number
6603: AND a.org_unit_cd = ihpou.oss_org_unit_cd
6604: AND ihpou.institution_cd = ihpinst.oss_org_unit_cd

Line 6653: igs_pe_hz_parties ihpou,

6649: CURSOR c_oinst IS
6650: SELECT SUM(percentage) percentage,
6651: ihpinst.oi_govt_institution_cd govt_institution_cd
6652: FROM igs_ps_tch_resp a,
6653: igs_pe_hz_parties ihpou,
6654: igs_pe_hz_parties ihpinst
6655: WHERE a.unit_cd = p_unit_cd
6656: AND a.version_number = p_version_number
6657: AND a.org_unit_cd = ihpou.oss_org_unit_cd

Line 6654: igs_pe_hz_parties ihpinst

6650: SELECT SUM(percentage) percentage,
6651: ihpinst.oi_govt_institution_cd govt_institution_cd
6652: FROM igs_ps_tch_resp a,
6653: igs_pe_hz_parties ihpou,
6654: igs_pe_hz_parties ihpinst
6655: WHERE a.unit_cd = p_unit_cd
6656: AND a.version_number = p_version_number
6657: AND a.org_unit_cd = ihpou.oss_org_unit_cd
6658: AND ihpou.institution_cd = ihpinst.oss_org_unit_cd