DBA Data[Home] [Help]

APPS.IGS_AD_OFFRESP_STATUS_WF dependencies on IGS_AD_PRD_AD_PRC_CA

Line 192: FROM igs_ad_prd_ad_prc_ca admprd,

188: p_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE,
189: p_admission_cat igs_ad_appl_all.admission_cat%TYPE,
190: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE) IS
191: SELECT admprd.single_response_flag
192: FROM igs_ad_prd_ad_prc_ca admprd,
193: igs_ad_appl_all appl,
194: igs_ad_ps_appl_inst_all aplinst
195: WHERE appl.person_id = p_person_id
196: AND appl.admission_appl_number = p_admission_appl_number