APPS.FA_TRANSACTION_ITF_PKG dependencies on FA_ADDITIONS

Line 107: from fa_additions

103: and nvl(segment10, '-1') = nvl(c_akey_seg(10), '-1');
104:
105: cursor get_cip_assets(c_akey_seg varchar30_tbl) is
106: select asset_id
107: from fa_additions
108: where asset_type = 'CIP'
109: and asset_key_ccid in
110: (SELECT code_combination_id
111: FROM fa_asset_keywords

Line 228: /*fetch the cipa sset from fa_Additions */

224:
225: /*get all assets matching AFE Number and HIERARCHY value*/
226: open get_cip_assets(l_akey_segment);
227: while true loop
228: /*fetch the cipa sset from fa_Additions */
229: fetch get_cip_assets
230: into l_asset_id;
231:
232: if (get_cip_assets%NOTFOUND) then