380: lv_contact_source VARCHAR2(50);
381: ln_transaction_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
382: ln_current_assignment_id per_assignments_f.assignment_id%TYPE;
383: lv_contact_user_name VARCHAR2(150);
384: ln_contact_person_id per_people_f.person_id%TYPE;
385: ln_employee_person_id per_people_f.person_id%TYPE;
386:
387: -- get the payroll contact
388:
381: ln_transaction_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
382: ln_current_assignment_id per_assignments_f.assignment_id%TYPE;
383: lv_contact_user_name VARCHAR2(150);
384: ln_contact_person_id per_people_f.person_id%TYPE;
385: ln_employee_person_id per_people_f.person_id%TYPE;
386:
387: -- get the payroll contact
388:
389: CURSOR c_payroll_contact IS
558: lv_contact_source VARCHAR2(50);
559: lv_curr_contact_user VARCHAR2(100);
560: lv_next_contact_user VARCHAR2(100);
561: lv_dummy VARCHAR2(100);
562: ln_curr_contact_person_id per_people_f.person_id%TYPE;
563: ln_next_contact_person_id per_people_f.person_id%TYPE;
564:
565: CURSOR c_payroll_contact IS
566: select /*+ ordered */ usr.employee_id --Bug 3362223
559: lv_curr_contact_user VARCHAR2(100);
560: lv_next_contact_user VARCHAR2(100);
561: lv_dummy VARCHAR2(100);
562: ln_curr_contact_person_id per_people_f.person_id%TYPE;
563: ln_next_contact_person_id per_people_f.person_id%TYPE;
564:
565: CURSOR c_payroll_contact IS
566: select /*+ ordered */ usr.employee_id --Bug 3362223
567: ,pta.assignment_id