DBA Data[Home] [Help]

APPS.PAY_US_W2_WF dependencies on PER_PEOPLE_F

Line 90: ln_curr_contact_person_id per_people_f.person_id%TYPE;

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,

Line 91: ln_next_contact_person_id per_people_f.person_id%TYPE;

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