APPS.PAY_IE_RULES SQL Statements

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

Line: 38

		SELECT to_number(scl.segment4)
		from    per_all_assignments_f asg,
			pay_all_payrolls_f papf,
			hr_soft_coding_keyflex scl
		where	asg.business_group_id = papf.business_group_id
		and	papf.payroll_id = asg.payroll_id
		and	asg.assignment_id = l_assignment_id
		and	l_effective_date between asg.effective_start_date and asg.effective_end_date
		and	l_effective_date between papf.effective_start_date and papf.effective_end_date
		and	papf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;