APPS.BEN_CWB_AUDIT_API dependencies on BEN_CWB_PERSON_INFO

Line 157: from ben_cwb_person_info empinfo

153: 'CN', empinfo.custom_name,
154: empinfo.full_name
155: )
156: into l_old_ws_mgr_name
157: from ben_cwb_person_info empinfo
158: where empinfo.group_per_in_ler_id = p_per_record_old.ws_mgr_id;
159: exception
160: when no_data_found then
161: l_old_ws_mgr_name := p_per_record_old.ws_mgr_id;

Line 171: from ben_cwb_person_info empinfo

167: 'CN', empinfo.custom_name,
168: empinfo.full_name
169: )
170: into l_new_ws_mgr_name
171: from ben_cwb_person_info empinfo
172: where empinfo.group_per_in_ler_id = l_per_record_new.ws_mgr_id;
173: exception
174: when no_data_found then
175: l_new_ws_mgr_name := l_per_record_new.ws_mgr_id;

Line 295: l_old_ws_mgr_name ben_cwb_person_info.full_name%type;

291: ) is
292: --
293: l_proc varchar2(72) := g_package||'update_per_record';
294: l_ws_mgr_id ben_per_in_ler.ws_mgr_id%type;
295: l_old_ws_mgr_name ben_cwb_person_info.full_name%type;
296: l_new_ws_mgr_name ben_cwb_person_info.full_name%type;
297: l_per_record_new ben_per_in_ler%rowtype;
298: l_person_id fnd_user.employee_id%type;
299: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;

Line 296: l_new_ws_mgr_name ben_cwb_person_info.full_name%type;

292: --
293: l_proc varchar2(72) := g_package||'update_per_record';
294: l_ws_mgr_id ben_per_in_ler.ws_mgr_id%type;
295: l_old_ws_mgr_name ben_cwb_person_info.full_name%type;
296: l_new_ws_mgr_name ben_cwb_person_info.full_name%type;
297: l_per_record_new ben_per_in_ler%rowtype;
298: l_person_id fnd_user.employee_id%type;
299: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
300: l_object_version_number ben_cwb_audit.object_version_number%type;