APPS.OZF_ACTBUDGETRULES_PVT dependencies on AMS_CAT_ACTIVITIES

Line 48: FROM ams_cat_activities

44: WHERE qp_list_header_id = p_used_by_id;
45:
46: CURSOR c_get_cat_activity (p_category_id IN NUMBER, p_activity_id IN NUMBER) IS
47: SELECT 'X'
48: FROM ams_cat_activities
49: WHERE category_id = p_category_id
50: AND activity_id = p_activity_id;
51:
52: CURSOR c_cat_activity_count (p_category_id IN NUMBER) IS

Line 54: FROM ams_cat_activities

50: AND activity_id = p_activity_id;
51:
52: CURSOR c_cat_activity_count (p_category_id IN NUMBER) IS
53: SELECT COUNT(cat_activity_id) count
54: FROM ams_cat_activities
55: WHERE category_id = p_category_id;
56:
57: CURSOR c_get_category_id (p_budget_source_id IN NUMBER) IS
58: SELECT category_id

Line 73: -- check if category has a record in ams_cat_activities table

69:
70: OPEN c_get_category_id (p_budget_source_id);
71: FETCH c_get_category_id INTO l_category_id;
72: CLOSE c_get_category_id;
73: -- check if category has a record in ams_cat_activities table
74: OPEN c_cat_activity_count (l_category_id);
75: FETCH c_cat_activity_count INTO l_cat_act_count;
76: CLOSE c_cat_activity_count;
77: -- if cat activity association is there then match for the activity id