APPS.PA_CREATE_RESOURCE dependencies on PA_RESOURCE_TYPES_ACTIVE_V

Line 105: pa_resource_types_active_v

101: CURSOR c_resource_types_csr IS
102: SELECT
103: resource_type_code
104: FROM
105: pa_resource_types_active_v
106: WHERE resource_type_id = l_resource_type_id;
107:
108: CURSOR c_revenue_categ_csr IS -- changed for perf bug 4887375
109: /*SELECT

Line 1805: pa_resource_types_active_v

1801: CURSOR c_res_types_csr IS
1802: SELECT
1803: resource_class_code
1804: FROM
1805: pa_resource_types_active_v
1806: WHERE
1807: resource_type_code = p_resource_type_code;
1808:
1809: CURSOR c_res_format_csr IS

Line 1840: p_err_stage := 'Select resource_class_code from pa_resource_types_active_v';

1836: p_err_stack :=
1837: p_err_stack ||'->PA_CREATE_RESOURCE.Create_Resource_txn_Attribute';
1838:
1839:
1840: p_err_stage := 'Select resource_class_code from pa_resource_types_active_v';
1841:
1842: OPEN c_res_types_csr;
1843: FETCH c_res_types_csr INTO l_resource_class_code;
1844: IF c_res_types_csr%NOTFOUND THEN

Line 2055: pa_resource_types_active_v

2051: CURSOR c_resource_types_csr IS
2052: SELECT
2053: resource_type_code
2054: FROM
2055: pa_resource_types_active_v
2056: WHERE resource_type_id = l_grouped_resource_type_id;
2057:
2058: CURSOR c_rev_category_csr IS -- changed for perf bug 4887375
2059: /*SELECT

Line 2628: pa_resource_types_active_v

2624: CURSOR c_resource_types_csr IS
2625: SELECT
2626: resource_type_id
2627: FROM
2628: pa_resource_types_active_v
2629: WHERE resource_type_code = p_resource_type_code;
2630:
2631: CURSOR c_resource_seq_csr IS
2632: SELECT

Line 2655: p_err_stage := 'Select resource_type_id from pa_resource_types_active_v ';

2651: p_err_stage := 'PA_RL_RES_TYPE_CODE_REQD';
2652: RETURN;
2653: END IF;
2654:
2655: p_err_stage := 'Select resource_type_id from pa_resource_types_active_v ';
2656:
2657: OPEN c_resource_types_csr;
2658: FETCH c_resource_types_csr INTO
2659: l_resource_type_id;