APPS.OZF_ACTBUDGETRULES_PVT dependencies on AMS_CAT_ACTIVITIES

Line 51: FROM ams_cat_activities

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

Line 57: FROM ams_cat_activities

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

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

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