DBA Data[Home] [Help]

APPS.PAY_GB_ENROLL_INFO_GENE dependencies on HR_GENERAL

Line 215: max(decode(trim(peevf.input_value_id),l_input_value_ids.pension_classification,hr_general.decode_lookup('GB_PENSION_WORKER_TYPES',screen_entry_value), null)) pension_classification,

211: IS
212: SELECT max(decode(trim(peevf.input_value_id),l_input_value_ids.qualifying_scheme_name,screen_entry_value, null)) qualifying_scheme_name,
213: max(decode(trim(peevf.input_value_id),l_input_value_ids.agg_earnings_pensions_id,screen_entry_value, null)) agg_earnings,
214: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.auto_enrollment_date,screen_entry_value, null))) auto_enrollment_date ,
215: max(decode(trim(peevf.input_value_id),l_input_value_ids.pension_classification,hr_general.decode_lookup('GB_PENSION_WORKER_TYPES',screen_entry_value), null)) pension_classification,
216: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.opt_out_period_end_date,screen_entry_value, null))) opt_out_period_end_date,
217: max(decode(trim(peevf.input_value_id),l_input_value_ids.total_earning_prp,screen_entry_value, null)) total_earning_prp,
218: max(decode(trim(peevf.input_value_id),l_input_value_ids.postponement_type,hr_general.decode_lookup('GB_PENSION_POSTPONEMENT_TYPES',screen_entry_value), null)) postponement_type ,
219: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.postponement_end_date,screen_entry_value, null))) postponement_end_date,

Line 218: max(decode(trim(peevf.input_value_id),l_input_value_ids.postponement_type,hr_general.decode_lookup('GB_PENSION_POSTPONEMENT_TYPES',screen_entry_value), null)) postponement_type ,

214: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.auto_enrollment_date,screen_entry_value, null))) auto_enrollment_date ,
215: max(decode(trim(peevf.input_value_id),l_input_value_ids.pension_classification,hr_general.decode_lookup('GB_PENSION_WORKER_TYPES',screen_entry_value), null)) pension_classification,
216: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.opt_out_period_end_date,screen_entry_value, null))) opt_out_period_end_date,
217: max(decode(trim(peevf.input_value_id),l_input_value_ids.total_earning_prp,screen_entry_value, null)) total_earning_prp,
218: max(decode(trim(peevf.input_value_id),l_input_value_ids.postponement_type,hr_general.decode_lookup('GB_PENSION_POSTPONEMENT_TYPES',screen_entry_value), null)) postponement_type ,
219: fnd_date.canonical_to_date(max(decode(trim(peevf.input_value_id),l_input_value_ids.postponement_end_date,screen_entry_value, null))) postponement_end_date,
220: max(decode(trim(peevf.input_value_id),l_input_value_ids.qualifying_scheme_exists,screen_entry_value, null)) qualifying_scheme_exists,
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,