DBA Data[Home] [Help]

APPS.IGS_AD_VAL_ACAI dependencies on IGS_PS_OF_OPT_UNT_ST

Line 1689: cp_unit_set_cd IGS_PS_OF_OPT_UNT_ST.unit_set_cd%TYPE,

1685: AND us.unit_set_cd = cp_unit_set_cd
1686: AND us.version_number = cp_us_version_number;
1687:
1688: CURSOR c_coousv (
1689: cp_unit_set_cd IGS_PS_OF_OPT_UNT_ST.unit_set_cd%TYPE,
1690: cp_us_version_number IGS_PS_OF_OPT_UNT_ST.us_version_number%TYPE,
1691: cp_course_cd IGS_PS_OF_OPT_UNT_ST.course_cd%TYPE,
1692: cp_crv_version_number IGS_PS_OF_OPT_UNT_ST.crv_version_number%TYPE,
1693: cp_acad_cal_type IGS_PS_OF_OPT_UNT_ST.cal_type%TYPE,

Line 1690: cp_us_version_number IGS_PS_OF_OPT_UNT_ST.us_version_number%TYPE,

1686: AND us.version_number = cp_us_version_number;
1687:
1688: CURSOR c_coousv (
1689: cp_unit_set_cd IGS_PS_OF_OPT_UNT_ST.unit_set_cd%TYPE,
1690: cp_us_version_number IGS_PS_OF_OPT_UNT_ST.us_version_number%TYPE,
1691: cp_course_cd IGS_PS_OF_OPT_UNT_ST.course_cd%TYPE,
1692: cp_crv_version_number IGS_PS_OF_OPT_UNT_ST.crv_version_number%TYPE,
1693: cp_acad_cal_type IGS_PS_OF_OPT_UNT_ST.cal_type%TYPE,
1694: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,

Line 1691: cp_course_cd IGS_PS_OF_OPT_UNT_ST.course_cd%TYPE,

1687:
1688: CURSOR c_coousv (
1689: cp_unit_set_cd IGS_PS_OF_OPT_UNT_ST.unit_set_cd%TYPE,
1690: cp_us_version_number IGS_PS_OF_OPT_UNT_ST.us_version_number%TYPE,
1691: cp_course_cd IGS_PS_OF_OPT_UNT_ST.course_cd%TYPE,
1692: cp_crv_version_number IGS_PS_OF_OPT_UNT_ST.crv_version_number%TYPE,
1693: cp_acad_cal_type IGS_PS_OF_OPT_UNT_ST.cal_type%TYPE,
1694: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1695: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,

Line 1692: cp_crv_version_number IGS_PS_OF_OPT_UNT_ST.crv_version_number%TYPE,

1688: CURSOR c_coousv (
1689: cp_unit_set_cd IGS_PS_OF_OPT_UNT_ST.unit_set_cd%TYPE,
1690: cp_us_version_number IGS_PS_OF_OPT_UNT_ST.us_version_number%TYPE,
1691: cp_course_cd IGS_PS_OF_OPT_UNT_ST.course_cd%TYPE,
1692: cp_crv_version_number IGS_PS_OF_OPT_UNT_ST.crv_version_number%TYPE,
1693: cp_acad_cal_type IGS_PS_OF_OPT_UNT_ST.cal_type%TYPE,
1694: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1695: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1696: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,

Line 1693: cp_acad_cal_type IGS_PS_OF_OPT_UNT_ST.cal_type%TYPE,

1689: cp_unit_set_cd IGS_PS_OF_OPT_UNT_ST.unit_set_cd%TYPE,
1690: cp_us_version_number IGS_PS_OF_OPT_UNT_ST.us_version_number%TYPE,
1691: cp_course_cd IGS_PS_OF_OPT_UNT_ST.course_cd%TYPE,
1692: cp_crv_version_number IGS_PS_OF_OPT_UNT_ST.crv_version_number%TYPE,
1693: cp_acad_cal_type IGS_PS_OF_OPT_UNT_ST.cal_type%TYPE,
1694: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1695: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1696: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,
1697: cp_attendance_type IGS_PS_COO_AD_UNIT_S.attendance_type%TYPE) IS