APPS.PAY_KR_YEA_FORM_PKG SQL Statements

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

Line: 24

      select 'Y'
      from per_assignment_extra_info
      where
         assignment_id       =  p_assignment_id and
         information_type    =  'KR_YEA_DETAIL_MEDICAL_EXP_INFO' and
         aei_information5    =  p_provider_reg_no and
         aei_information6    <>  p_provider_reg_name and
         trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =
                                trunc(p_effective_date, 'YYYY');

Line: 35

      select
         decode(aei_information7,p_relationship,'N','Y')   inv_relationship,
         decode(aei_information9,p_disabled_aged,'N','Y')  inv_aged_disabled
      from per_assignment_extra_info
      where
         assignment_id       =  p_assignment_id and
         information_type    =  'KR_YEA_DETAIL_MEDICAL_EXP_INFO' and
         aei_information8    =  p_res_reg_no and
         trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =
                                trunc(p_effective_date, 'YYYY');

Line: 47

      select aei_information24,  -- employee
	aei_information7,  -- dependent
	aei_information9,  -- aged
	aei_information8   -- disabled
      from per_assignment_extra_info pai
      where
         pai.assignment_id    = p_assignment_id and
         pai.information_type = 'KR_YEA_SP_TAX_EXEM_INFO' and
	 trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =
                               trunc(p_effective_date, 'YYYY');

Line: 59

      select aei_information3  -- card expense
      from per_assignment_extra_info pai
      where
         pai.assignment_id    = p_assignment_id and
         pai.information_type = 'KR_YEA_SP_TAX_EXEM_INFO2' and
	 trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =
                               trunc(p_effective_date, 'YYYY');

Line: 137

		select 	'Y'
		from 	per_assignment_extra_info
		where
			assignment_id       	=  p_assignment_id
			and information_type    =  'KR_YEA_DETAIL_DONATION_INFO'
			and aei_information7    =  p_recipient_reg_no
			and aei_information8    <> p_recipient_name
			and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');

Line: 147

		select 	aei_information18,  -- Statutory
			aei_information20,  -- Political
			aei_information22,  -- Specified
			aei_information23,  -- Tax Reduction Law
			aei_information30   -- ESOA
      		from 	per_assignment_extra_info pai
      		where
         		pai.assignment_id    = p_assignment_id
         		and pai.information_type = 'KR_YEA_SP_TAX_EXEM_INFO'
	 		and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =
                               trunc(p_effective_date, 'YYYY');

Line: 160

		select 	aei_information4,   -- Promotional Fund
			aei_information5,   -- Religious
			aei_information6,   -- Others
			aei_information7    -- Public Legal Entity Donation Trust -- Bug 7142612
      		from 	per_assignment_extra_info pai
      		where
         		pai.assignment_id    = p_assignment_id
         		and pai.information_type = 'KR_YEA_SP_TAX_EXEM_INFO2'
	 		and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =
                               trunc(p_effective_date, 'YYYY');

Line: 227

    select glb.global_value
    from   ff_globals_f glb
     where glb.global_name = p_glbvar
      and  l_effective_date between glb.effective_start_date and glb.effective_end_date;