APPS.IGS_AD_UPD_INITIALISE dependencies on IGS_AD_GEN_008

Line 553: AND igs_ad_gen_008.admp_get_saors(inst.adm_offer_resp_status) = 'ACCEPTED'

549: igs_ca_inst_all ca
550: WHERE apl.person_id = P_PERSON_ID
551: AND apl.person_id = inst.person_id
552: AND apl.admission_appl_number = inst.admission_appl_number
553: AND igs_ad_gen_008.admp_get_saors(inst.adm_offer_resp_status) = 'ACCEPTED'
554: AND ca.cal_type =apl.adm_cal_type
555: AND ca.sequence_number = apl.adm_ci_sequence_number
556: ORDER BY ca.start_dt asc,inst.actual_response_dt asc;
557: