DBA Data[Home] [Help]

APPS.IEX_CO_TRANSFER_EA_PVT dependencies on IEX_EXT_AGNCY_B

Line 132: IEX_EXT_AGNCY_B c

128: SELECT c.external_agency_name
129: INTO l_ext_agncy_name
130: FROM OKL_OPEN_INT a,
131: IEX_OPEN_INT_HST b,
132: IEX_EXT_AGNCY_B c
133: WHERE a.cas_id = p_cas_id
134: AND a.khr_id = to_number(b.object1_id1)
135: AND b.action = 'TRANSFER_EXT_AGNCY'
136: AND (b.status = 'PROCESSED' OR b.status = 'NOTIFIED')