APPS.IGI_IAC_REVAL_CONCURRENT dependencies on FA_ADDITIONS

Line 146: from igi_iac_reval_asset_rules ac, fa_additions fadd

142: , cp_book_type_code in varchar2
143: , cp_category_id in number
144: ) is
145: select ac.asset_id, ac.revaluation_type, ac.revaluation_factor, fadd.asset_number
146: from igi_iac_reval_asset_rules ac, fa_additions fadd
147: where ac.revaluation_id = cp_revaluation_id
148: and ac.book_type_code = cp_book_type_code
149: and ac.category_id = cp_category_id
150: and ac.asset_id = fadd.asset_id

Line 171: TYPE asset_no_tbl_type IS TABLE OF FA_ADDITIONS.ASSET_NUMBER%TYPE

167: TYPE reval_type_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES. REVALUATION_TYPE%TYPE
168: INDEX BY BINARY_INTEGER;
169: TYPE reval_factor_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES.REVALUATION_FACTOR%TYPE
170: INDEX BY BINARY_INTEGER;
171: TYPE asset_no_tbl_type IS TABLE OF FA_ADDITIONS.ASSET_NUMBER%TYPE
172: INDEX BY BINARY_INTEGER;
173:
174: l_asset_id asset_id_tbl_type;
175: l_reval_type reval_type_tbl_type;

Line 414: from igi_iac_reval_asset_rules r, fa_additions fadd

410: , cp_book_type_code in varchar2
411: , cp_category_id in number
412: ) is
413: select r.asset_id, r.revaluation_type, r.revaluation_factor, fadd.asset_number
414: from igi_iac_reval_asset_rules r, fa_additions fadd
415: where r.revaluation_id = cp_revaluation_id
416: and r.book_type_code = cp_book_type_code
417: and r.category_id = cp_category_id
418: and nvl(r.selected_for_reval_flag,'X') = 'Y'

Line 445: TYPE asset_no_tbl_type IS TABLE OF FA_ADDITIONS.ASSET_NUMBER%TYPE

441: TYPE reval_type_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES. REVALUATION_TYPE%TYPE
442: INDEX BY BINARY_INTEGER;
443: TYPE reval_factor_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES.REVALUATION_FACTOR%TYPE
444: INDEX BY BINARY_INTEGER;
445: TYPE asset_no_tbl_type IS TABLE OF FA_ADDITIONS.ASSET_NUMBER%TYPE
446: INDEX BY BINARY_INTEGER;
447:
448: l_asset_id asset_id_tbl_type;
449: l_reval_type reval_type_tbl_type;