APPS.PA_RESOURCE_UTILS dependencies on PA_RESOURCE_TYPES

Line 285: /* Commented for bug#2683266 as person type should not be checked in pa_resource_types table

281: x_resource_id := NULL;
282: END IF;
283: END IF;
284:
285: /* Commented for bug#2683266 as person type should not be checked in pa_resource_types table
286: as pa_resource_types does not contain all person_types defined in HR table per_person_types
287:
288: IF l_sys_per_type is not null THEN
289: select resource_type_id

Line 286: as pa_resource_types does not contain all person_types defined in HR table per_person_types

282: END IF;
283: END IF;
284:
285: /* Commented for bug#2683266 as person type should not be checked in pa_resource_types table
286: as pa_resource_types does not contain all person_types defined in HR table per_person_types
287:
288: IF l_sys_per_type is not null THEN
289: select resource_type_id
290: into x_resource_type_id

Line 291: from pa_resource_types

287:
288: IF l_sys_per_type is not null THEN
289: select resource_type_id
290: into x_resource_type_id
291: from pa_resource_types
292: where resource_type_code = decode(l_sys_per_type,
293: 'EMP','EMPLOYEE');
294: END IF;
295: */

Line 4044: FROM pa_resources pr, pa_resource_types pt

4040: BEGIN
4041:
4042: SELECT resource_type_code
4043: INTO l_resource_type
4044: FROM pa_resources pr, pa_resource_types pt
4045: WHERE pr.resource_id = p_resource_id
4046: AND pr.resource_type_id = pt.resource_type_id;
4047:
4048: RETURN l_resource_type;

Line 4267: l_resource_type_code pa_resource_types.resource_type_code%TYPE;

4263: FUNCTION get_res_name_from_type(p_resource_type_id IN NUMBER,
4264: p_resource_source_id IN NUMBER)
4265: RETURN VARCHAR2 IS
4266:
4267: l_resource_type_code pa_resource_types.resource_type_code%TYPE;
4268: l_name pa_resources.name%TYPE;
4269:
4270: BEGIN
4271:

Line 4276: FROM pa_resource_types

4272: BEGIN
4273:
4274: SELECT resource_type_code
4275: INTO l_resource_type_code
4276: FROM pa_resource_types
4277: WHERE resource_type_id = p_resource_type_id;
4278:
4279: EXCEPTION
4280: WHEN OTHERS THEN