1140: l_ccid NUMBER;
1141: segment_descr VARCHAR2 (2000);
1142: sql_stmt VARCHAR2 (2000);
1143: where_stmt VARCHAR2 (2000);
1144: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
1145: ccid NUMBER;
1146: ccid_value VARCHAR2 (2000);
1147: l_account_type gl_code_combinations.account_type%TYPE;
1148:
1151: ccid_cur curtype;
1152: BEGIN
1153: SELECT chart_of_accounts_id
1154: INTO l_chart_of_accounts_id
1155: FROM gl_sets_of_books gsb,
1156: cn_repositories cr
1157: WHERE cr.set_of_books_id = gsb.set_of_books_id;
1158:
1159: fnd_flex_key_api.set_session_mode ('customer_data');