4071: l_proc varchar2(80);
4072: lv_contact_source VARCHAR2(50);
4073: ln_current_assignment_id per_assignments_f.assignment_id%TYPE;
4074: lv_contact_user_name VARCHAR2(150);
4075: ln_contact_person_id per_people_f.person_id%TYPE;
4076: ln_employee_person_id per_people_f.person_id%TYPE;
4077:
4078: -- get the payroll contact
4079:
4072: lv_contact_source VARCHAR2(50);
4073: ln_current_assignment_id per_assignments_f.assignment_id%TYPE;
4074: lv_contact_user_name VARCHAR2(150);
4075: ln_contact_person_id per_people_f.person_id%TYPE;
4076: ln_employee_person_id per_people_f.person_id%TYPE;
4077:
4078: -- get the payroll contact
4079:
4080: CURSOR c_payroll_contact IS