APPS.BEN_CWB_AUDIT_API dependencies on FND_USER

Line 29: l_person_id fnd_user.employee_id%type;

25: l_creation_date ben_per_in_ler.creation_date%type;
26: l_last_updated_by ben_per_in_ler.last_updated_by%type;
27: l_change_made_by_person_id ben_cwb_audit.change_made_by_person_id%type;
28: l_group_pl_id ben_cwb_audit.group_pl_id%type;
29: l_person_id fnd_user.employee_id%type;
30:
31: begin
32: if g_debug then
33: hr_utility.set_location('Entering:'|| l_proc, 100);

Line 51: from fnd_user

47:
48: -- if record exists
49:
50: select employee_id into l_person_id
51: from fnd_user
52: where user_id = l_last_updated_by;
53:
54: if(ben_cwb_audit_api.return_lookup_validity('BG')=true) then
55: ben_cwb_audit_api.create_audit_entry

Line 116: l_person_id fnd_user.employee_id%type;

112: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
113: l_object_version_number ben_cwb_audit.object_version_number%type;
114: l_proc varchar2(72) := g_package||'update_per_record';
115: l_per_record_new ben_per_in_ler%rowtype;
116: l_person_id fnd_user.employee_id%type;
117:
118: begin
119: if g_debug then
120: hr_utility.set_location('Entering:'|| l_proc, 100);

Line 133: from fnd_user

129:
130: -- if record exists
131:
132: select employee_id into l_person_id
133: from fnd_user
134: where user_id = l_per_record_new.last_updated_by;
135:
136: if g_debug then
137: hr_utility.set_location('Record exists for per_in_ler_id: '|| l_per_record_new.per_in_ler_id, 10);

Line 298: l_person_id fnd_user.employee_id%type;

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;
301: l_personid ben_per_in_ler.ws_mgr_id%type;
302:

Line 330: from fnd_user

326:
327: -- if record exists
328:
329: select employee_id into l_person_id
330: from fnd_user
331: where user_id = l_per_record_new.last_updated_by;
332:
333: if g_debug then
334: hr_utility.set_location

Line 499: /* removing because now receiving person_id from fnd_user.employee_id

495: if g_debug then
496: hr_utility.set_location('Entering:'|| l_proc, 10);
497: end if;
498:
499: /* removing because now receiving person_id from fnd_user.employee_id
500: begin
501: select person_id into l_change_made_by_person_id
502: from fnd_user fnduser, per_all_people_f per
503: where p_change_made_by_person_id=fnduser.user_id (+)

Line 502: from fnd_user fnduser, per_all_people_f per

498:
499: /* removing because now receiving person_id from fnd_user.employee_id
500: begin
501: select person_id into l_change_made_by_person_id
502: from fnd_user fnduser, per_all_people_f per
503: where p_change_made_by_person_id=fnduser.user_id (+)
504: and fnduser.person_party_id = per.party_id (+)
505: and ((nvl(p_change_made_by_person_id, -1) = -1) or
506: (p_date_stamp between per.effective_start_date and per.effective_end_date));

Line 700: from fnd_user fnduser, per_all_people_f per

696: begin
697: /*
698: begin
699: select person_id into l_change_made_by_person_id
700: from fnd_user fnduser, per_all_people_f per
701: where p_change_made_by_person_id=fnduser.user_id (+)
702: and fnduser.person_party_id = per.party_id (+)
703: and ((nvl(p_change_made_by_person_id, -1) = -1) or
704: (p_date_stamp between per.effective_start_date and per.effective_end_date));