122: l_cost NUMBER ;
123: CURSOR mtl_src_lines_cur IS
124: SELECT source_line_id
125: , fixed_assets_cost cost
126: FROM fa_asset_invoices
127: WHERE SIGN(fixed_assets_cost) = SIGN(p_mtl_cost)
128: AND NVL(attribute15,'N') = 'Y'
129: AND date_ineffective IS NULL
130: AND asset_id = p_asset_id ;
132:
133: CURSOR non_mtl_src_lines_cur IS
134: SELECT source_line_id
135: , fixed_assets_cost cost
136: FROM fa_asset_invoices
137: WHERE SIGN(fixed_assets_cost) = SIGN(p_mtl_cost)
138: AND NVL(attribute15,'N') <> 'Y'
139: AND date_ineffective IS NULL
140: AND asset_id = p_asset_id ;