DBA Data[Home] [Help]

APPS.CSE_ASSET_ADJUST_PKG dependencies on FA_ASSET_INVOICES

Line 126: FROM fa_asset_invoices

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 ;

Line 136: FROM fa_asset_invoices

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 ;