APPS.PA_RBS_UTILS dependencies on PA_EXPENDITURE_CATEGORIES

Line 348: FROM pa_expenditure_categories

344: IF p_resource_type_code = 'EXPENDITURE_CATEGORY' THEN
345: BEGIN
346: SELECT expenditure_category
347: INTO l_element_name
348: FROM pa_expenditure_categories
349: WHERE expenditure_category_id = p_resource_source_id;
350: EXCEPTION
351: WHEN OTHERS THEN
352: l_element_name := Null;

Line 979: pa_expenditure_categories c,

975: FND_GLOBAL.LOGIN_ID
976: FROM
977: pa_rbs_element_names_b a,
978: pa_rbs_elem_in_temp b,
979: pa_expenditure_categories c,
980: Fnd_Languages L
981: WHERE a.resource_source_id = b.resource_source_id
982: and c.expenditure_category_id = a.resource_source_id
983: AND a.resource_type_id = p_resource_type_id

Line 1885: FROM pa_expenditure_categories ec,

1881: fnd_global.user_id,
1882: sysdate,
1883: fnd_global.user_id,
1884: fnd_global.login_id
1885: FROM pa_expenditure_categories ec,
1886: pa_rbs_element_names_b a,
1887: Fnd_Languages L
1888: WHERE a.resource_type_id = 5
1889: AND ec.EXPENDITURE_CATEGORY_ID =

Line 2882: from pa_expenditure_categories)

2878: from pa_expenditure_types)
2879: UNION
2880: (select expenditure_category_id resource_source_id,
2881: expenditure_category resource_name, 2 type_number
2882: from pa_expenditure_categories)
2883: UNION
2884: (select event_type_id resource_source_id,
2885: event_type resource_name, 3 type_number
2886: from pa_event_types)) source

Line 2916: from pa_expenditure_categories)

2912: pa_resource_list_members rlm,
2913: (select res_type_id, res_type_code from pa_res_types_b) typ,
2914: ((select expenditure_category_id resource_source_id,
2915: expenditure_category resource_name, 2 type_number
2916: from pa_expenditure_categories)
2917: UNION
2918: (select event_type_id resource_source_id,
2919: event_type resource_name, 3 type_number
2920: from pa_event_types)) source

Line 3069: FROM pa_expenditure_categories

3065:
3066: IF l_list.group_res_type = 'EXPENDITURE_CATEGORY' THEN
3067: SELECT expenditure_category_id
3068: INTO l_expenditure_category_id
3069: FROM pa_expenditure_categories
3070: WHERE expenditure_category =
3071: l_parents.expenditure_category;
3072: ELSIF l_list.group_res_type = 'REVENUE_CATEGORY' THEN
3073: BEGIN

Line 3236: FROM pa_expenditure_categories

3232: IF l_members.expenditure_category IS NOT NULL THEN
3233: BEGIN
3234: SELECT expenditure_category_id
3235: INTO l_expenditure_category_id
3236: FROM pa_expenditure_categories
3237: WHERE expenditure_category =
3238: l_members.expenditure_category;
3239: EXCEPTION WHEN NO_DATA_FOUND THEN
3240: l_expenditure_category_id := -777;