APPS.GL_BIS_ALERTS_PKG dependencies on BISBV_TARGET_LEVELS

Line 44: bisbv_target_levels tl,

40: c_gl_sm, 0) dim2_level_code,
41: workflow_item_type wf_item_type,
42: workflow_process_short_name wf_process
43: FROM bis_indicators ind,
44: bisbv_target_levels tl,
45: bisbv_dimension_levels dl1,
46: bisbv_dimension_levels dl2
47: WHERE ind.short_name = c_gl_revenue_pm
48: AND tl.measure_id = ind.indicator_id

Line 161: ', bisbv_target_levels tl ' ||

157: trg_select := trg_select ||
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 ||

Line 896: FROM bisbv_target_levels tl,

892: l_target NUMBER; -- planned revenue amount
893:
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

Line 916: FROM bisbv_target_levels tl,

912: AND sob.set_of_books_id = to_number(p_target_rec.org_level_value_id);
913:
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