APPS.PER_PERSON_INFORMATION dependencies on PAY_PAYROLLS_F

Line 116: ,pay_payrolls_f papf

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
119: AND paf.payroll_id = papf.payroll_id (+)
120: AND paf.effective_start_date between papf.effective_start_date(+) and nvl(papf.effective_end_date,paf.effective_start_date)

Line 347: l_body := l_body || ' Payroll Details - pay_payrolls_f ';

343: -- payroll details
344: /*
345: l_body := '';
346:
347: l_body := l_body || '';
348:
349: l_body := l_body || ''
350: || ''
351: || ''

Payroll Details - pay_payrolls_f
' || 'Asg Id' || '	' || 'Effective Start Date' || '