APPS.OZF_BUDGETAPPROVAL_PVT dependencies on AMS_ACT_MARKET_SEGMENTS

Line 981: FROM ams_act_market_segments

977:
978: -- get budget's included and excluded market qualifier ids
979: CURSOR c_get_budget_market_qualifiers(p_exclude_flag IN VARCHAR2) IS
980: SELECT market_segment_id, segment_type, exclude_flag
981: FROM ams_act_market_segments
982: WHERE act_market_segment_used_by_id = p_budget_id
983: AND arc_act_market_segment_used_by = 'FUND'
984: AND exclude_flag = p_exclude_flag;
985:

Line 1938: FROM ams_act_market_segments

1934:
1935: -- get budget's included and excluded market qualifier ids
1936: CURSOR c_get_budget_market_qualifiers(p_exclude_flag IN VARCHAR2) IS
1937: SELECT distinct market_segment_id, segment_type, exclude_flag
1938: FROM ams_act_market_segments
1939: WHERE act_market_segment_used_by_id
1940: IN
1941: (SELECT budget_source_id FROM ozf_act_budgets
1942: WHERE arc_act_budget_used_by = 'OFFR'