DBA Data[Home] [Help]

APPS.IGI_IAC_COMMON_UTILS dependencies on FA_DISTRIBUTION_HISTORY

Line 371: FROM fa_distribution_history

367: l_path_name VARCHAR2(150);
368:
369: CURSOR c_active_dists IS
370: SELECT *
371: FROM fa_distribution_history
372: WHERE asset_id = P_Asset_Id
373: AND book_type_code = P_book_type_code
374: AND date_ineffective IS NULL ;
375: BEGIN

Line 429: FROM fa_distribution_history dh

425: l_path_name VARCHAR2(150);
426:
427: CURSOR c_dh IS
428: SELECT dh.*
429: FROM fa_distribution_history dh
430: WHERE dh.asset_id = P_Asset_Id
431: AND dh.book_type_code = P_book_type_Code
432: AND dh.date_ineffective IS NULL ;
433:

Line 1217: X_code_combination_id IN fa_distribution_history.code_combination_id%TYPE,

1213: */
1214:
1215: FUNCTION Get_Account_Segment_Value (
1216: X_sob_id IN gl_sets_of_books.set_of_books_id%TYPE,
1217: X_code_combination_id IN fa_distribution_history.code_combination_id%TYPE,
1218: X_segment_type IN VARCHAR2 ,
1219: X_segment_value IN OUT NOCOPY VARCHAR2 )
1220: RETURN BOOLEAN IS
1221: l_account_value VARCHAR2(30);

Line 1266: FROM fa_distribution_history

1262: Cursor get_dist_ccid (p_book_type_code Varchar2,
1263: P_asset_id Number,
1264: p_distribution_id Number) IS
1265: SELECT code_combination_id
1266: FROM fa_distribution_history
1267: WHERE Book_type_code = p_book_type_code
1268: AND asset_id = p_asset_id
1269: AND distribution_id = p_distribution_id;
1270: