DBA Data[Home] [Help]

APPS.IGS_AD_VAL_ACAI dependencies on IGS_AD_PANEL_DTLS

Line 3629: FROM igs_ad_panel_dtls

3625: nominated_course_cd = p_nominated_course_cd;
3626:
3627: CURSOR c_id_exist IS
3628: SELECT person_id
3629: FROM igs_ad_panel_dtls
3630: WHERE person_id = p_person_id AND
3631: admission_appl_number = p_admission_appl_number AND
3632: nominated_course_cd = p_nominated_course_cd AND
3633: sequence_number = p_acai_sequence_number AND

Line 3637: FROM igs_ad_panel_dtls

3633: sequence_number = p_acai_sequence_number AND
3634: final_decision_type = 'FINAL_INTERVIEW';
3635: CURSOR c_id IS
3636: SELECT person_id
3637: FROM igs_ad_panel_dtls
3638: WHERE person_id = p_person_id AND
3639: admission_appl_number = p_admission_appl_number AND
3640: nominated_course_cd = p_nominated_course_cd AND
3641: sequence_number = p_acai_sequence_number AND