APPS.PA_RESOURCE_UTILS dependencies on PER_PEOPLE_F

Line 1687: FROM per_people_f

1683: BEGIN
1684:
1685: SELECT 'Y'
1686: INTO v_validated
1687: FROM per_people_f
1688: WHERE person_id = x_personId
1689: AND trunc(sysdate) BETWEEN effective_start_date
1690: AND NVL(effective_end_date,sysdate + 1)
1691: AND rownum = 1;

Line 3512: from per_people_f per,

3508:
3509: cursor get_person_type
3510: is
3511: select person_id
3512: from per_people_f per,
3513: per_person_types ptype
3514: where per.person_id = p_person_id
3515: and per.person_type_id = ptype.person_type_id
3516: and (ptype.system_person_type = 'EMP'

Line 4308: x_ManagerId PER_PEOPLE_F.PERSON_ID%TYPE := null;

4304: p_start_date IN DATE DEFAULT NULL) --Bug 4473484
4305: RETURN NUMBER
4306: IS
4307:
4308: x_ManagerId PER_PEOPLE_F.PERSON_ID%TYPE := null;
4309: l_manager_start_date DATE := null;
4310: v_return_status VARCHAR2(1);
4311: v_personid NUMBER;
4312: v_error_message_code fnd_new_messages.message_name%TYPE;