468: If p_source_module = 'IEXDLAST' then
469: -- Bulk Collect all the Asset Ids and call add lines
470: select asset_id
471: BULK COLLECT INTO v_id_tbl
472: from iex_available_assets_v ;
473: /* MODIFY */
474: -- where delinquency_id = p_del_id ;
475: -- and joins to contracts view.
476: Elsif p_source_module = 'IEXWOCNT' then
476: Elsif p_source_module = 'IEXWOCNT' then
477: -- Select id from Left Side Bali Spread for WriteOff Contract
478: --select contract_id
479: -- BULK COLLECT INTO v_id_tbl
480: --from iex_available_assets_v
481: --where delinquency_id = p_del_id ;
482: Null ;
483: Elsif p_source_module = 'IEXWOINV' then
484: -- Select id from Left Side Bali Spread for WriteOff Invoice
483: Elsif p_source_module = 'IEXWOINV' then
484: -- Select id from Left Side Bali Spread for WriteOff Invoice
485: --select asset_id
486: -- BULK COLLECT INTO v_id_tbl
487: --from iex_available_assets_v
488: --where delinquency_id = p_del_id ;
489: Null ;
490:
491: End If ;