DBA Data[Home] [Help]

APPS.OZF_BUDGETAPPROVAL_PVT dependencies on AMS_ACT_MARKET_SEGMENTS

Line 985: FROM ams_act_market_segments

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:

Line 1942: FROM ams_act_market_segments

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'