APPS.PA_RESOURCE_UTILS dependencies on PER_PEOPLE_F

Line 1799: FROM per_people_f

1795: BEGIN
1796:
1797: SELECT 'Y'
1798: INTO v_validated
1799: FROM per_people_f
1800: WHERE person_id = x_personId
1801: AND trunc(sysdate) BETWEEN effective_start_date
1802: AND NVL(effective_end_date,sysdate + 1)
1803: AND rownum = 1;

Line 3848: from per_people_f per,

3844:
3845: cursor get_person_type
3846: is
3847: select person_id
3848: from per_people_f per,
3849: per_person_types ptype
3850: where per.person_id = p_person_id
3851: and per.person_type_id = ptype.person_type_id
3852: and (ptype.system_person_type = 'EMP'

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

4640: p_start_date IN DATE DEFAULT NULL) --Bug 4473484
4641: RETURN NUMBER
4642: IS
4643:
4644: x_ManagerId PER_PEOPLE_F.PERSON_ID%TYPE := null;
4645: l_manager_start_date DATE := null;
4646: v_return_status VARCHAR2(1);
4647: v_personid NUMBER;
4648: v_error_message_code fnd_new_messages.message_name%TYPE;