APPS.GHR_GHRWS52L dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 125: l_element_entry_value_id pay_element_entry_values_f.element_entry_value_id%type;

121: l_year_degree_attained ghr_pa_requests.YEAR_DEGREE_ATTAINED%type;
122: l_prior_effective_date ghr_pa_requests.effective_date%type;
123: l_prior_loc_adj_effective_date ghr_pa_requests.effective_date%type;
124: l_session ghr_history_api.g_session_var_type;
125: l_element_entry_value_id pay_element_entry_values_f.element_entry_value_id%type;
126: l_prior_ds_effective_date ghr_pa_requests.effective_date%type;
127: ---Bug 5855843
128: l_prior_ds_effective_date_flag BOOLEAN;
129: ---Bug 5855843

Line 191: pay_element_entry_values_f eev

187: FROM pay_element_types_f elt,
188: pay_input_values_f ipv,
189: pay_element_links_f eli,
190: pay_element_entries_f ele,
191: pay_element_entry_values_f eev
192: WHERE trunc(p_pa_request_rec.effective_date) between elt.effective_start_date
193: and elt.effective_end_date
194: and trunc(p_pa_request_rec.effective_date) between ipv.effective_start_date
195: and ipv.effective_end_date

Line 229: WHERE TABLE_NAME = 'PAY_ELEMENT_ENTRY_VALUES_F'

225:
226: CURSOR c_prior_date (p_element_entry_value_id varchar2) is
227: SELECT FND_DATE.CANONICAL_TO_DATE(INFORMATION2) effective_start_date
228: FROM ghr_pa_history -- ghr_element_entry_values_h_v
229: WHERE TABLE_NAME = 'PAY_ELEMENT_ENTRY_VALUES_F'
230: AND INFORMATION1 = p_element_entry_value_id -- information1 holds element_entry_value_id
231: AND effective_date <= l_effective_date
232: AND pa_request_id not in
233: (SELECT pa_request_id