APPS.IGS_GR_VAL_GC dependencies on IGS_CA_DA_INST_V

Line 24: FROM IGS_CA_DA_INST_V daiv

20: DECLARE
21: v_gc_dai_found VARCHAR2(1);
22: CURSOR c_ceremony_daiv IS
23: SELECT 'X'
24: FROM IGS_CA_DA_INST_V daiv
25: WHERE daiv.dt_alias = p_ceremony_dt_alias AND
26: daiv.sequence_number = p_ceremony_dai_sequence_number AND
27: daiv.cal_type = p_grd_cal_type AND
28: daiv.ci_sequence_number = p_grd_ci_sequence_number AND

Line 32: FROM IGS_CA_DA_INST_V daiv

28: daiv.ci_sequence_number = p_grd_ci_sequence_number AND
29: TRUNC(daiv.alias_val) < TRUNC(SYSDATE);
30: CURSOR c_closing_daiv IS
31: SELECT 'X'
32: FROM IGS_CA_DA_INST_V daiv
33: WHERE daiv.dt_alias = p_closing_dt_alias AND
34: daiv.sequence_number = p_closing_dai_sequence_number AND
35: daiv.cal_type = p_grd_cal_type AND
36: daiv.ci_sequence_number = p_grd_ci_sequence_number AND

Line 40: FROM IGS_CA_DA_INST_V ceremony_daiv,

36: daiv.ci_sequence_number = p_grd_ci_sequence_number AND
37: TRUNC(daiv.alias_val) < TRUNC(SYSDATE);
38: CURSOR c_daiv IS
39: SELECT 'X'
40: FROM IGS_CA_DA_INST_V ceremony_daiv,
41: IGS_CA_DA_INST_V closing_daiv
42: WHERE ceremony_daiv.dt_alias = p_ceremony_dt_alias AND
43: ceremony_daiv.sequence_number = p_ceremony_dai_sequence_number AND
44: ceremony_daiv.cal_type = p_grd_cal_type AND

Line 41: IGS_CA_DA_INST_V closing_daiv

37: TRUNC(daiv.alias_val) < TRUNC(SYSDATE);
38: CURSOR c_daiv IS
39: SELECT 'X'
40: FROM IGS_CA_DA_INST_V ceremony_daiv,
41: IGS_CA_DA_INST_V closing_daiv
42: WHERE ceremony_daiv.dt_alias = p_ceremony_dt_alias AND
43: ceremony_daiv.sequence_number = p_ceremony_dai_sequence_number AND
44: ceremony_daiv.cal_type = p_grd_cal_type AND
45: ceremony_daiv.ci_sequence_number = p_grd_ci_sequence_number AND

Line 229: IGS_CA_DA_INST_V daiv1,

225: v_gc_daiv_exists VARCHAR2(1);
226: CURSOR c_gc_daiv IS
227: SELECT 'x'
228: FROM IGS_GR_CRMN gc,
229: IGS_CA_DA_INST_V daiv1,
230: IGS_CA_DA_INST_V daiv2
231: WHERE gc.grd_cal_type = p_grd_cal_type AND
232: gc.grd_ci_sequence_number = p_grd_ci_sequence_number AND
233: gc.ceremony_number <> p_ceremony_number AND

Line 230: IGS_CA_DA_INST_V daiv2

226: CURSOR c_gc_daiv IS
227: SELECT 'x'
228: FROM IGS_GR_CRMN gc,
229: IGS_CA_DA_INST_V daiv1,
230: IGS_CA_DA_INST_V daiv2
231: WHERE gc.grd_cal_type = p_grd_cal_type AND
232: gc.grd_ci_sequence_number = p_grd_ci_sequence_number AND
233: gc.ceremony_number <> p_ceremony_number AND
234: gc.venue_cd = p_venue_cd AND

Line 315: IGS_CA_DA_INST_V daiv

311: v_gc_daiv_exists VARCHAR2(1);
312: CURSOR c_gc_daiv IS
313: SELECT 'x'
314: FROM IGS_GR_CRMN gc,
315: IGS_CA_DA_INST_V daiv
316: WHERE gc.grd_cal_type = p_grd_cal_type AND
317: gc.grd_ci_sequence_number = p_grd_ci_sequence_number AND
318: gc.ceremony_number = p_ceremony_number AND
319: gc.ceremony_dt_alias = daiv.dt_alias AND