DBA Data[Home] [Help]

APPS.IGI_IAC_DEPRN_PKG dependencies on FA_ADJUSTMENTS

Line 1146: FROM fa_adjustments

1142: c_adjustment_source_type_code VARCHAR2,
1143: c_adjustment_type VARCHAR2,
1144: c_transaction_header_id NUMBER) IS
1145: SELECT code_combination_id
1146: FROM fa_adjustments
1147: WHERE book_type_code = p_book_type_code
1148: AND asset_id = c_asset_id
1149: AND distribution_id = c_distribution_id
1150: AND period_counter_created = p_period_counter

Line 1182: FROM fa_adjustments

1178: c_adjustment_source_type_code VARCHAR2,
1179: c_adjustment_type VARCHAR2,
1180: c_transaction_header_id NUMBER) IS
1181: SELECT code_combination_id
1182: FROM fa_adjustments
1183: WHERE book_type_code = p_book_type_code
1184: AND asset_id = c_asset_id
1185: AND distribution_id = c_distribution_id
1186: AND adjustment_type = c_adjustment_type;

Line 1320: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Could not get '||l_adj_type(l_loop_count)|| 'ccid from fa_adjustments');

1316: l_adj_type(l_loop_count),
1317: l_get_transaction.transaction_header_id);
1318: FETCH c_get_account_ccid into l_account_ccid;
1319: IF c_get_account_ccid%NOTFOUND THEN
1320: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Could not get '||l_adj_type(l_loop_count)|| 'ccid from fa_adjustments');
1321: l_account_ccid := -1;
1322: END IF;
1323: CLOSE c_get_account_ccid;
1324: