[Home] [Help]
192: --changed the message also accordingly
193: IF l_ccid > 0 THEN
194: for cc_rec in
195: (select detail_budgeting_allowed_flag, summary_flag
196: from gl_code_combinations
197: where code_combination_id = l_ccid
198: )
199: loop
200: if cc_rec.detail_budgeting_allowed_flag = 'N'
745: l_cursor_id INTEGER;
746: BEGIN
747:
748:
749: l_sql := ' SELECT count(*) FROM gl_code_combinations glcc, ' ||
750: ' psb_account_position_set_lines apsl ' ||
751: ' WHERE glcc.code_combination_id = :ccid ' ||
752: ' AND apsl.line_sequence_id = :line_sequence_id ' ||
753: ' AND glcc.enabled_flag = ''Y''' ||
802: /*===========================================================================+
803: | FUNCTION Get_Active_Segments (Private) |
804: +===========================================================================*/
805: --
806: -- This Private function finds active segments in gl_code_combinations table
807: -- and stores those in a global table g_active_segments_tab.
808: --
809:
810: FUNCTION Get_Active_Segments( p_chart_of_accounts_id IN NUMBER )