APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_U_CVREFAMENDMENTS_2007

Line 44: FROM igs_uc_u_cvrefamendments_2007 ;

40: SELECT aprdate, disdate, errordate, ethnicdate, examdate, feedate,
41: keyworddate, oeqdate, offerabbrevdate, offersubjdate, poccdate,
42: rescatdate, awardbodydate, statusdate, ucasgroupdate, estabgroup,
43: schooltype, tariffdate, jointadmissions, country, nationality
44: FROM igs_uc_u_cvrefamendments_2007 ;
45: g_refamend_timestamp c_refamend_timestamp_2007%ROWTYPE ;
46:
47: -- Added GTTR timestamp value of the hercules views from cvgrefamendments
48: -- for bug 4638126

Line 4275: l_new_max_timestamp igs_uc_u_cvrefamendments_2007.country%TYPE ;

4271: FROM igs_uc_u_cvrefcountry_2007 ;
4272:
4273: -- Variables
4274: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
4275: l_new_max_timestamp igs_uc_u_cvrefamendments_2007.country%TYPE ;
4276: l_count NUMBER ;
4277:
4278: BEGIN
4279: -- set syncronization required to false

Line 4362: l_new_max_timestamp igs_uc_u_cvrefamendments_2007.nationality%TYPE ;

4358: FROM igs_uc_u_cvrefnationality_2007 ;
4359:
4360: -- Variables
4361: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;
4362: l_new_max_timestamp igs_uc_u_cvrefamendments_2007.nationality%TYPE ;
4363: l_count NUMBER ;
4364:
4365: BEGIN
4366: -- set syncronization required to false