DBA Data[Home] [Help]

APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1196: l_health_plan pay_element_entry_values_f.screen_entry_value%type;

1192: l_new_element_name pay_element_types_f.element_name%type;
1193: l_bus_group_id per_all_people_f.business_group_id%type;
1194: l_fehb_exists BOOLEAN;
1195: l_tsp_exists BOOLEAN;
1196: l_health_plan pay_element_entry_values_f.screen_entry_value%type;
1197: l_enrollment_option pay_element_entry_values_f.screen_entry_value%type;
1198: l_pre_tax_waiver pay_element_entry_values_f.screen_entry_value%type;
1199: l_date_temp_elig date;
1200: l_tsp_status pay_element_entry_values_f.screen_entry_value%type;

Line 1197: l_enrollment_option pay_element_entry_values_f.screen_entry_value%type;

1193: l_bus_group_id per_all_people_f.business_group_id%type;
1194: l_fehb_exists BOOLEAN;
1195: l_tsp_exists BOOLEAN;
1196: l_health_plan pay_element_entry_values_f.screen_entry_value%type;
1197: l_enrollment_option pay_element_entry_values_f.screen_entry_value%type;
1198: l_pre_tax_waiver pay_element_entry_values_f.screen_entry_value%type;
1199: l_date_temp_elig date;
1200: l_tsp_status pay_element_entry_values_f.screen_entry_value%type;
1201: l_tsp_status_date date;

Line 1198: l_pre_tax_waiver pay_element_entry_values_f.screen_entry_value%type;

1194: l_fehb_exists BOOLEAN;
1195: l_tsp_exists BOOLEAN;
1196: l_health_plan pay_element_entry_values_f.screen_entry_value%type;
1197: l_enrollment_option pay_element_entry_values_f.screen_entry_value%type;
1198: l_pre_tax_waiver pay_element_entry_values_f.screen_entry_value%type;
1199: l_date_temp_elig date;
1200: l_tsp_status pay_element_entry_values_f.screen_entry_value%type;
1201: l_tsp_status_date date;
1202: l_agency_contrib_date date;

Line 1200: l_tsp_status pay_element_entry_values_f.screen_entry_value%type;

1196: l_health_plan pay_element_entry_values_f.screen_entry_value%type;
1197: l_enrollment_option pay_element_entry_values_f.screen_entry_value%type;
1198: l_pre_tax_waiver pay_element_entry_values_f.screen_entry_value%type;
1199: l_date_temp_elig date;
1200: l_tsp_status pay_element_entry_values_f.screen_entry_value%type;
1201: l_tsp_status_date date;
1202: l_agency_contrib_date date;
1203: l_second_noa_code ghr_pa_requests.second_noa_code%type;
1204: --8793163

Line 1256: pay_element_entry_values_f f

1252: f.screen_entry_value screen_entry_value
1253: FROM pay_element_types_f a,
1254: pay_input_values_f b,
1255: pay_element_entries_f e,
1256: pay_element_entry_values_f f
1257: WHERE a.element_type_id = b.element_type_id AND
1258: e.element_type_id = a.element_type_id AND
1259: f.element_entry_id = e.element_entry_id AND
1260: f.input_value_id = b.input_value_id AND