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 1458: pa_resource_types_active_v

1454: CURSOR c_res_types_csr IS
1455: SELECT
1456: resource_class_code
1457: FROM
1458: pa_resource_types_active_v
1459: WHERE
1460: resource_type_code = p_resource_type_code;
1461:
1462: CURSOR c_res_format_csr IS

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

1488: p_err_stack :=
1489: p_err_stack ||'->PA_CREATE_RESOURCE.Create_Resource_txn_Attribute';
1490:
1491:
1492: p_err_stage := 'Select resource_class_code from pa_resource_types_active_v';
1493:
1494: OPEN c_res_types_csr;
1495: FETCH c_res_types_csr INTO l_resource_class_code;
1496: IF c_res_types_csr%NOTFOUND THEN

Line 1707: pa_resource_types_active_v

1703: CURSOR c_resource_types_csr IS
1704: SELECT
1705: resource_type_code
1706: FROM
1707: pa_resource_types_active_v
1708: WHERE resource_type_id = l_grouped_resource_type_id;
1709:
1710: CURSOR c_rev_category_csr IS -- changed for perf bug 4887375
1711: /*SELECT

Line 2280: pa_resource_types_active_v

2276: CURSOR c_resource_types_csr IS
2277: SELECT
2278: resource_type_id
2279: FROM
2280: pa_resource_types_active_v
2281: WHERE resource_type_code = p_resource_type_code;
2282:
2283: CURSOR c_resource_seq_csr IS
2284: SELECT

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

2303: p_err_stage := 'PA_RL_RES_TYPE_CODE_REQD';
2304: RETURN;
2305: END IF;
2306:
2307: p_err_stage := 'Select resource_type_id from pa_resource_types_active_v ';
2308:
2309: OPEN c_resource_types_csr;
2310: FETCH c_resource_types_csr INTO
2311: l_resource_type_id;