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_PS_USEC_SCHEDULE dependencies on IGS_AD_LOCATION

Line 106: FROM igs_ps_unit_ofr_opt_all uoo,igs_ps_unit_ver_all uv,igs_ca_inst_all ci, igs_ad_location_all loc

102: ci.alternate_code teaching_cal_alternate_code,
103: NULL subtitle,
104: uv.subtitle_id,
105: NVL(uoo.owner_org_unit_cd, uv.owner_org_unit_cd) owner_org_unit_cd
106: FROM igs_ps_unit_ofr_opt_all uoo,igs_ps_unit_ver_all uv,igs_ca_inst_all ci, igs_ad_location_all loc
107: WHERE uoo.cal_type = l_cal_type
108: AND uoo.ci_sequence_number = l_ci_sequence_number
109: AND uoo.unit_cd=cp_unit_cd
110: AND uoo.version_number=cp_version_number

Line 2275: FROM igs_ad_location

2271:
2272: -- Cursor to get location information to be exported to flat file
2273: CURSOR c_location IS
2274: SELECT location_cd,description,location_type,mail_dlvry_wrk_days,coord_person_id,closed_ind
2275: FROM igs_ad_location
2276: ORDER BY 1;
2277:
2278: -- Cursor added as part of bug#2833850
2279: -- Cursor to get region code information to be exported to flat file

Line 3062: FUNCTION get_location_description(p_location_cd igs_ad_location_all.location_cd%TYPE) RETURN VARCHAR2 AS

3058: log_usec_occurs (l_c_trans_type, rec_int_uso.instructor_id, rec_print_uso,'G');
3059: END;
3060:
3061: END update_info;
3062: FUNCTION get_location_description(p_location_cd igs_ad_location_all.location_cd%TYPE) RETURN VARCHAR2 AS
3063: CURSOR c_desc(cp_c_location_cd IN igs_ad_location_all.location_cd%TYPE) IS
3064: SELECT description
3065: FROM igs_ad_location_all
3066: WHERE location_cd = cp_c_location_cd;

Line 3063: CURSOR c_desc(cp_c_location_cd IN igs_ad_location_all.location_cd%TYPE) IS

3059: END;
3060:
3061: END update_info;
3062: FUNCTION get_location_description(p_location_cd igs_ad_location_all.location_cd%TYPE) RETURN VARCHAR2 AS
3063: CURSOR c_desc(cp_c_location_cd IN igs_ad_location_all.location_cd%TYPE) IS
3064: SELECT description
3065: FROM igs_ad_location_all
3066: WHERE location_cd = cp_c_location_cd;
3067: l_c_description igs_ad_location_all.description%TYPE;

Line 3065: FROM igs_ad_location_all

3061: END update_info;
3062: FUNCTION get_location_description(p_location_cd igs_ad_location_all.location_cd%TYPE) RETURN VARCHAR2 AS
3063: CURSOR c_desc(cp_c_location_cd IN igs_ad_location_all.location_cd%TYPE) IS
3064: SELECT description
3065: FROM igs_ad_location_all
3066: WHERE location_cd = cp_c_location_cd;
3067: l_c_description igs_ad_location_all.description%TYPE;
3068: BEGIN
3069: OPEN c_desc(p_location_cd);

Line 3067: l_c_description igs_ad_location_all.description%TYPE;

3063: CURSOR c_desc(cp_c_location_cd IN igs_ad_location_all.location_cd%TYPE) IS
3064: SELECT description
3065: FROM igs_ad_location_all
3066: WHERE location_cd = cp_c_location_cd;
3067: l_c_description igs_ad_location_all.description%TYPE;
3068: BEGIN
3069: OPEN c_desc(p_location_cd);
3070: FETCH c_desc INTO l_c_description;
3071: CLOSE c_desc;