APPS.IGS_PS_GEN_001 dependencies on IGS_PS_UNIT_OFR_OPT_ALL

Line 2314: igs_ps_unit_ofr_opt_all b

2310:
2311: CURSOR c_rtn_us IS
2312: SELECT a.*
2313: FROM igs_ps_nsus_rtn a,
2314: igs_ps_unit_ofr_opt_all b
2315: WHERE a.uoo_id = p_old_uoo_id
2316: AND a.uoo_id = b.uoo_id
2317: AND b.non_std_usec_ind = 'Y'
2318: AND a.definition_code IN ('UNIT_SECTION','UNIT_SECTION_FEE_TYPE');

Line 4229: FROM igs_ps_unit_ofr_opt_all usec

4225: */
4226:
4227: CURSOR c_uoo_id IS
4228: SELECT usec.* ,usec.rowid
4229: FROM igs_ps_unit_ofr_opt_all usec
4230: WHERE cal_type=p_c_cal_type
4231: AND ci_sequence_number=p_n_ci_sequence_number;
4232:
4233: l_b_found BOOLEAN := FALSE;

Line 4455: FROM igs_ps_usec_tch_resp utr,igs_ps_unit_ofr_opt_all opt

4451: )IS
4452: SELECT NVL(utr.INSTRUCTIONAL_LOAD_LAB,0) +
4453: NVL(utr.INSTRUCTIONAL_LOAD_LECTURE,0) +
4454: NVL(utr.INSTRUCTIONAL_LOAD,0) teach_wl
4455: FROM igs_ps_usec_tch_resp utr,igs_ps_unit_ofr_opt_all opt
4456: WHERE utr.instructor_id = cp_n_person_id AND
4457: utr.uoo_id = opt.uoo_id AND
4458: opt.cal_type = cp_c_cal_type AND
4459: utr.confirmed_flag = 'Y' AND