APPS.IGS_AS_PRC_TRANSCRPT dependencies on IGS_PS_VER

Line 623: v_origin_course_cd IGS_PS_VER.course_cd%TYPE;

619: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
620: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
621: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
622: v_mark IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE;
623: v_origin_course_cd IGS_PS_VER.course_cd%TYPE;
624: cst_trn_sut_ln CONSTANT VARCHAR2(15) := 'TRN_SUT_LN';
625: cst_trn_sut_cd CONSTANT VARCHAR2(15) := 'TRN_SUT_CD';
626: cst_trn_sut_ul CONSTANT VARCHAR2(15) := 'TRN_SUT_UL';
627: cst_trn_sut_tl CONSTANT VARCHAR2(15) := 'TRN_SUT_TL';

Line 1208: v_origin_course_cd IGS_PS_VER.course_cd%TYPE;

1204: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
1205: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1206: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1207: v_mark IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE;
1208: v_origin_course_cd IGS_PS_VER.course_cd%TYPE;
1209: v_s_result_type VARCHAR2(20);
1210: v_out_string VARCHAR2(200);
1211:
1212: --Who When What

Line 1284: IGS_PS_VER cv

1280: v_dummy VARCHAR2(1);
1281: CURSOR c_cv IS
1282: SELECT 'x'
1283: FROM IGS_EN_STDNT_PS_ATT sca,
1284: IGS_PS_VER cv
1285: WHERE sca.person_id = p_person_id AND
1286: sca.course_cd = p_course_cd AND
1287: cv.course_cd = sca.course_cd AND
1288: cv.version_number = sca.version_number AND

Line 2016: IGS_PS_VER cv,

2012: -- anilk, 22-Apr-2003, Bug# 2829262
2013: suav.uoo_id
2014: FROM IGS_EN_STDNT_PS_ATT sca,
2015: IGS_EN_SUA_V suav,
2016: IGS_PS_VER cv,
2017: IGS_PS_OFR_PAT cop,
2018: IGS_CA_INST ci
2019: WHERE sca.person_id = p_person_id AND
2020: sca.person_id = suav.person_id AND

Line 2110: IGS_PS_VER cv,

2106: -- anilk, 22-Apr-2003, Bug# 2829262
2107: suav.uoo_id
2108: FROM IGS_EN_STDNT_PS_ATT sca,
2109: IGS_EN_SUA_V suav,
2110: IGS_PS_VER cv,
2111: IGS_PS_OFR_PAT cop,
2112: IGS_CA_INST ci
2113: WHERE sca.person_id = p_person_id AND
2114: sca.person_id = suav.person_id AND

Line 2193: p_generic_course_ind IGS_PS_VER.generic_course_ind%TYPE,

2189: ---------------------------------------asspl_val_dsp_g_crs----------------------
2190: FUNCTION asspl_val_dsp_g_crs(
2191: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
2192: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
2193: p_generic_course_ind IGS_PS_VER.generic_course_ind%TYPE,
2194: p_acad_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,
2195: p_acad_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE)
2196: RETURN BOOLEAN IS
2197: