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 528: /* removing because now receiving person_id from fnd_user.employee_id

524: if g_debug then
525: hr_utility.set_location('Entering:'|| l_proc, 10);
526: end if;
527:
528: /* removing because now receiving person_id from fnd_user.employee_id
529: begin
530: select person_id into l_change_made_by_person_id
531: from fnd_user fnduser, per_all_people_f per
532: where p_change_made_by_person_id=fnduser.user_id (+)

Line 531: from fnd_user fnduser, per_all_people_f per

527:
528: /* removing because now receiving person_id from fnd_user.employee_id
529: begin
530: select person_id into l_change_made_by_person_id
531: from fnd_user fnduser, per_all_people_f per
532: where p_change_made_by_person_id=fnduser.user_id (+)
533: and fnduser.person_party_id = per.party_id (+)
534: and ((nvl(p_change_made_by_person_id, -1) = -1) or
535: (p_date_stamp between per.effective_start_date and per.effective_end_date));

Line 729: from fnd_user fnduser, per_all_people_f per

725: begin
726: /*
727: begin
728: select person_id into l_change_made_by_person_id
729: from fnd_user fnduser, per_all_people_f per
730: where p_change_made_by_person_id=fnduser.user_id (+)
731: and fnduser.person_party_id = per.party_id (+)
732: and ((nvl(p_change_made_by_person_id, -1) = -1) or
733: (p_date_stamp between per.effective_start_date and per.effective_end_date));