APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVSTATEMENT_2003_V

Line 10056: FROM igs_uc_ivstatement_2003_v a

10052: ***************************************************************** */
10053: -- Get all the applicants whose personal statement is null
10054: CURSOR c_stmt_appno IS
10055: SELECT a.appno
10056: FROM igs_uc_ivstatement_2003_v a
10057: WHERE NOT EXISTS ( SELECT b.app_no
10058: FROM IGS_UC_APPLICANTS b
10059: WHERE b.app_no = a.appno
10060: AND b.personal_statement IS NOT NULL );

Line 10063: CURSOR c_stmt (p_appno igs_uc_ivstatement_2003_v.appno%TYPE ) IS

10059: WHERE b.app_no = a.appno
10060: AND b.personal_statement IS NOT NULL );
10061:
10062: -- Get statement for passed appno
10063: CURSOR c_stmt (p_appno igs_uc_ivstatement_2003_v.appno%TYPE ) IS
10064: SELECT appno,statement
10065: FROM igs_uc_ivstatement_2003_v
10066: WHERE appno = p_appno ;
10067: c_stmt_rec c_stmt%ROWTYPE ;

Line 10065: FROM igs_uc_ivstatement_2003_v

10061:
10062: -- Get statement for passed appno
10063: CURSOR c_stmt (p_appno igs_uc_ivstatement_2003_v.appno%TYPE ) IS
10064: SELECT appno,statement
10065: FROM igs_uc_ivstatement_2003_v
10066: WHERE appno = p_appno ;
10067: c_stmt_rec c_stmt%ROWTYPE ;
10068: l_count NUMBER ;
10069: