APPS.IGS_HE_IDENTIFY_TARGET_POP dependencies on IGS_HE_AD_DTL

Line 832: -- get the domicile code and special student code from igs_he_ad_dtl

828: AND us_version_number = cp_us_version_number;
829:
830: l_he_poous cur_he_poous%ROWTYPE;
831:
832: -- get the domicile code and special student code from igs_he_ad_dtl
833: CURSOR c_he_ad_dtl (cp_person_id igs_he_ad_dtl.person_id%TYPE,
834: cp_admission_appl_number igs_he_ad_dtl.admission_appl_number%TYPE,
835: cp_nominated_course_cd igs_he_ad_dtl.nominated_course_cd%TYPE ,
836: cp_sequence_number igs_he_ad_dtl.sequence_number%TYPE) IS

Line 833: CURSOR c_he_ad_dtl (cp_person_id igs_he_ad_dtl.person_id%TYPE,

829:
830: l_he_poous cur_he_poous%ROWTYPE;
831:
832: -- get the domicile code and special student code from igs_he_ad_dtl
833: CURSOR c_he_ad_dtl (cp_person_id igs_he_ad_dtl.person_id%TYPE,
834: cp_admission_appl_number igs_he_ad_dtl.admission_appl_number%TYPE,
835: cp_nominated_course_cd igs_he_ad_dtl.nominated_course_cd%TYPE ,
836: cp_sequence_number igs_he_ad_dtl.sequence_number%TYPE) IS
837: SELECT domicile_cd,

Line 834: cp_admission_appl_number igs_he_ad_dtl.admission_appl_number%TYPE,

830: l_he_poous cur_he_poous%ROWTYPE;
831:
832: -- get the domicile code and special student code from igs_he_ad_dtl
833: CURSOR c_he_ad_dtl (cp_person_id igs_he_ad_dtl.person_id%TYPE,
834: cp_admission_appl_number igs_he_ad_dtl.admission_appl_number%TYPE,
835: cp_nominated_course_cd igs_he_ad_dtl.nominated_course_cd%TYPE ,
836: cp_sequence_number igs_he_ad_dtl.sequence_number%TYPE) IS
837: SELECT domicile_cd,
838: special_student_cd

Line 835: cp_nominated_course_cd igs_he_ad_dtl.nominated_course_cd%TYPE ,

831:
832: -- get the domicile code and special student code from igs_he_ad_dtl
833: CURSOR c_he_ad_dtl (cp_person_id igs_he_ad_dtl.person_id%TYPE,
834: cp_admission_appl_number igs_he_ad_dtl.admission_appl_number%TYPE,
835: cp_nominated_course_cd igs_he_ad_dtl.nominated_course_cd%TYPE ,
836: cp_sequence_number igs_he_ad_dtl.sequence_number%TYPE) IS
837: SELECT domicile_cd,
838: special_student_cd
839: FROM igs_he_ad_dtl

Line 836: cp_sequence_number igs_he_ad_dtl.sequence_number%TYPE) IS

832: -- get the domicile code and special student code from igs_he_ad_dtl
833: CURSOR c_he_ad_dtl (cp_person_id igs_he_ad_dtl.person_id%TYPE,
834: cp_admission_appl_number igs_he_ad_dtl.admission_appl_number%TYPE,
835: cp_nominated_course_cd igs_he_ad_dtl.nominated_course_cd%TYPE ,
836: cp_sequence_number igs_he_ad_dtl.sequence_number%TYPE) IS
837: SELECT domicile_cd,
838: special_student_cd
839: FROM igs_he_ad_dtl
840: WHERE person_id = cp_person_id

Line 839: FROM igs_he_ad_dtl

835: cp_nominated_course_cd igs_he_ad_dtl.nominated_course_cd%TYPE ,
836: cp_sequence_number igs_he_ad_dtl.sequence_number%TYPE) IS
837: SELECT domicile_cd,
838: special_student_cd
839: FROM igs_he_ad_dtl
840: WHERE person_id = cp_person_id
841: AND admission_appl_number = cp_admission_appl_number
842: AND nominated_course_cd = cp_nominated_course_cd
843: AND sequence_number = cp_sequence_number;