APPS.IGS_CA_VAL_DAIP dependencies on IGS_CA_DA_INST_V

Line 19: v_original_date IGS_CA_DA_INST_V.alias_val%TYPE;

15: gv_other_detail VARCHAR2(255);
16: BEGIN -- calp_val_daip_value
17: -- This module validate IGS_AD_PS_APLINSTUNT unit version.
18: DECLARE
19: v_original_date IGS_CA_DA_INST_V.alias_val%TYPE;
20: v_related_date IGS_CA_DA_INST_V.alias_val%TYPE;
21: CURSOR c_daiv_org IS
22: SELECT alias_val
23: FROM IGS_CA_DA_INST_V daiv

Line 20: v_related_date IGS_CA_DA_INST_V.alias_val%TYPE;

16: BEGIN -- calp_val_daip_value
17: -- This module validate IGS_AD_PS_APLINSTUNT unit version.
18: DECLARE
19: v_original_date IGS_CA_DA_INST_V.alias_val%TYPE;
20: v_related_date IGS_CA_DA_INST_V.alias_val%TYPE;
21: CURSOR c_daiv_org IS
22: SELECT alias_val
23: FROM IGS_CA_DA_INST_V daiv
24: WHERE daiv.dt_alias = p_dt_alias AND

Line 23: FROM IGS_CA_DA_INST_V daiv

19: v_original_date IGS_CA_DA_INST_V.alias_val%TYPE;
20: v_related_date IGS_CA_DA_INST_V.alias_val%TYPE;
21: CURSOR c_daiv_org IS
22: SELECT alias_val
23: FROM IGS_CA_DA_INST_V daiv
24: WHERE daiv.dt_alias = p_dt_alias AND
25: daiv.sequence_number = p_dai_sequence_number AND
26: daiv.cal_type = p_cal_type AND
27: daiv.ci_sequence_number = p_ci_sequence_number;

Line 30: FROM IGS_CA_DA_INST_V daiv

26: daiv.cal_type = p_cal_type AND
27: daiv.ci_sequence_number = p_ci_sequence_number;
28: CURSOR c_daiv_new IS
29: SELECT alias_val
30: FROM IGS_CA_DA_INST_V daiv
31: WHERE daiv.dt_alias = p_related_dt_alias AND
32: daiv.sequence_number = p_related_dai_sequence_number AND
33: daiv.cal_type = p_related_cal_type AND
34: daiv.ci_sequence_number = p_related_ci_sequence_number;