86: lv_contact_source VARCHAR2(50);
87: lv_curr_contact_user VARCHAR2(100);
88: lv_next_contact_user VARCHAR2(100);
89: lv_dummy VARCHAR2(100);
90: ln_curr_contact_person_id per_people_f.person_id%TYPE;
91: ln_next_contact_person_id per_people_f.person_id%TYPE;
92:
93: CURSOR c_payroll_contact IS
94: select usr.employee_id,
87: lv_curr_contact_user VARCHAR2(100);
88: lv_next_contact_user VARCHAR2(100);
89: lv_dummy VARCHAR2(100);
90: ln_curr_contact_person_id per_people_f.person_id%TYPE;
91: ln_next_contact_person_id per_people_f.person_id%TYPE;
92:
93: CURSOR c_payroll_contact IS
94: select usr.employee_id,
95: paf.assignment_id