APPS.PAY_US_TAX_WF SQL Statements

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

Line: 127

		select 	*
		from 	pay_stat_trans_audit
		where	stat_trans_audit_id = ln_transaction_id;

Line: 132

		select pus.state_name
		from	pay_stat_trans_audit pta
			,pay_us_states pus
		where	pta.transaction_parent_id = ln_transaction_id
		  and	pus.state_code = substr(pta.source1,1,2)
		  and exists(select 'x' from pay_us_state_tax_info_f stif
			     where stif.state_code = pus.state_code
			       and stif.sta_information7 = 'Y'
			       and pta.transaction_effective_date between
					stif.effective_start_date and
					stif.effective_end_date);

Line: 145

		select 	meaning
		from	hr_lookups
		where	lookup_type = 'US_FIT_FILING_STATUS'
		  and	lookup_code = lv_status_code;

Line: 309

	select 	/*+ ordered */ prl.prl_information1  --Bug 3361934
	from 	pay_stat_trans_audit pta
		,per_assignments_f paf
		,pay_payrolls_f prl
	where 	prl.payroll_id = paf.payroll_id
		and prl.prl_information_category = 'US'
		and paf.assignment_id = pta.assignment_id
		and pta.transaction_parent_id = ln_transaction_id
		and pta.assignment_id > ln_current_assignment_id
		and pta.transaction_effective_date between prl.effective_start_date and
							   prl.effective_end_date
		and pta.transaction_effective_date between paf.effective_start_date and
							    paf.effective_end_date
	order by pta.assignment_id asc;

Line: 325

	select 	/*+ ordered */ org.org_information1   --Bug 3361934
	from	pay_stat_trans_audit pta
	        ,per_assignments_f paf
		,hr_soft_coding_keyflex hsc
		,hr_organization_information org
	where	org.organization_id = hsc.segment1
	  and	hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
	  and	paf.assignment_id = pta.assignment_id
	  and	pta.transaction_parent_id = ln_transaction_id
	  and	org.org_information_context = 'Contact Information'
	  and	pta.assignment_id > ln_current_assignment_id
	  and	pta.transaction_effective_date between paf.effective_start_date and
		 					paf.effective_end_date
	order by pta.assignment_id asc;

Line: 454

	select 	/*+ ordered */ usr.employee_id   --Bug 3361934
		,pta.assignment_id
	from 	pay_stat_trans_audit pta
		,per_assignments_f paf
		,pay_payrolls_f prl
		,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 = pta.assignment_id
		and pta.transaction_parent_id = ln_transaction_id
		and pta.assignment_id > ln_current_assignment_id
		and pta.transaction_effective_date between prl.effective_start_date and
							   prl.effective_end_date
		and pta.transaction_effective_date between paf.effective_start_date and
							    paf.effective_end_date
	order by pta.assignment_id asc;

Line: 473

	select 	/*+ ordered */ usr.employee_id   --Bug 3361934
		,pta.assignment_id
	from	pay_stat_trans_audit pta
		,per_assignments_f paf
		,hr_soft_coding_keyflex hsc
		,hr_organization_information org
		,fnd_user usr
	where	org.organization_id = hsc.segment1
	  and	usr.user_name = org.org_information1
	  and	hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
	  and	paf.assignment_id = pta.assignment_id
	  and	pta.transaction_parent_id = ln_transaction_id
	  and	org.org_information_context = 'Contact Information'
	  and	pta.assignment_id > ln_current_assignment_id
	  and	pta.transaction_effective_date between paf.effective_start_date and
		 					paf.effective_end_date
	order by pta.assignment_id asc;

Line: 611

		select	transaction_parent_id
			,transaction_type
			,transaction_subtype
			,source1
			,source1_type
			,audit_information2
			,audit_information4
		from	pay_stat_trans_audit
		where	stat_trans_audit_id = ln_transaction_id;

Line: 622

		select 	fed_information1
		from	pay_us_federal_tax_info_f
		where	fed_information_category = 'ALLOWANCES LIMIT'
		and	trunc(sysdate) between effective_start_date and effective_end_date;