APPS.PA_GET_RESOURCE dependencies on PA_REVENUE_CATEGORIES_V

Line 44: pa_revenue_categories_v

40: CURSOR c_revenue_category_csr IS
41: SELECT
42: revenue_category_m
43: FROM
44: pa_revenue_categories_v
45: WHERE
46: revenue_category_code = p_resource_group;
47:
48: CURSOR c_org_csr IS

Line 114: ' Select revenue_category_m from pa_revenue_categories_v';

110: l_resource_name := p_resource_group;
111: ELSIF l_resource_type_code = 'REVENUE_CATEGORY' THEN
112: l_revenue_category := p_resource_group;
113: p_err_stage :=
114: ' Select revenue_category_m from pa_revenue_categories_v';
115: -- Need to get the revenue_category_m (Meaning) since what is passed
116: -- is the revenue_category_code
117: OPEN c_revenue_category_csr;
118: FETCH c_revenue_category_csr INTO l_resource_name;