DBA Data[Home] [Help]

APPS.CSE_ASSET_ADJUST_PKG dependencies on FA_ASSET_INVOICES

Line 125: FROM fa_asset_invoices

121: l_cost NUMBER ;
122: CURSOR mtl_src_lines_cur IS
123: SELECT source_line_id
124: , fixed_assets_cost cost
125: FROM fa_asset_invoices
126: WHERE SIGN(fixed_assets_cost) = SIGN(p_mtl_cost)
127: AND NVL(attribute15,'N') = 'Y'
128: AND date_ineffective IS NULL
129: AND asset_id = p_asset_id ;

Line 135: FROM fa_asset_invoices

131:
132: CURSOR non_mtl_src_lines_cur IS
133: SELECT source_line_id
134: , fixed_assets_cost cost
135: FROM fa_asset_invoices
136: WHERE SIGN(fixed_assets_cost) = SIGN(p_mtl_cost)
137: AND NVL(attribute15,'N') <> 'Y'
138: AND date_ineffective IS NULL
139: AND asset_id = p_asset_id ;