APPS.PA_RBS_UTILS dependencies on PA_EXPENDITURE_TYPES

Line 333: FROM pa_expenditure_types

329: IF p_resource_type_code = 'EXPENDITURE_TYPE' THEN
330: BEGIN
331: SELECT expenditure_type
332: INTO l_element_name
333: FROM pa_expenditure_types
334: WHERE expenditure_type_id = p_resource_source_id;
335: EXCEPTION
336: WHEN OTHERS THEN
337: l_element_name := Null;

Line 940: pa_expenditure_types c,

936: FND_GLOBAL.LOGIN_ID
937: FROM
938: pa_rbs_element_names_b a,
939: pa_rbs_elem_in_temp b,
940: pa_expenditure_types c,
941: Fnd_Languages L
942: WHERE a.resource_source_id = b.resource_source_id
943: and c.expenditure_type_id = a.resource_source_id
944: AND a.resource_type_id = p_resource_type_id

Line 1926: FROM pa_expenditure_types ec,

1922: fnd_global.user_id,
1923: sysdate,
1924: fnd_global.user_id,
1925: fnd_global.login_id
1926: FROM pa_expenditure_types ec,
1927: pa_rbs_element_names_b a,
1928: Fnd_Languages L
1929: WHERE a.resource_type_id = 6
1930: AND ec.EXPENDITURE_TYPE_ID =

Line 2878: from pa_expenditure_types)

2874: FROM pa_resource_list_members rlm,
2875: (select res_type_id, res_type_code from pa_res_types_b) typ,
2876: ((select expenditure_type_id resource_source_id,
2877: expenditure_type resource_name, 1 type_number
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)

Line 2940: from pa_expenditure_types) source

2936: pa_resource_list_members rlm,
2937: (select res_type_id, res_type_code from pa_res_types_b) typ,
2938: (select expenditure_type_id resource_source_id,
2939: expenditure_type resource_name, 1 type_number
2940: from pa_expenditure_types) source
2941: WHERE rlm.resource_list_id = l_list.resource_list_id
2942: AND (rlm.resource_type_id = 105
2943: AND typ.res_type_code = 'EXPENDITURE_TYPE'
2944: AND source.resource_name = rlm.expenditure_type

Line 3263: FROM pa_expenditure_types

3259: --ELSIF l_res_type_code = 'EXPENDITURE_TYPE' THEN
3260: IF l_members.expenditure_type IS NOT NULL THEN
3261: SELECT expenditure_type_id
3262: INTO l_expenditure_type_id
3263: FROM pa_expenditure_types
3264: WHERE expenditure_type = l_members.expenditure_type;
3265: END IF;
3266:
3267: --ELSIF l_res_type_code = 'EVENT_TYPE' THEN