DBA Data[Home] [Help]

APPS.IGI_IAC_ADJ_PKG dependencies on FA_BOOKS

Line 64: -- to get fa_books previous entry before current adjustment

60: FROM fa_additions
61: WHERE asset_id =p_asset_hdr_rec.asset_id;
62:
63:
64: -- to get fa_books previous entry before current adjustment
65: CURSOR c_get_fa_book_info(p_book_type_code
66: fa_transaction_headers.book_type_code%TYPE,
67: p_asset_id fa_transaction_headers.asset_id%TYPE,
68: p_transaction_header_id

Line 71: FROM fa_books

67: p_asset_id fa_transaction_headers.asset_id%TYPE,
68: p_transaction_header_id
69: fa_transaction_headers.transaction_header_id%TYPE ) IS
70: SELECT *
71: FROM fa_books
72: WHERE book_type_code = p_book_type_code
73: AND asset_id = p_asset_id
74: AND transaction_header_id_out = p_transaction_header_id;
75:

Line 97: l_get_fa_book_info fa_books%ROWTYPE;

93: l_category_id number;
94: l_amort_period_info igi_iac_types.prd_rec;
95: l_open_period igi_iac_types.prd_rec;
96: l_iac_adjustment_history igi_iac_adjustments_history%ROWTYPE;
97: l_get_fa_book_info fa_books%ROWTYPE;
98: l_last_update_date date;
99: l_last_updated_by number;
100: l_last_update_login number;
101: l_creation_date date;

Line 879: FROM fa_books

875: CURSOR c_get_fa_book_info(p_book_type_code fa_transaction_headers.book_type_code%TYPE,
876: p_asset_id fa_transaction_headers.asset_id%TYPE
877: ) IS
878: SELECT *
879: FROM fa_books
880: WHERE book_type_code = p_book_type_code
881: AND asset_id = p_asset_id
882: AND transaction_header_id_out IS NULL;
883: