DBA Data[Home] [Help]

APPS.IGS_RE_VAL_THE dependencies on IGS_RE_CANDIDATURE_ALL

Line 631: || igs_re_candidature_all for the corresponding person_id and course_cd combination

627: /*
628: || Created By : nbehera
629: || Created On : 14-NOV-2002
630: || Purpose : The function will check for a mapping ca_sequence_number in the table
631: || igs_re_candidature_all for the corresponding person_id and course_cd combination
632: || Known limitations, enhancements or remarks :
633: || Change History :
634: || Who When What
635: || (reverse chronological order - newest change first)

Line 640: FROM igs_re_candidature_all

636: */
637:
638: CURSOR c_ca_seq_number IS
639: SELECT sequence_number
640: FROM igs_re_candidature_all
641: WHERE sca_course_cd IS NOT NULL
642: AND sca_course_cd = p_course_cd
643: AND person_id = p_person_id;
644: