APPS.IGS_EN_GEN_012 dependencies on IGS_CA_DA_INST_V

Line 1616: v_next_lapse_dt IGS_CA_DA_INST_V.alias_val%TYPE ;

1612: e_record_locked EXCEPTION;
1613: PRAGMA EXCEPTION_INIT(e_record_locked, -54);
1614: v_lapse_dt_alias IGS_EN_CAL_CONF.lapse_dt_alias%TYPE ;
1615: v_log_creation_dt IGS_GE_S_LOG.creation_dt%TYPE ;
1616: v_next_lapse_dt IGS_CA_DA_INST_V.alias_val%TYPE ;
1617: v_next_lapse_dt_found BOOLEAN := FALSE;
1618: v_enr_form_due_dt DATE ;
1619: v_lapsed BOOLEAN := FALSE;
1620: v_dummy VARCHAR2(1);

Line 1636: FROM IGS_CA_DA_INST_V daiv

1632: ci.sequence_number = p_acad_sequence_number;
1633: v_ci_rec c_ci%ROWTYPE;
1634: CURSOR c_daiv (p_cal_type VARCHAR2, p_seq_num NUMBER)IS
1635: SELECT daiv.absolute_val alias_val
1636: FROM IGS_CA_DA_INST_V daiv
1637: WHERE daiv.cal_type = p_cal_type AND
1638: daiv.ci_sequence_number = p_seq_num AND
1639: daiv.dt_alias = v_lapse_dt_alias
1640: ORDER BY daiv.absolute_val; -- first row found is the earliest date