APPS.GHR_GHRWS52L dependencies on GHR_PA_HISTORY

Line 228: FROM ghr_pa_history -- ghr_element_entry_values_h_v

224: -- Modified the query. Changed the table from ghr_element_entry_values_h_v to ghr_pa_hisotry
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

Line 248: FROM ghr_pa_history -- ghr_assignments_h_v

244: -- Modified the query. Changed the table from ghr_assignments_h_v to ghr_pa_hisotry
245:
246: CURSOR c_prior_ds_date (p_assignment_id in number) is
247: SELECT FND_DATE.CANONICAL_TO_DATE(INFORMATION2) effective_start_date
248: FROM ghr_pa_history -- ghr_assignments_h_v
249: WHERE TABLE_NAME = 'PER_ASSIGNMENTS_F'
250: AND INFORMATION1 = to_Char(p_assignment_id) -- information1 holds assignment_id
251: AND pa_request_id not in
252: (SELECT pa_request_id

Line 253: FROM ghr_pa_history his

249: WHERE TABLE_NAME = 'PER_ASSIGNMENTS_F'
250: AND INFORMATION1 = to_Char(p_assignment_id) -- information1 holds assignment_id
251: AND pa_request_id not in
252: (SELECT pa_request_id
253: FROM ghr_pa_history his
254: CONNECT BY his.pa_request_id = prior his.altered_pa_request_id
255: START WITH his.pa_request_id = p_pa_request_rec.altered_pa_request_id )
256: ORDER BY 1 desc;
257: -- New cursor for non correction actions