DBA Data[Home] [Help]

APPS.ZX_TAX_RECOVERY_PKG dependencies on GL_SETS_OF_BOOKS

Line 23: g_chart_of_accts gl_sets_of_books.chart_of_accounts_id%TYPE;

19: type num_tab is table of number index by binary_integer;
20: type var2000_tab is table of varchar2(2000) index by binary_integer;
21: type var255_tab is table of varchar2(255) index by binary_integer;
22: g_delimiter varchar2(1);
23: g_chart_of_accts gl_sets_of_books.chart_of_accounts_id%TYPE;
24:
25:
26:
27: l_rec_rate_tab num_tab;

Line 295: l_chart_of_accts gl_sets_of_books.chart_of_accounts_id%TYPE;

291: p_form_concat_segs_high IN VARCHAR2,
292: p_db_concat_segs_low IN VARCHAR2,
293: p_db_concat_segs_high IN VARCHAR2) return NUMBER IS
294:
295: l_chart_of_accts gl_sets_of_books.chart_of_accounts_id%TYPE;
296: l_delimiter varchar2(1);
297: l_nsegs number;
298: l_form_segs_array_low fnd_flex_ext.SegmentArray;
299: l_form_segs_array_high fnd_flex_ext.SegmentArray;

Line 319: FROM gl_sets_of_books,ap_system_parameters_all

315: -- Get chart_of_account_id
316:
317: SELECT chart_of_accounts_id
318: INTO l_chart_of_accts
319: FROM gl_sets_of_books,ap_system_parameters_all
320: WHERE gl_sets_of_books.set_of_books_id = ap_system_parameters_all.set_of_books_id;
321:
322:
323: -- Call fnd_flex_ext.get_delimiter to get delimiter

Line 320: WHERE gl_sets_of_books.set_of_books_id = ap_system_parameters_all.set_of_books_id;

316:
317: SELECT chart_of_accounts_id
318: INTO l_chart_of_accts
319: FROM gl_sets_of_books,ap_system_parameters_all
320: WHERE gl_sets_of_books.set_of_books_id = ap_system_parameters_all.set_of_books_id;
321:
322:
323: -- Call fnd_flex_ext.get_delimiter to get delimiter
324:

Line 823: FROM gl_sets_of_books,ap_system_parameters_all

819:
820:
821: CURSOR c_chart_of_accts IS
822: SELECT chart_of_accounts_id
823: FROM gl_sets_of_books,ap_system_parameters_all
824: WHERE gl_sets_of_books.set_of_books_id = ap_system_parameters_all.set_of_books_id;
825:
826: BEGIN
827:

Line 824: WHERE gl_sets_of_books.set_of_books_id = ap_system_parameters_all.set_of_books_id;

820:
821: CURSOR c_chart_of_accts IS
822: SELECT chart_of_accounts_id
823: FROM gl_sets_of_books,ap_system_parameters_all
824: WHERE gl_sets_of_books.set_of_books_id = ap_system_parameters_all.set_of_books_id;
825:
826: BEGIN
827:
828: -- PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');