981:
982: -- get budget's included and excluded market qualifier ids
983: CURSOR c_get_budget_market_qualifiers(p_exclude_flag IN VARCHAR2) IS
984: SELECT market_segment_id, segment_type, exclude_flag
985: FROM ams_act_market_segments
986: WHERE act_market_segment_used_by_id = p_budget_id
987: AND arc_act_market_segment_used_by = 'FUND'
988: AND exclude_flag = p_exclude_flag;
989:
1938:
1939: -- get budget's included and excluded market qualifier ids
1940: CURSOR c_get_budget_market_qualifiers(p_exclude_flag IN VARCHAR2) IS
1941: SELECT distinct market_segment_id, segment_type, exclude_flag
1942: FROM ams_act_market_segments
1943: WHERE act_market_segment_used_by_id
1944: IN
1945: (SELECT budget_source_id FROM ozf_act_budgets
1946: WHERE arc_act_budget_used_by = 'OFFR'