DBA Data[Home] [Help]

APPS.BEN_PROCESS_COBRA_PERSON_SS dependencies on PER_ALL_PEOPLE_F

Line 27: l_full_name per_all_people_f.full_name%type;

23: IS
24: --
25: l_effective_start_date date default null;
26: l_effective_end_date date default null;
27: l_full_name per_all_people_f.full_name%type;
28: l_comment_id per_all_people_f.comment_id%type;
29: l_name_combination_warning boolean default null;
30: l_assign_payroll_warning boolean default null;
31: l_orig_hire_warning boolean default null;

Line 28: l_comment_id per_all_people_f.comment_id%type;

24: --
25: l_effective_start_date date default null;
26: l_effective_end_date date default null;
27: l_full_name per_all_people_f.full_name%type;
28: l_comment_id per_all_people_f.comment_id%type;
29: l_name_combination_warning boolean default null;
30: l_assign_payroll_warning boolean default null;
31: l_orig_hire_warning boolean default null;
32: l_employee_number per_all_people_f.employee_number%type

Line 32: l_employee_number per_all_people_f.employee_number%type

28: l_comment_id per_all_people_f.comment_id%type;
29: l_name_combination_warning boolean default null;
30: l_assign_payroll_warning boolean default null;
31: l_orig_hire_warning boolean default null;
32: l_employee_number per_all_people_f.employee_number%type
33: := hr_api.g_varchar2;
34: l_ovn number default null;
35: l_person_id per_all_people_f.person_id%type
36: default null;

Line 35: l_person_id per_all_people_f.person_id%type

31: l_orig_hire_warning boolean default null;
32: l_employee_number per_all_people_f.employee_number%type
33: := hr_api.g_varchar2;
34: l_ovn number default null;
35: l_person_id per_all_people_f.person_id%type
36: default null;
37:
38: --Start Registration
39:

Line 898: l_full_name per_all_people_f.full_name%type default null;

894: l_result varchar2(50);
895: l_per_ovn number default null;
896: l_employee_number number default null;
897: l_asg_ovn number default null;
898: l_full_name per_all_people_f.full_name%type default null;
899: l_person_id number;
900: l_assignment_id number;
901: l_per_effective_start_date date;
902: l_asg_effective_end_date date;