DBA Data[Home] [Help]

APPS.IGS_PE_CONFIG_PVT dependencies on IGS_CA_STAT

Line 68: IGS_CA_STAT ca

64: CURSOR cur_term_date IS
65: SELECT MAX(ci.start_dt)
66: FROM IGS_CA_INST_ALL ci,
67: IGS_CA_TYPE ct,
68: IGS_CA_STAT ca
69: WHERE ci.cal_type = ct.cal_type
70: AND ct.s_cal_cat = 'LOAD'
71: AND SYSDATE BETWEEN ci.start_dt AND ci.end_dt
72: AND ci.cal_status = ca.cal_status