APPS.IGS_HE_EXTRACT2_PKG dependencies on IGS_HE_AD_DTL

Line 23: g_he_ad_dtl igs_he_ad_dtl%ROWTYPE;

19: g_ps_ofr_opt igs_ps_ofr_opt%ROWTYPE;
20: g_he_poous igs_he_poous%ROWTYPE;
21: g_pe_person igs_pe_person%ROWTYPE;
22: g_pe_stat_v igs_pe_stat_v%ROWTYPE;
23: g_he_ad_dtl igs_he_ad_dtl%ROWTYPE;
24: g_he_st_unt_vs igs_he_st_unt_vs%ROWTYPE;
25: g_ps_unit_ver_v igs_ps_unit_ver_v%ROWTYPE;
26: g_default_pro VARCHAR2(1);
27: g_he_stdnt_dlhe igs_he_stdnt_dlhe%ROWTYPE ;

Line 9773: CURSOR c_adm (p_admission_appl_number igs_he_ad_dtl.admission_appl_number%TYPE,

9769: AND pop.attendance_mode = p_attendance_mode
9770: AND pop.attendance_type = p_attendance_type
9771: AND pop.location_cd = p_location_cd ;
9772:
9773: CURSOR c_adm (p_admission_appl_number igs_he_ad_dtl.admission_appl_number%TYPE,
9774: p_nominated_course_cd igs_he_ad_dtl.nominated_course_cd%TYPE ,
9775: p_sequence_number igs_he_ad_dtl.sequence_number%TYPE) IS
9776: SELECT had.occupation_cd,
9777: had.domicile_cd,

Line 9774: p_nominated_course_cd igs_he_ad_dtl.nominated_course_cd%TYPE ,

9770: AND pop.attendance_type = p_attendance_type
9771: AND pop.location_cd = p_location_cd ;
9772:
9773: CURSOR c_adm (p_admission_appl_number igs_he_ad_dtl.admission_appl_number%TYPE,
9774: p_nominated_course_cd igs_he_ad_dtl.nominated_course_cd%TYPE ,
9775: p_sequence_number igs_he_ad_dtl.sequence_number%TYPE) IS
9776: SELECT had.occupation_cd,
9777: had.domicile_cd,
9778: had.social_class_cd ,

Line 9775: p_sequence_number igs_he_ad_dtl.sequence_number%TYPE) IS

9771: AND pop.location_cd = p_location_cd ;
9772:
9773: CURSOR c_adm (p_admission_appl_number igs_he_ad_dtl.admission_appl_number%TYPE,
9774: p_nominated_course_cd igs_he_ad_dtl.nominated_course_cd%TYPE ,
9775: p_sequence_number igs_he_ad_dtl.sequence_number%TYPE) IS
9776: SELECT had.occupation_cd,
9777: had.domicile_cd,
9778: had.social_class_cd ,
9779: had.special_student_cd

Line 9780: FROM igs_he_ad_dtl had

9776: SELECT had.occupation_cd,
9777: had.domicile_cd,
9778: had.social_class_cd ,
9779: had.special_student_cd
9780: FROM igs_he_ad_dtl had
9781: WHERE had.person_id = p_person_id
9782: AND had.admission_appl_number = p_admission_appl_number
9783: AND had.nominated_course_cd = p_nominated_course_cd
9784: AND had.sequence_number = p_sequence_number;