APPS.JTF_EC_WORKFLOW_PKG dependencies on PER_PEOPLE_F

Line 110: FROM per_people_f per,

106: l_api_name VARCHAR2(30) := 'Get_User_Name';
107:
108: cursor c_user_name(p_user_id IN NUMBER) is
109: SELECT per.full_name name
110: FROM per_people_f per,
111: fnd_user f
112: WHERE f.employee_id = per.person_id
113: AND f.user_id = p_user_id
114: union

Line 1030: l_user_name per_people_f.full_name%TYPE;

1026: l_itemkey wf_item_activity_statuses.item_key%TYPE;
1027: l_wf_key NUMBER;
1028: l_old_owner_id jtf_tasks_vl.owner_id%TYPE := p_old_owner_id;
1029: --l_old_owner_type_code jtf_tasks_vl.owner_type_code%TYPE := p_old_owner_type_code;
1030: l_user_name per_people_f.full_name%TYPE;
1031: l_esc_status jtf_ec_statuses_vl.description%TYPE;
1032: l_esc_level fnd_lookups.meaning%TYPE;
1033: l_temp_status VARCHAR2(1);
1034: -- l_found VARCHAR2(1) := 'x';