APPS.IGS_UC_EXPUNGE_APP dependencies on IGS_UC_APP_CHO_CNDS

Line 269: FROM igs_uc_app_cho_cnds

265: AND (api.end_dt IS NULL OR (api.end_dt > SYSDATE AND api.end_dt <> api.start_dt));
266:
267: CURSOR cur_ucapcc (cp_app_no igs_uc_app_choices.app_no%TYPE, cp_choice_no igs_uc_app_choices.choice_no%TYPE) IS
268: SELECT ROWID
269: FROM igs_uc_app_cho_cnds
270: WHERE app_no = cp_app_no
271: AND choice_no = cp_choice_no;
272:
273: CURSOR cur_ucapch (cp_app_no igs_uc_app_choices.app_no%TYPE, cp_choice_no igs_uc_app_choices.choice_no%TYPE) IS

Line 528: igs_uc_app_cho_cnds_pkg.delete_row ( x_rowid => x.ROWID );

524: -- the Application Choice data from the UCAS Interface tables.
525: IF l_oss_app_inst_suspended = 'Y' THEN
526: --Delete Wrong Applicant records from UCAS Interface tables by calling the corresponding TBH.
527: FOR x IN cur_ucapcc (l_wrong_app_rec.app_no, l_expunge_choice_det(l_loc)) LOOP
528: igs_uc_app_cho_cnds_pkg.delete_row ( x_rowid => x.ROWID );
529: END LOOP;
530:
531: FOR x IN cur_ucapch (l_wrong_app_rec.app_no, l_expunge_choice_det(l_loc)) LOOP
532: igs_uc_app_choices_pkg.delete_row ( x_rowid => x.ROWID );