APPS.CN_API dependencies on GL_CODE_COMBINATIONS

Line 2405: l_account_type gl_code_combinations.account_type%type;

2401:
2402: l_counter NUMBER := 0;
2403: ccid NUMBER;
2404: ccid_value VARCHAR2(2000);
2405: l_account_type gl_code_combinations.account_type%type;
2406:
2407: TYPE curtype IS ref CURSOR;
2408: ccid_cur curtype;
2409:

Line 2440: ' FROM gl_code_combinations '||

2436: end loop;
2437: x_account_structure := segment_descr;
2438: sql_stmt := sql_stmt ||
2439: ', code_combination_id, account_type '||
2440: ' FROM gl_code_combinations '||
2441: ' WHERE chart_of_accounts_id = :B1' ||
2442: ' AND enabled_flag = ''Y''';
2443:
2444: -- commented out by KS.

Line 2494: l_account_type gl_code_combinations.account_type%type;

2490:
2491: l_counter NUMBER := 0;
2492: ccid NUMBER;
2493: ccid_value VARCHAR2(2000);
2494: l_account_type gl_code_combinations.account_type%type;
2495:
2496: TYPE curtype IS ref CURSOR;
2497: ccid_cur curtype;
2498:

Line 2528: ' FROM gl_code_combinations '||

2524: end if;
2525: end loop;
2526: sql_stmt := sql_stmt ||
2527: ', code_combination_id, account_type '||
2528: ' FROM gl_code_combinations '||
2529: ' WHERE code_combination_id = :B1';
2530:
2531: -- commented out by KS
2532: -- 09/28/01

Line 2579: l_account_type gl_code_combinations.account_type%type;

2575:
2576: l_counter NUMBER := 0;
2577: ccid NUMBER;
2578: ccid_value VARCHAR2(2000);
2579: l_account_type gl_code_combinations.account_type%type;
2580:
2581: TYPE curtype IS ref CURSOR;
2582: ccid_cur curtype;
2583:

Line 2613: ' FROM gl_code_combinations '||

2609: end if;
2610: end loop;
2611: sql_stmt := sql_stmt ||
2612: ', code_combination_id, account_type '||
2613: ' FROM gl_code_combinations '||
2614: ' WHERE code_combination_id = :B1' ;
2615:
2616: -- commented out by KS
2617: -- 09/28/01