1054: l_new_element_name pay_element_types_f.element_name%type;
1055: l_bus_group_id per_all_people_f.business_group_id%type;
1056: l_fehb_exists BOOLEAN;
1057: l_tsp_exists BOOLEAN;
1058: l_health_plan pay_element_entry_values_f.screen_entry_value%type;
1059: l_enrollment_option pay_element_entry_values_f.screen_entry_value%type;
1060: l_pre_tax_waiver pay_element_entry_values_f.screen_entry_value%type;
1061: l_date_temp_elig date;
1062: l_tsp_status pay_element_entry_values_f.screen_entry_value%type;
1055: l_bus_group_id per_all_people_f.business_group_id%type;
1056: l_fehb_exists BOOLEAN;
1057: l_tsp_exists BOOLEAN;
1058: l_health_plan pay_element_entry_values_f.screen_entry_value%type;
1059: l_enrollment_option pay_element_entry_values_f.screen_entry_value%type;
1060: l_pre_tax_waiver pay_element_entry_values_f.screen_entry_value%type;
1061: l_date_temp_elig date;
1062: l_tsp_status pay_element_entry_values_f.screen_entry_value%type;
1063: l_tsp_status_date date;
1056: l_fehb_exists BOOLEAN;
1057: l_tsp_exists BOOLEAN;
1058: l_health_plan pay_element_entry_values_f.screen_entry_value%type;
1059: l_enrollment_option pay_element_entry_values_f.screen_entry_value%type;
1060: l_pre_tax_waiver pay_element_entry_values_f.screen_entry_value%type;
1061: l_date_temp_elig date;
1062: l_tsp_status pay_element_entry_values_f.screen_entry_value%type;
1063: l_tsp_status_date date;
1064: l_agency_contrib_date date;
1058: l_health_plan pay_element_entry_values_f.screen_entry_value%type;
1059: l_enrollment_option pay_element_entry_values_f.screen_entry_value%type;
1060: l_pre_tax_waiver pay_element_entry_values_f.screen_entry_value%type;
1061: l_date_temp_elig date;
1062: l_tsp_status pay_element_entry_values_f.screen_entry_value%type;
1063: l_tsp_status_date date;
1064: l_agency_contrib_date date;
1065: l_second_noa_code ghr_pa_requests.second_noa_code%type;
1066:
1110: f.screen_entry_value screen_entry_value
1111: FROM pay_element_types_f a,
1112: pay_input_values_f b,
1113: pay_element_entries_f e,
1114: pay_element_entry_values_f f
1115: WHERE a.element_type_id = b.element_type_id AND
1116: e.element_type_id = a.element_type_id AND
1117: f.element_entry_id = e.element_entry_id AND
1118: f.input_value_id = b.input_value_id AND