APPS.IGS_AD_GEN_006 dependencies on IGS_CA_DA_INST_V

Line 11: v_encmb_chk_dt IGS_CA_DA_INST_V.alias_val%TYPE;

7: BEGIN -- admp_get_encmb_dt
8: -- This module gets the encumbrance check date when passed an admission
9: -- calendar type and sequence number.
10: DECLARE
11: v_encmb_chk_dt IGS_CA_DA_INST_V.alias_val%TYPE;
12: CURSOR c_encmb_dt IS
13: SELECT daiv.alias_val
14: FROM IGS_CA_DA_INST_V daiv,
15: IGS_AD_CAL_CONF sacc

Line 14: FROM IGS_CA_DA_INST_V daiv,

10: DECLARE
11: v_encmb_chk_dt IGS_CA_DA_INST_V.alias_val%TYPE;
12: CURSOR c_encmb_dt IS
13: SELECT daiv.alias_val
14: FROM IGS_CA_DA_INST_V daiv,
15: IGS_AD_CAL_CONF sacc
16: WHERE daiv.cal_type = p_adm_cal_type AND
17: daiv.ci_sequence_number = p_adm_ci_sequence_number AND
18: daiv.dt_alias = sacc.adm_appl_encmb_chk_dt_alias