APPS.PA_PLANNING_RESOURCE_PVT dependencies on PER_PEOPLE_X

Line 264: l_person_name per_people_x.full_name%TYPE;

260: l_res_class_code VARCHAR2(30);
261: l_res_class_id Number;
262: l_fmt_details get_fmt_details%ROWTYPE;
263: l_res_type VARCHAR2(30);
264: l_person_name per_people_x.full_name%TYPE;
265: l_resource_id pa_resources.resource_id%TYPE;
266: l_unique_res_list VARCHAR2(30) := null;
267: --Local vars for Validate_planning_resource
268: l_resource_code VARCHAR2(30);

Line 668: * This is obtained from the per_people_x view

664: /******************************************************
665: * If the l_res_type returned = 'NAMED_PERSON' then
666: * first we need to get the value of person_name into
667: * l_person_name based on l_person_id.
668: * This is obtained from the per_people_x view
669: * Then Insert into pa_resources
670: * followed by insert into pa_resources_txn_attributes
671: ***************************************************/
672:

Line 677: FROM per_people_x

673: IF l_res_type = 'NAMED_PERSON' THEN
674: BEGIN
675: SELECT full_name
676: INTO l_person_name
677: FROM per_people_x
678: WHERE person_id = l_person_id;
679: EXCEPTION
680: WHEN OTHERS THEN
681: l_person_name := null;