APPS.CN_API dependencies on GL_SETS_OF_BOOKS

Line 2378: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;

2374: i number;
2375: nsegs number;
2376: segment_descr varchar2(2000);
2377: sql_stmt varchar2(2000);
2378: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
2379:
2380: l_counter NUMBER := 0;
2381: ccid NUMBER;
2382: ccid_value VARCHAR2(2000);

Line 2392: FROM gl_sets_of_books gsb,

2388: BEGIN
2389:
2390: SELECT chart_of_accounts_id
2391: INTO l_chart_of_accounts_id
2392: FROM gl_sets_of_books gsb,
2393: cn_repositories_all cr
2394: WHERE cr.set_of_books_id = gsb.set_of_books_id
2395: AND cr.org_id = p_org_id;
2396:

Line 2467: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;

2463: i number;
2464: nsegs number;
2465: segment_descr varchar2(2000);
2466: sql_stmt varchar2(2000);
2467: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
2468:
2469: l_counter NUMBER := 0;
2470: ccid NUMBER;
2471: ccid_value VARCHAR2(2000);

Line 2481: FROM gl_sets_of_books gsb,

2477: BEGIN
2478:
2479: SELECT chart_of_accounts_id
2480: INTO l_chart_of_accounts_id
2481: FROM gl_sets_of_books gsb,
2482: cn_repositories_all cr
2483: WHERE cr.set_of_books_id = gsb.set_of_books_id
2484: AND org_id = p_org_id;
2485:

Line 2552: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;

2548:
2549: l_code Varchar2(4000);
2550:
2551:
2552: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
2553:
2554: l_counter NUMBER := 0;
2555: ccid NUMBER;
2556: ccid_value VARCHAR2(2000);

Line 2566: FROM gl_sets_of_books gsb,

2562: BEGIN
2563:
2564: SELECT chart_of_accounts_id
2565: INTO l_chart_of_accounts_id
2566: FROM gl_sets_of_books gsb,
2567: cn_repositories_all cr
2568: WHERE cr.set_of_books_id = gsb.set_of_books_id
2569: AND org_id = p_org_id;
2570: