APPS.IGI_IAC_COMMON_UTILS dependencies on GL_SETS_OF_BOOKS

Line 1183: FROM gl_sets_of_books

1179: WHERE bc.book_type_code = p_book_type_code
1180: AND bc.date_ineffective IS NULL ;
1181: Cursor get_curr (p_set_of_books_id Number) is
1182: SELECT currency_code
1183: FROM gl_sets_of_books
1184: WHERE set_of_books_id = p_set_of_books_id;
1185: Cursor get_precision ( p_currency_code varchar2) is
1186: SELECT Precision
1187: FROM fnd_currencies

Line 1246: X_sob_id IN gl_sets_of_books.set_of_books_id%TYPE,

1242: Parameters possible segment types are 'GL_ACCOUNT', 'GL_BALANCING', 'FA_COST_CTR'
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

Line 1265: gl_sets_of_books sob

1261: l_path_name := g_path||'get_account_segment_value';
1262: SELECT application_column_name
1263: INTO l_segment
1264: FROM fnd_segment_attribute_values ,
1265: gl_sets_of_books sob
1266: WHERE id_flex_code = 'GL#'
1267: AND attribute_value = 'Y'
1268: AND segment_attribute_type = X_segment_type
1269: AND application_id = 101