APPS.PAY_KR_NONSTAT_SPAY_EFILE_FUN SQL Statements

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

Line: 13

		select
			nvl(count(fue.user_entity_id),0) prev_emp_count
		from ff_Archive_items fai
			,ff_user_entities fue
		where fue.user_entity_id                   = fai.user_entity_id
			and fue.user_entity_name               = 'X_KR_PREV_BP_NUMBER'
			and fai.context1                       = p_assignment_action_id
		group by fai.context1;