APPS.IGS_UC_EXPUNGE_APP dependencies on IGS_UC_TRANSACTIONS

Line 281: FROM igs_uc_transactions

277: AND choice_no = NVL(cp_choice_no, choice_no);
278:
279: CURSOR cur_uctr (cp_app_no igs_uc_app_choices.app_no%TYPE, cp_choice_no igs_uc_app_choices.choice_no%TYPE) IS
280: SELECT ROWID
281: FROM igs_uc_transactions
282: WHERE app_no = cp_app_no
283: AND choice_no = cp_choice_no;
284:
285: l_appl_inst_rec cur_oss_ad_appl_inst%ROWTYPE;

Line 536: igs_uc_transactions_pkg.delete_row ( x_rowid => x.ROWID );

532: igs_uc_app_choices_pkg.delete_row ( x_rowid => x.ROWID );
533: END LOOP;
534:
535: FOR x IN cur_uctr (l_wrong_app_rec.app_no, l_expunge_choice_det(l_loc)) LOOP
536: igs_uc_transactions_pkg.delete_row ( x_rowid => x.ROWID );
537: END LOOP;
538:
539: DELETE igs_uc_istarc_ints
540: WHERE appno = l_wrong_app_rec.app_no