DBA Data[Home] [Help]

APPS.PA_CREATE_RESOURCE dependencies on PA_EXPENDITURE_TYPES_RES_V

Line 2560: pa_expenditure_types_res_v

2556: CURSOR c_exp_types_csr_1 IS
2557: SELECT
2558: expenditure_type
2559: FROM
2560: pa_expenditure_types_res_v
2561: WHERE expenditure_type = p_expenditure_type
2562: AND expenditure_category = l_exp_category;
2563:
2564:

Line 2569: pa_expenditure_types_res_v

2565: CURSOR c_exp_types_csr_2 IS
2566: SELECT
2567: expenditure_type
2568: FROM
2569: pa_expenditure_types_res_v
2570: WHERE expenditure_type = p_expenditure_type
2571: AND revenue_category_code = l_revenue_category_code;
2572:
2573: CURSOR c_event_types_csr IS

Line 2786: 'Select expenditure_type from pa_expenditure_types_res_v';

2782: --- cannot be specified under the Resource_Group of 'Fee'
2783:
2784: IF p_parent_member_id IS NOT NULL THEN
2785: p_err_stage :=
2786: 'Select expenditure_type from pa_expenditure_types_res_v';
2787: IF l_grouped_res_type_code = 'EXPENDITURE_CATEGORY' AND
2788: p_resource_type_code = 'EXPENDITURE_TYPE' THEN
2789: OPEN c_exp_types_csr_1;
2790: FETCH c_exp_types_csr_1 INTO l_exp_type;