DBA Data[Home] [Help]

APPS.PAY_GB_ENROLL_INFO_GENE dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 225: from pay_element_entry_values_f peevf,

221: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.opt_in_date,screen_entry_value, null))) opt_in_date,
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 ,