[Home] [Help]
142: AND l_prp_end_date BETWEEN
143: papf.effective_start_date and papf.effective_end_date;
144:
145: cursor c_pension_info_check(p_assignment_id number) is
146: select 1 from pay_element_entries_f peef,pay_element_types_f petf where
147: peef.element_type_id = petf.element_type_id
148: and petf.element_name = 'Pensions Information'
149: and p_assignment_id = peef.assignment_id
150: AND l_prp_end_date BETWEEN
222: max(decode(trim(peevf.input_value_id),l_input_value_ids.main_entry_id,screen_entry_value, null)) main_entry,
223: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.elig_jh_date,screen_entry_value, null))) elig_jh_date,
224: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.opt_out_date,screen_entry_value, null))) opt_out_date
225: from pay_element_entry_values_f peevf,
226: pay_element_entries_f peef,
227: pay_element_types_f petf
228: where peevf.input_value_id in (l_input_value_ids.qualifying_scheme_name ,
229: --l_input_value_ids.g_agg_earnings_pensions_id ,
230: l_input_value_ids.auto_enrollment_date ,
352:
353: CURSOR C_ELEMENT_ENTRIES
354: IS
355: SELECT ELEMENT_ENTRY_ID, GREATEST(EFFECTIVE_START_DATE,l_PRP_START_DATE) START_DATE
356: FROM PAY_ELEMENT_ENTRIES_F PEEF
357: WHERE ASSIGNMENT_ID =P_ASSIGNMENT_ID
358: AND PEEF.ELEMENT_TYPE_ID in (select ELEMENT_TYPE_ID from pay_element_types_f where
359: element_name ='Pensions Information' and legislation_code ='GB')
360: AND l_PRP_START_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;