930: IOH.EXT_AGNCY_ID
931: FROM iex_delinquencies_all ida
932: ,iex_case_objects ico
933: ,Okl_Open_Int OIN
934: ,Iex_Open_Int_Hst IOH
935: WHERE ida.delinquency_id = cp_delinquency_id
936: AND ida.case_id = ico.cas_id
937: AND ico.object_id = oin.khr_id
938: AND OIN.khr_id = TO_NUMBER(IOH.object1_id1)
1034: IOH.EXT_AGNCY_ID
1035: FROM iex_delinquencies_all ida
1036: ,iex_case_objects ico
1037: ,Okl_Open_Int OIN
1038: ,Iex_Open_Int_Hst IOH
1039: WHERE ida.delinquency_id = cp_delinquency_id
1040: AND ida.case_id = ico.cas_id
1041: AND ico.object_id = oin.khr_id
1042: AND OIN.khr_id = TO_NUMBER(IOH.object1_id1)