DBA Data[Home] [Help]

APPS.IGI_IMP_IAC_WEBADI_PKG dependencies on FA_ADDITIONS

Line 98: FROM fa_additions

94: SELECT COUNT(*)
95: INTO l_count
96: FROM igi_imp_iac_interface
97: WHERE asset_id = (SELECT asset_id
98: FROM fa_additions
99: WHERE asset_number = n_asset_number)
100: AND book_type_code = n_book_code
101: AND category_id = (SELECT category_id
102: FROM fa_categories_b_kfv

Line 128: FROM fa_additions

124: SELECT COUNT(*)
125: INTO l_count
126: FROM igi_imp_iac_interface
127: WHERE asset_id = (SELECT asset_id
128: FROM fa_additions
129: WHERE asset_number = n_asset_number)
130: AND book_type_code = n_book_code
131: AND group_id = n_group_id
132: AND category_id = (SELECT category_id

Line 170: FROM fa_additions

166: IS
167: SELECT COUNT(*)
168: FROM igi_imp_iac_interface
169: WHERE asset_id = (SELECT asset_id
170: FROM fa_additions
171: WHERE asset_number = p_asset_number)
172: AND book_type_code = p_book_code
173: AND category_id = (SELECT category_id
174: FROM fa_categories_b_kfv

Line 185: from fa_books fb,fa_additions fa

181:
182: cursor c_deprn_flag(cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE,
183: cp_asset_num igi_imp_iac_interface.asset_number%TYPE ) is
184: select depreciate_flag
185: from fa_books fb,fa_additions fa
186: where book_type_code =cp_book_type_code
187: and fa.asset_number = cp_asset_num
188: and fb.asset_id =fa.asset_id
189: and transaction_header_id_out is null;