APPS.IGS_AD_IMP_015 dependencies on IGS_AD_INTERFACE

Line 179: FROM igs_ad_interface

175: -- Populating the interface table with the interface_run_id value
176: UPDATE igs_uc_qual_ints a
177: SET interface_run_id = p_interface_run_id,
178: person_id = (SELECT person_id
179: FROM igs_ad_interface
180: WHERE interface_id = a.interface_id)
181: WHERE interface_id IN (SELECT interface_id
182: FROM igs_ad_interface
183: WHERE interface_run_id = p_interface_run_id

Line 182: FROM igs_ad_interface

178: person_id = (SELECT person_id
179: FROM igs_ad_interface
180: WHERE interface_id = a.interface_id)
181: WHERE interface_id IN (SELECT interface_id
182: FROM igs_ad_interface
183: WHERE interface_run_id = p_interface_run_id
184: AND status IN ('1','4'));
185:
186: -- Gather statistics of the table

Line 211: FROM igs_ad_interface

207: -- Populating the interface table with the interface_run_id value
208: UPDATE igs_ad_recruit_int a
209: SET interface_run_id = p_interface_run_id,
210: person_id = (SELECT person_id
211: FROM igs_ad_interface
212: WHERE interface_id = a.interface_id)
213: WHERE interface_id IN (SELECT interface_id
214: FROM igs_ad_interface
215: WHERE interface_run_id = p_interface_run_id

Line 214: FROM igs_ad_interface

210: person_id = (SELECT person_id
211: FROM igs_ad_interface
212: WHERE interface_id = a.interface_id)
213: WHERE interface_id IN (SELECT interface_id
214: FROM igs_ad_interface
215: WHERE interface_run_id = p_interface_run_id
216: AND status IN ('1','4'));
217:
218: -- Gather statistics of the table

Line 274: FROM igs_ad_interface

270: -- Populating the interface table with the interface_run_id value
271: UPDATE igs_ad_test_int a
272: SET interface_run_id = p_interface_run_id,
273: person_id = (SELECT person_id
274: FROM igs_ad_interface
275: WHERE interface_id = a.interface_id)
276: WHERE interface_id IN (SELECT interface_id
277: FROM igs_ad_interface
278: WHERE interface_run_id = p_interface_run_id

Line 277: FROM igs_ad_interface

273: person_id = (SELECT person_id
274: FROM igs_ad_interface
275: WHERE interface_id = a.interface_id)
276: WHERE interface_id IN (SELECT interface_id
277: FROM igs_ad_interface
278: WHERE interface_run_id = p_interface_run_id
279: AND status IN ('1','4'));
280:
281: -- If record failed only due to child record failure

Line 413: FROM igs_ad_interface

409: -- Populating the interface table with the interface_run_id value
410: UPDATE igs_ad_apl_int a
411: SET interface_run_id = p_interface_run_id,
412: person_id = (SELECT person_id
413: FROM igs_ad_interface
414: WHERE interface_id = a.interface_id)
415: WHERE interface_id IN (SELECT interface_id
416: FROM igs_ad_interface
417: WHERE interface_run_id = p_interface_run_id

Line 416: FROM igs_ad_interface

412: person_id = (SELECT person_id
413: FROM igs_ad_interface
414: WHERE interface_id = a.interface_id)
415: WHERE interface_id IN (SELECT interface_id
416: FROM igs_ad_interface
417: WHERE interface_run_id = p_interface_run_id
418: AND status IN ('1','4'));
419:
420: -- If record failed only due to child record failure