APPS.IGS_EN_DASHBOARD dependencies on IGS_EN_SPA_TERMS

Line 92: AND igs_en_spa_terms_api.get_spat_primary_prg(sca.person_id, sca.course_cd, ci.cal_type,ci.sequence_number)='PRIMARY'

88: AND ci.cal_status = cs.cal_status
89: AND ( ci.schedule_flag ='Y' OR ci.planning_flag ='Y')
90: AND cs.s_cal_status = 'ACTIVE'
91: AND ca.closed_ind = 'N'
92: AND igs_en_spa_terms_api.get_spat_primary_prg(sca.person_id, sca.course_cd, ci.cal_type,ci.sequence_number)='PRIMARY'
93: ORDER BY ci.start_dt desc;
94:
95: -- Cursor to get program related information
96: -- Used in program mode.

Line 143: FROM igs_en_spa_terms

139: cp_c_program IN VARCHAR2,
140: cp_c_cal_type in VARCHAR2,
141: cp_n_seq_num IN NUMBER) IS
142: SELECT PLAN_SHT_STATUS
143: FROM igs_en_spa_terms
144: WHERE person_id = cp_n_person_id
145: AND program_cd = cp_c_program
146: AND term_cal_type = cp_c_cal_type
147: AND term_sequence_number = cp_n_seq_num;

Line 173: l_c_plan_status igs_en_spa_terms.PLAN_SHT_STATUS%TYPE;

169:
170: i NUMBER;
171: l_n_temp NUMBER;
172: l_d_alias_val DATE;
173: l_c_plan_status igs_en_spa_terms.PLAN_SHT_STATUS%TYPE;
174: l_schedule_available BOOLEAN := FALSE;
175: l_schedule_units_exists BOOLEAN := FALSE;
176: l_plan_exists BOOLEAN := FALSE;
177: