APPS.IGS_AS_VAL_VEA dependencies on IGS_CO_ADDR_TYPE

Line 32: FROM IGS_CO_ADDR_TYPE

28: DECLARE
29: v_adt_rec VARCHAR2(1);
30: CURSOR c_adt IS
31: SELECT 'X'
32: FROM IGS_CO_ADDR_TYPE
33: WHERE addr_type = p_addr_type;
34: CURSOR c_vea IS
35: SELECT vea.start_dt,
36: vea.end_dt

Line 55: --The IGS_CO_ADDR_TYPE passed in as a parameter has the correspondence_ind set.

51: CLOSE c_adt;
52: RETURN return_val;
53: END IF;
54: CLOSE c_adt;
55: --The IGS_CO_ADDR_TYPE passed in as a parameter has the correspondence_ind set.
56: --Now loop through the IGS_GR_VENUE_ADDR records for the IGS_GR_VENUE to determine if they
57: --have any other active records with an IGS_CO_ADDR_TYPE
58: --(apart from the IGS_CO_ADDR_TYPE passed in as a parameter)
59: --which also has the correspondence_ind set. If so, set the error message.

Line 57: --have any other active records with an IGS_CO_ADDR_TYPE

53: END IF;
54: CLOSE c_adt;
55: --The IGS_CO_ADDR_TYPE passed in as a parameter has the correspondence_ind set.
56: --Now loop through the IGS_GR_VENUE_ADDR records for the IGS_GR_VENUE to determine if they
57: --have any other active records with an IGS_CO_ADDR_TYPE
58: --(apart from the IGS_CO_ADDR_TYPE passed in as a parameter)
59: --which also has the correspondence_ind set. If so, set the error message.
60: FOR v_vea_rec IN c_vea LOOP
61: IF (v_vea_rec.end_dt >= SYSDATE OR

Line 58: --(apart from the IGS_CO_ADDR_TYPE passed in as a parameter)

54: CLOSE c_adt;
55: --The IGS_CO_ADDR_TYPE passed in as a parameter has the correspondence_ind set.
56: --Now loop through the IGS_GR_VENUE_ADDR records for the IGS_GR_VENUE to determine if they
57: --have any other active records with an IGS_CO_ADDR_TYPE
58: --(apart from the IGS_CO_ADDR_TYPE passed in as a parameter)
59: --which also has the correspondence_ind set. If so, set the error message.
60: FOR v_vea_rec IN c_vea LOOP
61: IF (v_vea_rec.end_dt >= SYSDATE OR
62: v_vea_rec.end_dt IS NULL) THEN