DBA Data[Home] [Help]

APPS.PA_CREATE_RESOURCE dependencies on PA_EXPENDITURE_TYPES_RES_V

Line 2908: pa_expenditure_types_res_v

2904: CURSOR c_exp_types_csr_1 IS
2905: SELECT
2906: expenditure_type
2907: FROM
2908: pa_expenditure_types_res_v
2909: WHERE expenditure_type = p_expenditure_type
2910: AND expenditure_category = l_exp_category;
2911:
2912:

Line 2917: pa_expenditure_types_res_v

2913: CURSOR c_exp_types_csr_2 IS
2914: SELECT
2915: expenditure_type
2916: FROM
2917: pa_expenditure_types_res_v
2918: WHERE expenditure_type = p_expenditure_type
2919: AND revenue_category_code = l_revenue_category_code;
2920:
2921: CURSOR c_event_types_csr IS

Line 3134: 'Select expenditure_type from pa_expenditure_types_res_v';

3130: --- cannot be specified under the Resource_Group of 'Fee'
3131:
3132: IF p_parent_member_id IS NOT NULL THEN
3133: p_err_stage :=
3134: 'Select expenditure_type from pa_expenditure_types_res_v';
3135: IF l_grouped_res_type_code = 'EXPENDITURE_CATEGORY' AND
3136: p_resource_type_code = 'EXPENDITURE_TYPE' THEN
3137: OPEN c_exp_types_csr_1;
3138: FETCH c_exp_types_csr_1 INTO l_exp_type;