APPS.GHR_SES_CONV_PKG dependencies on PER_PEOPLE_F

Line 137: l_name per_people_f.full_name%type;

133: --
134: l_check_date date;
135: l_log_text varchar2(2000);
136: l_from_user_tab_name pay_user_tables.user_table_name%type;
137: l_name per_people_f.full_name%type;
138: l_ssn per_people_f.national_identifier%type;
139: --
140: --
141: CURSOR cur_emp_det IS

Line 138: l_ssn per_people_f.national_identifier%type;

134: l_check_date date;
135: l_log_text varchar2(2000);
136: l_from_user_tab_name pay_user_tables.user_table_name%type;
137: l_name per_people_f.full_name%type;
138: l_ssn per_people_f.national_identifier%type;
139: --
140: --
141: CURSOR cur_emp_det IS
142: SELECT per.full_name full_name

Line 144: from per_people_f per

140: --
141: CURSOR cur_emp_det IS
142: SELECT per.full_name full_name
143: ,per.national_identifier national_identifier
144: from per_people_f per
145: ,per_assignments_f paf
146: where paf.person_id = per.person_id
147: and l_check_date
148: between paf.effective_start_date and paf.effective_end_date