DBA Data[Home] [Help]

APPS.IEX_CO_TRANSFER_EA_PVT dependencies on IEX_CASE_OBJECTS

Line 48: , iex_case_objects ico

44: CURSOR l_case_csr(cp_cas_id IN NUMBER) IS SELECT ic.status_code
45: , ic.case_number
46: , ico.object_id
47: FROM iex_cases_all_b ic
48: , iex_case_objects ico
49: WHERE ic.cas_id = cp_cas_id
50: AND ic.cas_id = ico.cas_id
51: AND rownum = 1;
52: BEGIN