DBA Data[Home] [Help]

APPS.FA_MASS_RET_PUB dependencies on FA_BOOKS

Line 118: From fa_books bk,

114: WHERE code_combination_id = l_asset_key_id;
115:
116: cursor c_fromasset is
117: Select 'Validated'
118: From fa_books bk,
119: fa_additions ad
120: Where ad.asset_number = l_from_asset_no
121: And ad.asset_id = bk.asset_id
122: And bk.book_type_code = l_book

Line 127: From fa_books bk,

123: And bk.date_ineffective is null;
124:
125: cursor c_toasset is
126: Select 'Validated'
127: From fa_books bk,
128: fa_additions ad
129: Where ad.asset_number = l_to_asset_no
130: And ad.asset_id = bk.asset_id
131: And bk.book_type_code = l_book