APPS.IGS_GR_VAL_CRDP dependencies on IGS_CA_DA_INST_V

Line 16: IGS_CA_DA_INST_V daiv

12: v_crd_daiv_exists VARCHAR2(1);
13: CURSOR c_crd_daiv IS
14: SELECT 'x'
15: FROM IGS_GR_CRMN_ROUND crd,
16: IGS_CA_DA_INST_V daiv
17: WHERE crd.grd_cal_type = p_grd_cal_type AND
18: crd.grd_ci_sequence_number = p_grd_ci_sequence_number AND
19: crd.end_dt_alias = daiv.dt_alias AND
20: crd.end_dai_sequence_number = daiv.sequence_number AND

Line 27: IGS_CA_DA_INST_V daiv

23: TRUNC(daiv.alias_val) < TRUNC(SYSDATE);
24: CURSOR c_crd_daiv2 IS
25: SELECT 'x'
26: FROM IGS_GR_CRMN_ROUND crd,
27: IGS_CA_DA_INST_V daiv
28: WHERE crd.grd_cal_type = p_grd_cal_type AND
29: crd.grd_ci_sequence_number = p_grd_ci_sequence_number AND
30: crd.start_dt_alias = daiv.dt_alias AND
31: crd.start_dai_sequence_number = daiv.sequence_number AND