APPS.FA_MASSADD_PREP_ENERGY_PKG dependencies on GL_SETS_OF_BOOKS

Line 261: FROM GL_Sets_Of_Books GL_sob, FA_Book_Controls FA_BC

257: l_debug_str := 'Getting SOB id and COA';
258: --code to get asset key using fedder system
259: SELECT Gl_sob.Set_Of_Books_id, Chart_Of_Accounts_ID
260: INTO l_sob_id, l_coa
261: FROM GL_Sets_Of_Books GL_sob, FA_Book_Controls FA_BC
262: WHERE GL_sob.Set_Of_Books_ID = FA_BC.Set_Of_Books_ID
263: AND Book_Type_Code = px_mass_add_rec.book_type_code;
264:
265: if (upper(px_mass_add_rec.FEEDER_SYSTEM_NAME) = 'ORACLE PAYABLES') then

Line 534: h_chart_of_accounts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;

530: l_ACCOUNTING_FLEX_STRUCTURE fa_book_controls.accounting_flex_structure%type;
531: l_bal_seg_num NUMBER;
532: l_lookup_code varchar2(30);
533: l_debug_str varchar2(1000);
534: h_chart_of_accounts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
535:
536: CURSOR lookup_cur(c_lookup_type varchar2) IS
537: select lookup_code
538: from fa_lookups

Line 545: From fa_book_controls bc, gl_sets_of_books sob

541:
542: begin
543: Select sob.chart_of_accounts_id
544: into h_chart_of_accounts_id
545: From fa_book_controls bc, gl_sets_of_books sob
546: Where sob.set_of_books_id = bc.set_of_books_id
547: And bc.book_type_code = px_mass_add_rec.book_type_code;
548:
549: if (px_mass_add_rec.PAYABLES_CODE_COMBINATION_ID is not null) then

Line 1178: h_chart_of_accounts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;

1174: l_exp_acct_ccid number;
1175: l_gl_ccid_enabled_flag varchar2(1);
1176: l_ACCOUNTING_FLEX_STRUCTURE fa_book_controls.accounting_flex_structure%type;
1177:
1178: h_chart_of_accounts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
1179: h_flex_segment_delimiter varchar2(5);
1180: h_flex_segment_number number;
1181: h_num_of_segments NUMBER;
1182: h_concat_array_segments FND_FLEX_EXT.SEGMENTARRAY;

Line 1223: From fa_book_controls bc, gl_sets_of_books sob

1219: AND category_id = px_mass_add_rec.asset_category_id;
1220:
1221: Select sob.chart_of_accounts_id
1222: into h_chart_of_accounts_id
1223: From fa_book_controls bc, gl_sets_of_books sob
1224: Where sob.set_of_books_id = bc.set_of_books_id
1225: And bc.book_type_code = px_mass_add_rec.book_type_code;
1226: l_TRANSACTION_COA_ID := h_chart_of_accounts_id;
1227: