DBA Data[Home] [Help]

APPS.IGS_OR_VAL_IA dependencies on IGS_CO_ADDR_TYPE

Line 31: FROM IGS_CO_ADDR_TYPE adt

27: DECLARE
28: v_ia_count NUMBER(5);
29: CURSOR c_ia_count IS
30: SELECT count(*)
31: FROM IGS_CO_ADDR_TYPE adt
32: WHERE adt.addr_type = p_addr_type;
33: CURSOR c_ia IS
34: SELECT ia.addr_type,
35: ia.start_dt,