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;

Line: 42

 select nvl(sep_pay_overseas_tax_break,0),
        nvl(non_stat_sep_overseas_tax_brk,0)
 from   pay_kr_sep_tax_v
 where  xassignment_action_id = p_assignment_action_id
   and  assignment_id 	      = p_assignment_id;

Line: 69

 select assignment_action_id
 from   pay_kr_sep_tax_v
 where  xassignment_action_id = p_assignment_action_id
   and  assignment_id 	      = p_assignment_id;

Line: 93

      SELECT   	nvl(to_char(fnd_date.canonical_to_date(prrv.result_value),'YYYY/MM/DD'), '0')
	FROM    pay_input_values_f       piv
	       ,pay_run_result_values    prrv
	       ,pay_run_results          prr
	       ,pay_payroll_actions      ppa
	       ,pay_assignment_actions   paa
	       ,pay_element_types_f      pet
	WHERE   paa.assignment_action_id = l_assignment_action_id
	and     ppa.payroll_action_id 	= paa.payroll_action_id
	and     prr.assignment_action_id = paa.assignment_action_id
	and     prr.status 		in ('P', 'PA')
	and     prr.element_type_id 	= pet.element_type_id
	and     pet.element_name 	= l_element_name
        and     piv.legislation_code 	= 'KR'
        and     pet.legislation_code 	= 'KR'
	and     prrv.run_result_id 	= prr.run_result_id
	and     piv.input_value_id 	= prrv.input_value_id
	and	piv.name 		= l_input_value_name
	and     ppa.effective_date
		between piv.effective_start_date and piv.effective_end_date;

Line: 141

select meaning,description into p_fin_inst_name,p_bus_reg_number from
hr_lookups where lookup_type = 'PAY_KR_PENSION_FINANCIAL_INST' and
lookup_code = p_fin_inst_code;