APPS.FA_MASSADD_PREP_DEFAULT_PKG dependencies on GL_SETS_OF_BOOKS

Line 32: h_chart_of_accounts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;

28: l_gl_ccid_enabled_flag varchar2(1);
29: l_ACCOUNTING_FLEX_STRUCTURE fa_book_controls.accounting_flex_structure%type;
30: l_bal_seg_num NUMBER;
31: l_lookup_code varchar2(30);
32: h_chart_of_accounts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
33: l_account_segment varchar2(30);
34: l_calling_fn varchar2(40) := 'prepare_asset_category_id';
35: h_flex_segment_number number;
36: l_asset_clearing_acct varchar2(25);

Line 41: From fa_book_controls bc, gl_sets_of_books sob

37: begin
38:
39: Select sob.chart_of_accounts_id
40: into h_chart_of_accounts_id
41: From fa_book_controls bc, gl_sets_of_books sob
42: Where sob.set_of_books_id = bc.set_of_books_id
43: And bc.book_type_code = px_mass_add_rec.book_type_code;
44:
45: if (px_mass_add_rec.PAYABLES_CODE_COMBINATION_ID is not null) then

Line 221: h_chart_of_accounts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;

217: l_exp_acct_ccid number;
218: l_gl_ccid_enabled_flag varchar2(1);
219: l_ACCOUNTING_FLEX_STRUCTURE fa_book_controls.accounting_flex_structure%type;
220: l_calling_fn varchar2(40) := 'prepare_expense_ccid';
221: h_chart_of_accounts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
222: h_flex_segment_delimiter varchar2(5);
223: h_flex_segment_number number;
224: h_num_of_segments NUMBER;
225: h_concat_array_segments FND_FLEX_EXT.SEGMENTARRAY;

Line 281: gl_sets_of_books sob

277: -- Get Chart of Accounts ID
278: Select sob.chart_of_accounts_id
279: into h_chart_of_accounts_id
280: From fa_book_controls bc,
281: gl_sets_of_books sob
282: Where sob.set_of_books_id = bc.set_of_books_id
283: And bc.book_type_code = px_mass_add_rec.book_type_code;
284:
285: /* Use the clearing ccid and then overlay the account segment with deprn exp acct from