APPS.IGS_AS_ADI_UPLD_AIO_PKG dependencies on IGS_AS_UG_INTERFACE

Line 494: IS SELECT ugi.error_code from IGS_AS_UG_INTERFACE UGI

490: p_batch_date DATE := to_date(p_batch_datetime, 'YYYY/MM/DD HH24:MI:SS');
491: -- Cursors to copy back the error code for UG_INTERFACE to AIO INTERFACD
492: CURSOR cur_ug_err (cp_user_id number, cp_batch_date DATE, cp_person_number VARCHAR2,
493: CP_ANONYMOUS_ID VARCHAR2, cp_uoo_id NUMBER)
494: IS SELECT ugi.error_code from IGS_AS_UG_INTERFACE UGI
495: WHERE ( (PERSON_number = cp_person_number OR ANONYMOUS_ID = CP_ANONYMOUS_ID)
496: AND user_id = cp_user_id and trunc(batch_date) = trunc(cp_batch_date)
497: AND uoo_id = cp_uoo_id and ERROR_CODE IS NOT NULL
498: );