DBA Data[Home] [Help]

APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1058: l_health_plan pay_element_entry_values_f.screen_entry_value%type;

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;

Line 1059: l_enrollment_option 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;

Line 1060: l_pre_tax_waiver pay_element_entry_values_f.screen_entry_value%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;
1064: l_agency_contrib_date date;

Line 1062: l_tsp_status pay_element_entry_values_f.screen_entry_value%type;

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:

Line 1114: pay_element_entry_values_f f

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