APPS.IGS_OR_VAL_IA dependencies on IGS_OR_INST_ADDR

Line 37: FROM IGS_OR_INST_ADDR ia

33: CURSOR c_ia IS
34: SELECT ia.addr_type,
35: ia.start_dt,
36: ia.end_dt
37: FROM IGS_OR_INST_ADDR ia
38: WHERE ia.institution_cd = p_institution_cd AND
39: ia.addr_type <> p_addr_type AND
40: ia.status = 'A' AND
41: ia.correspondence_ind = 'Y';

Line 142: FROM IGS_OR_INST_ADDR ia

138: DECLARE
139: v_count NUMBER(5);
140: CURSOR c_ia IS
141: SELECT count(*)
142: FROM IGS_OR_INST_ADDR ia
143: WHERE ia.institution_cd = p_institution_cd AND
144: ia.addr_type = p_addr_type AND
145: ia.status = 'A' AND
146: ia.start_dt <> p_start_dt AND

Line 183: cp_institution_cd IGS_OR_INST_ADDR.institution_cd%TYPE,

179: gv_other_detail VARCHAR2(255);
180: BEGIN
181: DECLARE
182: CURSOR c_ia (
183: cp_institution_cd IGS_OR_INST_ADDR.institution_cd%TYPE,
184: cp_addr_type IGS_OR_INST_ADDR.addr_type%TYPE) IS
185: SELECT ia.start_dt,
186: ia.end_dt
187: FROM IGS_OR_INST_ADDR ia

Line 184: cp_addr_type IGS_OR_INST_ADDR.addr_type%TYPE) IS

180: BEGIN
181: DECLARE
182: CURSOR c_ia (
183: cp_institution_cd IGS_OR_INST_ADDR.institution_cd%TYPE,
184: cp_addr_type IGS_OR_INST_ADDR.addr_type%TYPE) IS
185: SELECT ia.start_dt,
186: ia.end_dt
187: FROM IGS_OR_INST_ADDR ia
188: WHERE ia.institution_cd = cp_institution_cd AND

Line 187: FROM IGS_OR_INST_ADDR ia

183: cp_institution_cd IGS_OR_INST_ADDR.institution_cd%TYPE,
184: cp_addr_type IGS_OR_INST_ADDR.addr_type%TYPE) IS
185: SELECT ia.start_dt,
186: ia.end_dt
187: FROM IGS_OR_INST_ADDR ia
188: WHERE ia.institution_cd = cp_institution_cd AND
189: ia.addr_type = cp_addr_type AND
190: ia.status = 'A' AND
191: ia.start_dt <> p_start_dt;

Line 192: v_end_dt IGS_OR_INST_ADDR.end_dt%TYPE;

188: WHERE ia.institution_cd = cp_institution_cd AND
189: ia.addr_type = cp_addr_type AND
190: ia.status = 'A' AND
191: ia.start_dt <> p_start_dt;
192: v_end_dt IGS_OR_INST_ADDR.end_dt%TYPE;
193: BEGIN
194: -- This module checks that the institution_addr record,
195: -- which is being created or updated, does not overlap
196: -- with an existing record of the same type for the institution.