APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_HE_POOUS_OU_CC

Line 4548: l_poous_cc igs_he_poous_ou_cc%ROWTYPE;

4544: l_sql_stmt VARCHAR2(2000);
4545: l_index NUMBER;
4546: l_total_prop NUMBER := 0;
4547: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
4548: l_poous_cc igs_he_poous_ou_cc%ROWTYPE;
4549: l_max_recs NUMBER;
4550:
4551: TYPE cur_cc IS REF CURSOR;
4552: c_cc cur_cc;

Line 4555: CURSOR c_field_of_study(p_subject igs_he_poous_ou_cc.subject%TYPE) IS

4551: TYPE cur_cc IS REF CURSOR;
4552: c_cc cur_cc;
4553:
4554: --smaddali added this cursor for bug 2417454 to get the govt code for oss field of study
4555: CURSOR c_field_of_study(p_subject igs_he_poous_ou_cc.subject%TYPE) IS
4556: SELECT govt_field_of_study
4557: FROM IGS_PS_FLD_OF_STUDY PFS
4558: WHERE field_of_study = p_subject;
4559:

Line 4590: FROM IGS_HE_POOUS_OU_CC pocc,

4586: cp_attendance_mode IGS_HE_POOUS_OU_ALL.attendance_mode%TYPE,
4587: cp_attendance_type IGS_HE_POOUS_OU_ALL.attendance_type%TYPE,
4588: cp_location_cd IGS_HE_POOUS_OU_ALL.location_cd%TYPE ) IS
4589: SELECT 'X'
4590: FROM IGS_HE_POOUS_OU_CC pocc,
4591: IGS_HE_POOUS_OU_ALL poou
4592: WHERE poou.hesa_poous_ou_id = pocc.hesa_poous_ou_id
4593: AND poou.course_cd = cp_course_cd
4594: AND poou.crv_version_number = cp_crv_version_number

Line 4764: FROM igs_he_poous_ou_cc pocc,

4760: CLOSE poo_cc_dtls_cur;
4761:
4762: OPEN c_cc FOR
4763: SELECT cost_centre, subject, SUM (pocc.proportion*NVL(poou.proportion,0)/100) proportion
4764: FROM igs_he_poous_ou_cc pocc,
4765: igs_he_poous_ou_all poou
4766: WHERE poou.hesa_poous_ou_id = pocc.hesa_poous_ou_id
4767: AND poou.course_cd = p_course_cd
4768: AND poou.crv_version_number = p_version_number