DBA Data[Home] [Help]

APPS.IGI_IAC_COMMON_UTILS dependencies on FA_ADDITIONS

Line 842: from fa_additions

838: X_Price_Index_Name OUT NOCOPY VARCHAR2 ) RETURN BOOLEAN IS
839:
840: Cursor cat is
841: select asset_category_id
842: from fa_additions
843: where asset_id = X_asset_id;
844:
845: Cursor prc_idx(p_cat number) is
846: select price_index_id

Line 889: from fa_additions

885: X_Price_Index_Value OUT NOCOPY NUMBER ) RETURN BOOLEAN IS
886:
887: Cursor cat is
888: select asset_category_id
889: from fa_additions
890: where asset_id = X_asset_id;
891:
892: Cursor cal_price_idx_id(p_cat number ) is
893: select cal_price_index_link_id

Line 1363: FROM fa_additions

1359: AND nvl(glcc.end_date_active, sysdate) >= sysdate;
1360:
1361: CURSOR get_category_id IS
1362: SELECT asset_category_id
1363: FROM fa_additions
1364: WHERE asset_id = X_asset_id;
1365:
1366: Cursor get_iac_category_id is
1367: SELECT category_id

Line 1401: FROM fa_additions

1397: FROM FA_CATEGORY_BOOKS
1398: WHERE book_type_code = X_book_type_code
1399: AND category_id IN
1400: (SELECT asset_category_id
1401: FROM fa_additions
1402: WHERE asset_id = X_asset_id);
1403:
1404: CURSOR c_get_nbv_accounts is
1405: SELECT nbv_retired_gain_acct,nbv_retired_loss_acct