APPS.IGS_UC_EXPUNGE_APP dependencies on IGS_UC_APP_CLEARING

Line 24: FROM igs_uc_app_clearing

20: WHERE app_no = p_app_no;
21:
22: CURSOR cur_ucapcl IS
23: SELECT ROWID
24: FROM igs_uc_app_clearing
25: WHERE app_no = p_app_no;
26:
27: CURSOR cur_ucapcr IS
28: SELECT ROWID

Line 78: igs_uc_app_clearing_pkg.delete_row ( x_rowid => x.ROWID );

74: igs_uc_app_clr_rnd_pkg.delete_row ( x_rowid => x.ROWID );
75: END LOOP;
76:
77: FOR x IN cur_ucapcl LOOP
78: igs_uc_app_clearing_pkg.delete_row ( x_rowid => x.ROWID );
79: END LOOP;
80:
81: FOR x IN cur_ucaddr LOOP
82: igs_uc_app_addreses_pkg.delete_row ( x_rowid => x.ROWID );