DBA Data[Home] [Help]

APPS.IGI_IAC_COMMON_UTILS dependencies on FA_DISTRIBUTION_HISTORY

Line 394: FROM fa_distribution_history

390: l_path_name VARCHAR2(150);
391:
392: CURSOR c_active_dists IS
393: SELECT *
394: FROM fa_distribution_history
395: WHERE asset_id = P_Asset_Id
396: AND book_type_code = P_book_type_code
397: AND date_ineffective IS NULL ;
398: BEGIN

Line 457: FROM fa_distribution_history dh

453: l_path_name VARCHAR2(150);
454:
455: CURSOR c_dh IS
456: SELECT dh.*
457: FROM fa_distribution_history dh
458: WHERE dh.asset_id = P_Asset_Id
459: AND dh.book_type_code = P_book_type_Code
460: AND dh.date_ineffective IS NULL ;
461:

Line 1247: X_code_combination_id IN fa_distribution_history.code_combination_id%TYPE,

1243: */
1244:
1245: FUNCTION Get_Account_Segment_Value (
1246: X_sob_id IN gl_sets_of_books.set_of_books_id%TYPE,
1247: X_code_combination_id IN fa_distribution_history.code_combination_id%TYPE,
1248: X_segment_type IN VARCHAR2 ,
1249: X_segment_value IN OUT NOCOPY VARCHAR2 )
1250: RETURN BOOLEAN IS
1251: l_account_value VARCHAR2(30);

Line 1296: FROM fa_distribution_history

1292: Cursor get_dist_ccid (p_book_type_code Varchar2,
1293: P_asset_id Number,
1294: p_distribution_id Number) IS
1295: SELECT code_combination_id
1296: FROM fa_distribution_history
1297: WHERE Book_type_code = p_book_type_code
1298: AND asset_id = p_asset_id
1299: AND distribution_id = p_distribution_id;
1300: