111: order by tfr.mass_external_transfer_id;
112:
113: CURSOR source_lines (p_src_line_id number) IS
114: select b.source_line_id
115: from fa_asset_invoices b
116: where b.source_line_id in (
117: select a.source_line_id
118: from fa_asset_invoices a
119: start with a.source_Line_id = p_src_line_id
114: select b.source_line_id
115: from fa_asset_invoices b
116: where b.source_line_id in (
117: select a.source_line_id
118: from fa_asset_invoices a
119: start with a.source_Line_id = p_src_line_id
120: connect by prior a.source_line_id = a.prior_source_line_id
121: and prior a.asset_id = a.asset_id)
122: and b.date_ineffective is null;