APPS.IGS_UC_EXPUNGE_APP dependencies on IGS_UC_APPLICANTS

Line 19: FROM igs_uc_applicants

15: ***************************************************************/
16:
17: CURSOR cur_ucap IS
18: SELECT ROWID
19: FROM igs_uc_applicants
20: WHERE app_no = p_app_no;
21:
22: CURSOR cur_ucapcl IS
23: SELECT ROWID

Line 98: igs_uc_applicants_pkg.delete_row ( x_rowid => x.ROWID );

94: igs_uc_form_quals_pkg.delete_row ( x_rowid => x.ROWID );
95: END LOOP;
96:
97: FOR x IN cur_ucap LOOP
98: igs_uc_applicants_pkg.delete_row ( x_rowid => x.ROWID );
99: END LOOP;
100:
101: DELETE igs_uc_ifrmqul_ints WHERE appno = p_app_no;
102:

Line 174: igs_uc_applicants ucap

170: --To check whether the setup record is available FOR each System, which has an application to be expunged.
171: CURSOR cur_system_setup IS
172: SELECT 'X'
173: FROM igs_uc_defaults def,
174: igs_uc_applicants ucap
175: WHERE def.system_code (+) = ucap.system_code
176: AND def.system_code IS NULL
177: AND ucap.app_no IN ( SELECT app_no
178: FROM igs_uc_wrong_app wap

Line 188: FROM igs_uc_applicants ucap,

184: CURSOR cur_system_val_setup IS
185: SELECT 'X'
186: FROM igs_uc_defaults def
187: WHERE system_code IN ( SELECT DISTINCT system_code
188: FROM igs_uc_applicants ucap,
189: igs_uc_wrong_app wap
190: WHERE ucap.app_no = wap.app_no
191: AND wap.expunge = 'Y'
192: AND wap.expunged <> 'Y'

Line 210: igs_uc_applicants ucap

206: SELECT obsolete_outcome_status,
207: decision_make_id,
208: decision_reason_id
209: FROM igs_uc_defaults def,
210: igs_uc_applicants ucap
211: WHERE def.system_code = ucap.system_code
212: AND ucap.app_no = cp_app_no;
213:
214: --To identify the OSS Admission Application instances, which are created FOR UCAS Application number to be expunged

Line 260: igs_uc_applicants ucap

256: --To get the Person alternate ID record to End Date
257: CURSOR cur_alt_pers_id (cp_app_no igs_uc_wrong_app.app_no%TYPE) IS
258: SELECT api.ROWID row_id, api.*
259: FROM igs_pe_alt_pers_id api,
260: igs_uc_applicants ucap
261: WHERE api.pe_person_id = ucap.oss_person_id
262: AND api.api_person_id = TO_CHAR(ucap.app_no)
263: AND ucap.app_no = cp_app_no
264: AND api.person_id_type= DECODE(ucap.system_code, 'U', 'UCASID', 'G', 'GTTRID', 'S', 'SWASID', 'N', 'NMASID')