APPS.PAY_US_W2_WF dependencies on PER_ASSIGNMENTS_F

Line 85: ln_current_assignment_id per_assignments_f.assignment_id%TYPE;

81: ******************************************************************/
82: IS
83:
84: l_proc varchar2(61) := gv_package||'get_w2_notifier';
85: ln_current_assignment_id per_assignments_f.assignment_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);

Line 97: per_assignments_f paf,

93: CURSOR c_payroll_contact IS
94: select usr.employee_id,
95: paf.assignment_id
96: from pay_payrolls_f prl,
97: per_assignments_f paf,
98: fnd_user usr
99: where prl.payroll_id = paf.payroll_id
100: and usr.user_name = prl.prl_information1
101: and prl.prl_information_category = 'US'

Line 111: per_assignments_f paf,

107: CURSOR c_gre_contact IS
108: select usr.employee_id,
109: paf.assignment_id
110: from hr_organization_information org,
111: per_assignments_f paf,
112: fnd_user usr
113: where org.organization_id = (select hsc.segment1
114: from hr_soft_coding_keyflex hsc
115: where hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id)