DBA Data[Home] [Help]

APPS.IGI_IAC_COMMON_UTILS dependencies on FA_ADDITIONS

Line 872: from fa_additions

868: X_Price_Index_Name OUT NOCOPY VARCHAR2 ) RETURN BOOLEAN IS
869:
870: Cursor cat is
871: select asset_category_id
872: from fa_additions
873: where asset_id = X_asset_id;
874:
875: Cursor prc_idx(p_cat number) is
876: select price_index_id

Line 919: from fa_additions

915: X_Price_Index_Value OUT NOCOPY NUMBER ) RETURN BOOLEAN IS
916:
917: Cursor cat is
918: select asset_category_id
919: from fa_additions
920: where asset_id = X_asset_id;
921:
922: Cursor cal_price_idx_id(p_cat number ) is
923: select cal_price_index_link_id

Line 1393: FROM fa_additions

1389: AND nvl(glcc.end_date_active, sysdate) >= sysdate;
1390:
1391: CURSOR get_category_id IS
1392: SELECT asset_category_id
1393: FROM fa_additions
1394: WHERE asset_id = X_asset_id;
1395:
1396: Cursor get_iac_category_id is
1397: SELECT category_id

Line 1431: FROM fa_additions

1427: FROM FA_CATEGORY_BOOKS
1428: WHERE book_type_code = X_book_type_code
1429: AND category_id IN
1430: (SELECT asset_category_id
1431: FROM fa_additions
1432: WHERE asset_id = X_asset_id);
1433:
1434: CURSOR c_get_nbv_accounts is
1435: SELECT nbv_retired_gain_acct,nbv_retired_loss_acct