APPS.PAY_AU_DLEC dependencies on PER_ALL_PEOPLE_F

Line 74: full_name per_all_people_f.full_name%type

70: prev_segment1 hr_soft_coding_keyflex.segment1%type,
71: seg1_name hr_organization_units.name%type,
72: seg1_prev_name hr_organization_units.name%type,
73: person_id per_all_assignments_f.person_id%type,
74: full_name per_all_people_f.full_name%type
75: );
76:
77: type l_asg_table_def is table of l_asg_rec
78: index by binary_integer;

Line 192: from per_all_people_f per

188: -- Get the persons full name.
189:
190: select per.full_name
191: into l_asg_tab(i).full_name
192: from per_all_people_f per
193: where per.person_id = l_asg_tab(i).person_id
194: and l_fin_year_end between per.effective_start_date and per.effective_end_date;
195:
196: -- Output the line.