APPS.FA_TRANSACTION_ITF_PKG dependencies on FA_ASSET_KEYWORDS

Line 93: FROM fa_asset_keywords

89:
90: cursor get_asset_key_ccid(c_akey_seg varchar30_tbl) is
91: SELECT code_combination_id
92: INTO l_akey_ccid
93: FROM fa_asset_keywords
94: WHERE nvl(segment1, '-1') = nvl(c_akey_seg(1), '-1')
95: and nvl(segment2, '-1') = nvl(c_akey_seg(2), '-1')
96: and nvl(segment3, '-1') = nvl(c_akey_seg(3), '-1')
97: and nvl(segment4, '-1') = nvl(c_akey_seg(4), '-1')

Line 111: FROM fa_asset_keywords

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
112: WHERE nvl(segment1, '-1') =
113: nvl(c_akey_seg(1), nvl(segment1, '-1'))
114: and nvl(segment2, '-1') =
115: nvl(c_akey_seg(2), nvl(segment2, '-1'))