APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_IVSTARPQR_2003_V

Line 8923: CURSOR c_ivstarpqr (cp_appno igs_uc_ivstarpqr_2003_v.appno%TYPE ) IS

8919: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
8920:
8921: -- Get all the records from hercules view whose timestamp is > passed timestamp
8922: -- or get all the records in hercules view if the timestamp passed is null
8923: CURSOR c_ivstarpqr (cp_appno igs_uc_ivstarpqr_2003_v.appno%TYPE ) IS
8924: SELECT appno
8925: ,timestamp
8926: ,subjectid
8927: ,RTRIM(eblresult) eblresult

Line 8930: FROM igs_uc_ivstarpqr_2003_v

8926: ,subjectid
8927: ,RTRIM(eblresult) eblresult
8928: ,RTRIM(eblamended) eblamended
8929: ,RTRIM(claimedresult) claimedresult
8930: FROM igs_uc_ivstarpqr_2003_v
8931: WHERE appno = cp_appno ;
8932:
8933: -- Variables
8934: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;

Line 9075: CURSOR c_ivstarpqr (cp_appno igs_uc_ivstarpqr_2003_v.appno%TYPE ) IS

9071: WHERE ( timestamp > p_timestamp OR p_timestamp IS NULL ) ;
9072:
9073: -- Get all the records from hercules view whose timestamp is > passed timestamp
9074: -- or get all the records in hercules view if the timestamp passed is null
9075: CURSOR c_ivstarpqr (cp_appno igs_uc_ivstarpqr_2003_v.appno%TYPE ) IS
9076: SELECT appno
9077: ,timestamp
9078: ,subjectid
9079: ,RTRIM(eblresult) eblresult

Line 9080: FROM igs_uc_ivstarpqr_2003_v

9076: SELECT appno
9077: ,timestamp
9078: ,subjectid
9079: ,RTRIM(eblresult) eblresult
9080: FROM igs_uc_ivstarpqr_2003_v
9081: WHERE appno = cp_appno ;
9082:
9083: -- Variables
9084: p_old_timestamp igs_uc_hrc_timstmps.timestamp%TYPE ;