APPS.HR_APPROVAL_WF dependencies on PER_ASSIGNMENTS_F

Line 13: from per_assignments_f paf

9: -- returns the supervisor id for the person id passed into the cursor.
10: cursor g_csr_pa(l_effective_date in date
11: ,l_in_person_id in per_people_f.person_id%type) is
12: select ppf.person_id
13: from per_assignments_f paf
14: ,per_people_f ppf
15: where paf.person_id = l_in_person_id
16: and paf.primary_flag = 'Y'
17: and (paf.assignment_type = 'E' and ppf.current_employee_flag = 'Y'

Line 205: l_candidate_assignment_id per_assignments_f.assignment_id%type;

201: l_person_id per_people_f.person_id%type;
202: l_creator_person_id per_people_f.person_id%type;
203: l_creator_username wf_users.name%type;
204: l_creator_disp_name wf_users.display_name%type;
205: l_candidate_assignment_id per_assignments_f.assignment_id%type;
206: l_candidate_person_id per_people_f.person_id%type;
207: l_candidate_disp_name wf_users.display_name%type;
208: l_candidate_appl_number per_people_f.applicant_number%type;
209: l_fwd_from_username wf_users.name%type;