DBA Data[Home] [Help]

APPS.FA_MASSPSLTFR_PKG dependencies on FA_ASSET_INVOICES

Line 119: from fa_asset_invoices b

115:
116: CURSOR source_lines (p_src_line_id number
117: ) IS
118: select b.source_line_id
119: from fa_asset_invoices b
120: where b.source_line_id in (
121: select a.source_line_id
122: from fa_asset_invoices a
123: start with a.source_Line_id = p_src_line_id

Line 122: from fa_asset_invoices a

118: select b.source_line_id
119: from fa_asset_invoices b
120: where b.source_line_id in (
121: select a.source_line_id
122: from fa_asset_invoices a
123: start with a.source_Line_id = p_src_line_id
124: connect by prior a.source_line_id = a.prior_source_line_id
125: and prior a.asset_id = a.asset_id
126: )