APPS.IGS_EN_SPA_TERMS_API dependencies on IGS_EN_ATD_MODE

Line 2169: l_att_mode igs_en_atd_mode.attendance_mode%TYPE;

2165: p_program_cd IN VARCHAR2,
2166: p_term_cal_type IN VARCHAR2,
2167: p_term_sequence_NUMBER IN NUMBER
2168: ) RETURN VARCHAR2 AS
2169: l_att_mode igs_en_atd_mode.attendance_mode%TYPE;
2170: l_att_desc igs_en_atd_mode.description%TYPE;
2171: CURSOR c_att_desc (cp_att_mode igs_en_atd_mode.attendance_mode%TYPE) IS
2172: SELECT description
2173: FROM igs_en_atd_mode

Line 2170: l_att_desc igs_en_atd_mode.description%TYPE;

2166: p_term_cal_type IN VARCHAR2,
2167: p_term_sequence_NUMBER IN NUMBER
2168: ) RETURN VARCHAR2 AS
2169: l_att_mode igs_en_atd_mode.attendance_mode%TYPE;
2170: l_att_desc igs_en_atd_mode.description%TYPE;
2171: CURSOR c_att_desc (cp_att_mode igs_en_atd_mode.attendance_mode%TYPE) IS
2172: SELECT description
2173: FROM igs_en_atd_mode
2174: WHERE attendance_mode = cp_att_mode;

Line 2171: CURSOR c_att_desc (cp_att_mode igs_en_atd_mode.attendance_mode%TYPE) IS

2167: p_term_sequence_NUMBER IN NUMBER
2168: ) RETURN VARCHAR2 AS
2169: l_att_mode igs_en_atd_mode.attendance_mode%TYPE;
2170: l_att_desc igs_en_atd_mode.description%TYPE;
2171: CURSOR c_att_desc (cp_att_mode igs_en_atd_mode.attendance_mode%TYPE) IS
2172: SELECT description
2173: FROM igs_en_atd_mode
2174: WHERE attendance_mode = cp_att_mode;
2175:

Line 2173: FROM igs_en_atd_mode

2169: l_att_mode igs_en_atd_mode.attendance_mode%TYPE;
2170: l_att_desc igs_en_atd_mode.description%TYPE;
2171: CURSOR c_att_desc (cp_att_mode igs_en_atd_mode.attendance_mode%TYPE) IS
2172: SELECT description
2173: FROM igs_en_atd_mode
2174: WHERE attendance_mode = cp_att_mode;
2175:
2176: BEGIN
2177: l_att_mode := get_spat_att_mode(