APPS.IGI_IAC_COMMON_UTILS dependencies on GL_SETS_OF_BOOKS

Line 1153: FROM gl_sets_of_books

1149: WHERE bc.book_type_code = p_book_type_code
1150: AND bc.date_ineffective IS NULL ;
1151: Cursor get_curr (p_set_of_books_id Number) is
1152: SELECT currency_code
1153: FROM gl_sets_of_books
1154: WHERE set_of_books_id = p_set_of_books_id;
1155: Cursor get_precision ( p_currency_code varchar2) is
1156: SELECT Precision
1157: FROM fnd_currencies

Line 1216: X_sob_id IN gl_sets_of_books.set_of_books_id%TYPE,

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

Line 1235: gl_sets_of_books sob

1231: l_path_name := g_path||'get_account_segment_value';
1232: SELECT application_column_name
1233: INTO l_segment
1234: FROM fnd_segment_attribute_values ,
1235: gl_sets_of_books sob
1236: WHERE id_flex_code = 'GL#'
1237: AND attribute_value = 'Y'
1238: AND segment_attribute_type = X_segment_type
1239: AND application_id = 101