DBA Data[Home] [Help]

APPS.IGS_AD_GEN_014 dependencies on IGS_PS_OF_OPT_UNT_ST

Line 1543: cp_unit_set_cd IGS_PS_OF_OPT_UNT_ST.unit_set_cd%TYPE,

1539: AND us.version_number = cp_us_version_number;
1540:
1541:
1542: CURSOR c_coousv (
1543: cp_unit_set_cd IGS_PS_OF_OPT_UNT_ST.unit_set_cd%TYPE,
1544: cp_us_version_number IGS_PS_OF_OPT_UNT_ST.us_version_number%TYPE,
1545: cp_course_cd IGS_PS_OF_OPT_UNT_ST.course_cd%TYPE,
1546: cp_crv_version_number IGS_PS_OF_OPT_UNT_ST.crv_version_number%TYPE,
1547: cp_acad_cal_type IGS_PS_OF_OPT_UNT_ST.cal_type%TYPE,

Line 1544: cp_us_version_number IGS_PS_OF_OPT_UNT_ST.us_version_number%TYPE,

1540:
1541:
1542: CURSOR c_coousv (
1543: cp_unit_set_cd IGS_PS_OF_OPT_UNT_ST.unit_set_cd%TYPE,
1544: cp_us_version_number IGS_PS_OF_OPT_UNT_ST.us_version_number%TYPE,
1545: cp_course_cd IGS_PS_OF_OPT_UNT_ST.course_cd%TYPE,
1546: cp_crv_version_number IGS_PS_OF_OPT_UNT_ST.crv_version_number%TYPE,
1547: cp_acad_cal_type IGS_PS_OF_OPT_UNT_ST.cal_type%TYPE,
1548: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,

Line 1545: cp_course_cd IGS_PS_OF_OPT_UNT_ST.course_cd%TYPE,

1541:
1542: CURSOR c_coousv (
1543: cp_unit_set_cd IGS_PS_OF_OPT_UNT_ST.unit_set_cd%TYPE,
1544: cp_us_version_number IGS_PS_OF_OPT_UNT_ST.us_version_number%TYPE,
1545: cp_course_cd IGS_PS_OF_OPT_UNT_ST.course_cd%TYPE,
1546: cp_crv_version_number IGS_PS_OF_OPT_UNT_ST.crv_version_number%TYPE,
1547: cp_acad_cal_type IGS_PS_OF_OPT_UNT_ST.cal_type%TYPE,
1548: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1549: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,

Line 1546: cp_crv_version_number IGS_PS_OF_OPT_UNT_ST.crv_version_number%TYPE,

1542: CURSOR c_coousv (
1543: cp_unit_set_cd IGS_PS_OF_OPT_UNT_ST.unit_set_cd%TYPE,
1544: cp_us_version_number IGS_PS_OF_OPT_UNT_ST.us_version_number%TYPE,
1545: cp_course_cd IGS_PS_OF_OPT_UNT_ST.course_cd%TYPE,
1546: cp_crv_version_number IGS_PS_OF_OPT_UNT_ST.crv_version_number%TYPE,
1547: cp_acad_cal_type IGS_PS_OF_OPT_UNT_ST.cal_type%TYPE,
1548: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1549: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1550: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,

Line 1547: cp_acad_cal_type IGS_PS_OF_OPT_UNT_ST.cal_type%TYPE,

1543: cp_unit_set_cd IGS_PS_OF_OPT_UNT_ST.unit_set_cd%TYPE,
1544: cp_us_version_number IGS_PS_OF_OPT_UNT_ST.us_version_number%TYPE,
1545: cp_course_cd IGS_PS_OF_OPT_UNT_ST.course_cd%TYPE,
1546: cp_crv_version_number IGS_PS_OF_OPT_UNT_ST.crv_version_number%TYPE,
1547: cp_acad_cal_type IGS_PS_OF_OPT_UNT_ST.cal_type%TYPE,
1548: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1549: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1550: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,
1551: cp_attendance_type IGS_PS_COO_AD_UNIT_S.attendance_type%TYPE) IS