APPS.IGS_EN_SPA_TERMS_API dependencies on IGS_EN_ATD_TYPE

Line 2144: l_att_type igs_en_atd_type.attendance_type%TYPE;

2140: p_program_cd IN VARCHAR2,
2141: p_term_cal_type IN VARCHAR2,
2142: p_term_sequence_NUMBER IN NUMBER
2143: ) RETURN VARCHAR2 AS
2144: l_att_type igs_en_atd_type.attendance_type%TYPE;
2145: l_att_desc igs_en_atd_type.description%TYPE;
2146: CURSOR c_att_desc (cp_att_type igs_en_atd_type.attendance_type%TYPE) IS
2147: SELECT description
2148: FROM igs_en_atd_type

Line 2145: l_att_desc igs_en_atd_type.description%TYPE;

2141: p_term_cal_type IN VARCHAR2,
2142: p_term_sequence_NUMBER IN NUMBER
2143: ) RETURN VARCHAR2 AS
2144: l_att_type igs_en_atd_type.attendance_type%TYPE;
2145: l_att_desc igs_en_atd_type.description%TYPE;
2146: CURSOR c_att_desc (cp_att_type igs_en_atd_type.attendance_type%TYPE) IS
2147: SELECT description
2148: FROM igs_en_atd_type
2149: WHERE attendance_type = cp_att_type;

Line 2146: CURSOR c_att_desc (cp_att_type igs_en_atd_type.attendance_type%TYPE) IS

2142: p_term_sequence_NUMBER IN NUMBER
2143: ) RETURN VARCHAR2 AS
2144: l_att_type igs_en_atd_type.attendance_type%TYPE;
2145: l_att_desc igs_en_atd_type.description%TYPE;
2146: CURSOR c_att_desc (cp_att_type igs_en_atd_type.attendance_type%TYPE) IS
2147: SELECT description
2148: FROM igs_en_atd_type
2149: WHERE attendance_type = cp_att_type;
2150:

Line 2148: FROM igs_en_atd_type

2144: l_att_type igs_en_atd_type.attendance_type%TYPE;
2145: l_att_desc igs_en_atd_type.description%TYPE;
2146: CURSOR c_att_desc (cp_att_type igs_en_atd_type.attendance_type%TYPE) IS
2147: SELECT description
2148: FROM igs_en_atd_type
2149: WHERE attendance_type = cp_att_type;
2150:
2151: BEGIN
2152: l_att_type := get_spat_att_type(