APPS.IGS_PS_GEN_001 dependencies on IGS_PS_USO_INSTRCTRS

Line 2169: FROM igs_ps_uso_instrctrs

2165: --3
2166: --Enhancement bug no 1800179 , pmarada, added this cursor for unit section instructors
2167: CURSOR usec_instr(cp_Unit_Section_occurrence_id NUMBER) IS
2168: SELECT *
2169: FROM igs_ps_uso_instrctrs
2170: WHERE unit_section_occurrence_id = cp_Unit_Section_occurrence_id;
2171:
2172: --4
2173: CURSOR wlst_limit( p_uoo_id NUMBER) IS

Line 2853: igs_ps_uso_instrctrs_pkg.insert_row (

2849: 'in the Destination');
2850: END IF;
2851: CLOSE cur_usec_tchr1;
2852: ELSE
2853: igs_ps_uso_instrctrs_pkg.insert_row (
2854: x_rowid => lv_rowid,
2855: x_uso_instructor_id => l_uso_instructor_id,
2856: x_unit_section_occurrence_id => l_usec_id,
2857: x_instructor_id => usec_instr_rec.instructor_id,

Line 3272: CURSOR c_tch_ins(cp_uoo_id igs_ps_usec_occurs_all.uoo_id%TYPE,cp_ins_id igs_ps_uso_instrctrs.instructor_id%TYPE) IS

3268: AND instructor_id = cp_instructor_id
3269: AND ROWNUM = 1;
3270: l_cur_usec_tchr_new cur_usec_tchr_new%ROWTYPE;
3271:
3272: CURSOR c_tch_ins(cp_uoo_id igs_ps_usec_occurs_all.uoo_id%TYPE,cp_ins_id igs_ps_uso_instrctrs.instructor_id%TYPE) IS
3273: SELECT 'X'
3274: FROM igs_ps_usec_occurs_all a,igs_ps_uso_instrctrs b
3275: WHERE a.UNIT_SECTION_OCCURRENCE_ID = b.UNIT_SECTION_OCCURRENCE_ID
3276: AND a.uoo_id = cp_uoo_id

Line 3274: FROM igs_ps_usec_occurs_all a,igs_ps_uso_instrctrs b

3270: l_cur_usec_tchr_new cur_usec_tchr_new%ROWTYPE;
3271:
3272: CURSOR c_tch_ins(cp_uoo_id igs_ps_usec_occurs_all.uoo_id%TYPE,cp_ins_id igs_ps_uso_instrctrs.instructor_id%TYPE) IS
3273: SELECT 'X'
3274: FROM igs_ps_usec_occurs_all a,igs_ps_uso_instrctrs b
3275: WHERE a.UNIT_SECTION_OCCURRENCE_ID = b.UNIT_SECTION_OCCURRENCE_ID
3276: AND a.uoo_id = cp_uoo_id
3277: AND b.instructor_id= cp_ins_id;
3278: c_tch_ins_rec c_tch_ins%ROWTYPE;