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 309: l_chart_of_accts gl_sets_of_books.chart_of_accounts_id%TYPE;

305: p_form_concat_segs_high IN VARCHAR2,
306: p_db_concat_segs_low IN VARCHAR2,
307: p_db_concat_segs_high IN VARCHAR2) return NUMBER IS
308:
309: l_chart_of_accts gl_sets_of_books.chart_of_accounts_id%TYPE;
310: l_delimiter varchar2(1);
311: l_nsegs number;
312: l_form_segs_array_low fnd_flex_ext.SegmentArray;
313: l_form_segs_array_high fnd_flex_ext.SegmentArray;

Line 333: FROM gl_sets_of_books,ap_system_parameters_all

329: -- Get chart_of_account_id
330:
331: SELECT chart_of_accounts_id
332: INTO l_chart_of_accts
333: FROM gl_sets_of_books,ap_system_parameters_all
334: WHERE gl_sets_of_books.set_of_books_id = ap_system_parameters_all.set_of_books_id;
335:
336:
337: -- Call fnd_flex_ext.get_delimiter to get delimiter

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

330:
331: SELECT chart_of_accounts_id
332: INTO l_chart_of_accts
333: FROM gl_sets_of_books,ap_system_parameters_all
334: WHERE gl_sets_of_books.set_of_books_id = ap_system_parameters_all.set_of_books_id;
335:
336:
337: -- Call fnd_flex_ext.get_delimiter to get delimiter
338:

Line 837: FROM gl_sets_of_books,ap_system_parameters_all

833:
834:
835: CURSOR c_chart_of_accts IS
836: SELECT chart_of_accounts_id
837: FROM gl_sets_of_books,ap_system_parameters_all
838: WHERE gl_sets_of_books.set_of_books_id = ap_system_parameters_all.set_of_books_id;
839:
840: BEGIN
841:

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

834:
835: CURSOR c_chart_of_accts IS
836: SELECT chart_of_accounts_id
837: FROM gl_sets_of_books,ap_system_parameters_all
838: WHERE gl_sets_of_books.set_of_books_id = ap_system_parameters_all.set_of_books_id;
839:
840: BEGIN
841:
842: -- PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');