APPS.PAY_IE_MEDICAL_ADJUST dependencies on PER_ALL_PEOPLE_F

Line 169: l_full_name per_all_people_f.full_name%TYPE;

165: l_report_item_type varchar(10) := NULL;
166: l_result_val varchar2(20);
167: l_result_val_l varchar2(20);
168: l_result_val_num number := 0;
169: l_full_name per_all_people_f.full_name%TYPE;
170: l_temp_assg_id number;
171: l_string varchar2(200);
172: counter number := 0;
173: l_assign_id varchar2(30);

Line 244: from per_all_people_f ppf,

240: -- Get person details
241: Cursor csr_person_details (p_assg_id in number) IS
242: select distinct ppf.full_name ,
243: paaf.assignment_number
244: from per_all_people_f ppf,
245: per_all_assignments_f paaf
246: where paaf.assignment_id = p_assg_id
247: and paaf.person_id = ppf.person_id
248: and l_effective_date between ppf.effective_start_date and ppf.effective_end_date;