APPS.PAY_US_W2_WF SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 94

	select 	usr.employee_id,
	        paf.assignment_id
	from 	pay_payrolls_f prl,
	        per_assignments_f paf,
		fnd_user usr
	where 	prl.payroll_id = paf.payroll_id
	    and usr.user_name = prl.prl_information1
	    and prl.prl_information_category = 'US'
	    and paf.assignment_id = ln_current_assignment_id
	    and sysdate between prl.effective_start_date and prl.effective_end_date
	    and sysdate between paf.effective_start_date and paf.effective_end_date
	order by paf.assignment_id asc;

Line: 108

	select 	usr.employee_id,
	        paf.assignment_id
	from	hr_organization_information org,
	        per_assignments_f paf,
	        fnd_user usr
	where	org.organization_id = (select hsc.segment1
                                       from hr_soft_coding_keyflex hsc
                                       where hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id)
	  and	usr.user_name = org.org_information1
	  and	paf.assignment_id = ln_current_assignment_id
	  and	org.org_information_context = 'Contact Information'
	  and	sysdate between paf.effective_start_date and paf.effective_end_date
	order by paf.assignment_id asc;