APPS.PAY_US_TAX_WF dependencies on PER_PEOPLE_F

Line 305: ln_contact_person_id per_people_f.person_id%TYPE;

301: lv_contact_source VARCHAR2(50);
302: ln_transaction_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
303: ln_current_assignment_id per_assignments_f.assignment_id%TYPE;
304: lv_contact_user_name VARCHAR2(150);
305: ln_contact_person_id per_people_f.person_id%TYPE;
306: ln_employee_person_id per_people_f.person_id%TYPE;
307:
308: CURSOR c_payroll_contact IS
309: select /*+ ordered */ prl.prl_information1 --Bug 3361934

Line 306: ln_employee_person_id per_people_f.person_id%TYPE;

302: ln_transaction_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
303: ln_current_assignment_id per_assignments_f.assignment_id%TYPE;
304: lv_contact_user_name VARCHAR2(150);
305: ln_contact_person_id per_people_f.person_id%TYPE;
306: ln_employee_person_id per_people_f.person_id%TYPE;
307:
308: CURSOR c_payroll_contact IS
309: select /*+ ordered */ prl.prl_information1 --Bug 3361934
310: from pay_stat_trans_audit pta

Line 450: ln_curr_contact_person_id per_people_f.person_id%TYPE;

446: lv_contact_source VARCHAR2(50);
447: lv_curr_contact_user VARCHAR2(100);
448: lv_next_contact_user VARCHAR2(100);
449: lv_dummy VARCHAR2(100);
450: ln_curr_contact_person_id per_people_f.person_id%TYPE;
451: ln_next_contact_person_id per_people_f.person_id%TYPE;
452:
453: CURSOR c_payroll_contact IS
454: select /*+ ordered */ usr.employee_id --Bug 3361934

Line 451: ln_next_contact_person_id per_people_f.person_id%TYPE;

447: lv_curr_contact_user VARCHAR2(100);
448: lv_next_contact_user VARCHAR2(100);
449: lv_dummy VARCHAR2(100);
450: ln_curr_contact_person_id per_people_f.person_id%TYPE;
451: ln_next_contact_person_id per_people_f.person_id%TYPE;
452:
453: CURSOR c_payroll_contact IS
454: select /*+ ordered */ usr.employee_id --Bug 3361934
455: ,pta.assignment_id