APPS.CN_API dependencies on GL_CODE_COMBINATIONS

Line 2383: l_account_type gl_code_combinations.account_type%type;

2379:
2380: l_counter NUMBER := 0;
2381: ccid NUMBER;
2382: ccid_value VARCHAR2(2000);
2383: l_account_type gl_code_combinations.account_type%type;
2384:
2385: TYPE curtype IS ref CURSOR;
2386: ccid_cur curtype;
2387:

Line 2418: ' FROM gl_code_combinations '||

2414: end loop;
2415: x_account_structure := segment_descr;
2416: sql_stmt := sql_stmt ||
2417: ', code_combination_id, account_type '||
2418: ' FROM gl_code_combinations '||
2419: ' WHERE chart_of_accounts_id = :B1' ||
2420: ' AND enabled_flag = ''Y''';
2421:
2422: -- commented out by KS.

Line 2472: l_account_type gl_code_combinations.account_type%type;

2468:
2469: l_counter NUMBER := 0;
2470: ccid NUMBER;
2471: ccid_value VARCHAR2(2000);
2472: l_account_type gl_code_combinations.account_type%type;
2473:
2474: TYPE curtype IS ref CURSOR;
2475: ccid_cur curtype;
2476:

Line 2506: ' FROM gl_code_combinations '||

2502: end if;
2503: end loop;
2504: sql_stmt := sql_stmt ||
2505: ', code_combination_id, account_type '||
2506: ' FROM gl_code_combinations '||
2507: ' WHERE code_combination_id = :B1';
2508:
2509: -- commented out by KS
2510: -- 09/28/01

Line 2557: l_account_type gl_code_combinations.account_type%type;

2553:
2554: l_counter NUMBER := 0;
2555: ccid NUMBER;
2556: ccid_value VARCHAR2(2000);
2557: l_account_type gl_code_combinations.account_type%type;
2558:
2559: TYPE curtype IS ref CURSOR;
2560: ccid_cur curtype;
2561:

Line 2591: ' FROM gl_code_combinations '||

2587: end if;
2588: end loop;
2589: sql_stmt := sql_stmt ||
2590: ', code_combination_id, account_type '||
2591: ' FROM gl_code_combinations '||
2592: ' WHERE code_combination_id = :B1' ;
2593:
2594: -- commented out by KS
2595: -- 09/28/01