APPS.PER_PERSON_INFORMATION dependencies on PER_ASSIGNMENTS_F

Line 114: FROM per_assignments_f paf

110: ,'B','Benefits'
111: ,'E','Employee') AsGType
112: ,paf.payroll_id p_id
113: ,papf.payroll_name Pay_Name
114: FROM per_assignments_f paf
115: ,per_assignment_status_types past
116: ,pay_payrolls_f papf
117: WHERE paf.person_id = p_person_id
118: AND past.assignment_status_type_id = paf.assignment_status_type_id

Line 267: l_body := l_body || ' Assignment Details - per_assignments_f ';

263: -- assignment information
264: l_body := '';
265:
266:
267: l_body := l_body || '';
268:
269:
270: l_body := l_body || ''
271: || ''

Assignment Details - per_assignments_f

' || 'Asg No' || '