DBA Data[Home] [Help]

APPS.IGS_SESSION_VALIDITY dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 122: igs_en_su_attempt_all

118: CURSOR all_sessions_cur IS
119: SELECT
120: DISTINCT session_id
121: FROM
122: igs_en_su_attempt_all
123: WHERE
124: cart = 'S';
125:
126: /**

Line 135: igs_en_su_attempt_all

131: CURSOR unit_attempt_del_cur (c_session_id NUMBER) IS
132: SELECT
133: rowid row_id, person_id
134: FROM
135: igs_en_su_attempt_all
136: WHERE
137: session_id = c_session_id AND
138: cart = 'S'
139: ORDER BY sup_unit_cd ASC;

Line 152: igs_en_su_attempt_all

148: CURSOR std_unit_attempt_del_cur (c_session_id NUMBER) IS
149: SELECT
150: rowid row_id, person_id
151: FROM
152: igs_en_su_attempt_all
153: WHERE
154: session_id = c_session_id AND
155: cart = 'S' AND
156: ss_source_ind <> 'A'

Line 167: igs_en_su_attempt_all

163: CURSOR all_stud_sessions_cur IS
164: SELECT
165: DISTINCT session_id
166: FROM
167: igs_en_su_attempt_all
168: WHERE cart = 'S'
169: AND ss_source_ind <> 'A';
170:
171: /**