APPS.CN_API dependencies on GL_SETS_OF_BOOKS

Line 2400: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;

2396: i number;
2397: nsegs number;
2398: segment_descr varchar2(2000);
2399: sql_stmt varchar2(2000);
2400: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
2401:
2402: l_counter NUMBER := 0;
2403: ccid NUMBER;
2404: ccid_value VARCHAR2(2000);

Line 2414: FROM gl_sets_of_books gsb,

2410: BEGIN
2411:
2412: SELECT chart_of_accounts_id
2413: INTO l_chart_of_accounts_id
2414: FROM gl_sets_of_books gsb,
2415: cn_repositories_all cr
2416: WHERE cr.set_of_books_id = gsb.set_of_books_id
2417: AND cr.org_id = p_org_id;
2418:

Line 2489: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;

2485: i number;
2486: nsegs number;
2487: segment_descr varchar2(2000);
2488: sql_stmt varchar2(2000);
2489: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
2490:
2491: l_counter NUMBER := 0;
2492: ccid NUMBER;
2493: ccid_value VARCHAR2(2000);

Line 2503: FROM gl_sets_of_books gsb,

2499: BEGIN
2500:
2501: SELECT chart_of_accounts_id
2502: INTO l_chart_of_accounts_id
2503: FROM gl_sets_of_books gsb,
2504: cn_repositories_all cr
2505: WHERE cr.set_of_books_id = gsb.set_of_books_id
2506: AND org_id = p_org_id;
2507:

Line 2574: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;

2570:
2571: l_code Varchar2(4000);
2572:
2573:
2574: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
2575:
2576: l_counter NUMBER := 0;
2577: ccid NUMBER;
2578: ccid_value VARCHAR2(2000);

Line 2588: FROM gl_sets_of_books gsb,

2584: BEGIN
2585:
2586: SELECT chart_of_accounts_id
2587: INTO l_chart_of_accounts_id
2588: FROM gl_sets_of_books gsb,
2589: cn_repositories_all cr
2590: WHERE cr.set_of_books_id = gsb.set_of_books_id
2591: AND org_id = p_org_id;
2592: