APPS.JTF_EC_UTIL dependencies on PER_ALL_PEOPLE_F

Line 1112: FROM per_all_people_f

1108: WHERE p_contact_id IN (party_id, subject_party_id);
1109:
1110: cursor get_emp_name (p_contact_id NUMBER) Is
1111: SELECT full_name
1112: FROM per_all_people_f
1113: WHERE person_id = p_contact_id
1114: AND SYSDATE >= NVL(effective_start_date,SYSDATE)
1115: AND SYSDATE <= NVL(effective_end_date,SYSDATE);
1116:

Line 1120: l_requester_name PER_ALL_PEOPLE_F.FULL_NAME%type :=NULL; --Bug 2700953

1116:
1117:
1118: l_contact_id NUMBER;
1119: l_contact_type_code VARCHAR2(30);
1120: l_requester_name PER_ALL_PEOPLE_F.FULL_NAME%type :=NULL; --Bug 2700953
1121:
1122: Begin
1123:
1124: open get_requester_details(p_escalation_id);