[Home] [Help]
3044: --Tune The Query and Remove Extra Columns
3045: --cursor can fetch multiple Records
3046: cursor c_lq_asset_line(p_parent_object_id NUMBER,p_fee_id NUMBER) IS
3047: select olr.*
3048: from okl_line_relationships_b olr,
3049: okl_fees_b ofv
3050: where ofv.FEE_TYPE='CAPITALIZED'
3051: AND olr.related_line_id = p_fee_id
3052: AND olr.related_line_id = ofv.id -- Added by rravikir for Bug 4736523