DBA Data[Home] [Help]

APPS.IGS_CA_INST_REL_PKG dependencies on IGS_CA_STAT

Line 196: igs_ca_stat f,

192: igs_ca_type b ,
193: igs_ca_type c ,
194: igs_ca_inst d ,
195: igs_ca_inst e ,
196: igs_ca_stat f,
197: igs_ca_stat g
198: WHERE a.rowid = p_rowid
199: AND a.sub_cal_type = b.cal_type
200: AND b.s_cal_cat = 'ADMISSION'

Line 197: igs_ca_stat g

193: igs_ca_type c ,
194: igs_ca_inst d ,
195: igs_ca_inst e ,
196: igs_ca_stat f,
197: igs_ca_stat g
198: WHERE a.rowid = p_rowid
199: AND a.sub_cal_type = b.cal_type
200: AND b.s_cal_cat = 'ADMISSION'
201: AND a.sup_cal_type = c.cal_type