APPS.IGS_AD_UPD_INITIALISE dependencies on IGS_AD_PS_APPL_INST_ALL

Line 548: igs_ad_ps_appl_inst_all inst,

544: SELECT apl.adm_cal_type,
545: apl.adm_ci_sequence_number ,
546: ca.start_dt
547: FROM igs_ad_appl_all apl ,
548: igs_ad_ps_appl_inst_all inst,
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