APPS.GL_BIS_ALERTS_PKG dependencies on GL_SETS_OF_BOOKS

Line 162: ', gl_sets_of_books sob ';

158: 'FROM ' ||
159: ' bisbv_targets trg ' ||
160: ', bisbv_business_plans bplan ' ||
161: ', bisbv_target_levels tl ' ||
162: ', gl_sets_of_books sob ';
163:
164: IF (p_dim1_level_code = 0) THEN
165: trg_select := trg_select ||
166: ', bis_flex_mappings_v fm1 ' ||

Line 264: FROM gl_sets_of_books sob,

260: IF p_organization_id <> g_old_org_id THEN
261:
262: SELECT pt.number_per_fiscal_year
263: INTO l_num_per_year
264: FROM gl_sets_of_books sob,
265: gl_period_types pt
266: WHERE sob.set_of_books_id = to_number(p_organization_id)
267: AND pt.period_type = sob.accounted_period_type;
268:

Line 791: FROM gl_sets_of_books sob,

787:
788: -- Get current period information
789: SELECT per.period_set_name || '+' || per.period_name
790: INTO l_period_id
791: FROM gl_sets_of_books sob,
792: gl_periods per
793: WHERE sob.set_of_books_id = p_sob_id
794: AND per.period_set_name = sob.period_set_name
795: AND per.period_type = sob.accounted_period_type

Line 898: gl_sets_of_books sob,

894: CURSOR c_segment1_num IS
895: SELECT sg.segment_num
896: FROM bisbv_target_levels tl,
897: bisbv_dimension_levels dl,
898: gl_sets_of_books sob,
899: bis_flex_mappings_v fm,
900: fnd_id_flex_segments sg
901: WHERE tl.target_level_id = p_target_rec.target_level_id
902: AND dl.dimension_level_id = tl.dimension1_level_id

Line 918: gl_sets_of_books sob,

914: CURSOR c_segment2_num IS
915: SELECT sg.segment_num
916: FROM bisbv_target_levels tl,
917: bisbv_dimension_levels dl,
918: gl_sets_of_books sob,
919: bis_flex_mappings_v fm,
920: fnd_id_flex_segments sg
921: WHERE tl.target_level_id = p_target_rec.target_level_id
922: AND dl.dimension_level_id = tl.dimension1_level_id

Line 940: FROM gl_sets_of_books sob,

936:
937: -- Get current period information
938: SELECT per.period_set_name || '+' || per.period_name
939: INTO l_period_id
940: FROM gl_sets_of_books sob,
941: gl_periods per
942: WHERE sob.set_of_books_id = to_number(p_target_rec.org_level_value_id)
943: AND per.period_set_name = sob.period_set_name
944: AND per.period_type = sob.accounted_period_type