APPS.GHR_GHRWS52L dependencies on FND_DATE

Line 222: SELECT FND_DATE.CANONICAL_TO_DATE(INFORMATION2) effective_start_date

218: -- Bug#3278827 Peformance Issue.
219: -- Modified the query. Changed the table from ghr_element_entry_values_h_v to ghr_pa_hisotry
220:
221: CURSOR c_prior_date (p_element_entry_value_id varchar2) is
222: SELECT FND_DATE.CANONICAL_TO_DATE(INFORMATION2) effective_start_date
223: FROM ghr_pa_history -- ghr_element_entry_values_h_v
224: WHERE TABLE_NAME = 'PAY_ELEMENT_ENTRY_VALUES_F'
225: AND INFORMATION1 = p_element_entry_value_id -- information1 holds element_entry_value_id
226: AND effective_date <= l_effective_date

Line 242: SELECT FND_DATE.CANONICAL_TO_DATE(INFORMATION2) effective_start_date

238: -- Bug#3278827 Peformance Issue.
239: -- Modified the query. Changed the table from ghr_assignments_h_v to ghr_pa_hisotry
240:
241: CURSOR c_prior_ds_date (p_assignment_id in number) is
242: SELECT FND_DATE.CANONICAL_TO_DATE(INFORMATION2) effective_start_date
243: FROM ghr_pa_history -- ghr_assignments_h_v
244: WHERE TABLE_NAME = 'PER_ASSIGNMENTS_F'
245: AND INFORMATION1 = to_Char(p_assignment_id) -- information1 holds assignment_id
246: AND pa_request_id not in

Line 289: BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1) ,l_effective_date)

285: FROM per_people_extra_info pei
286: WHERE pei.person_id = p_pa_request_rec.person_id
287: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
288: AND l_effective_date
289: BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1) ,l_effective_date)
290: AND NVL(fnd_date.canonical_to_date(pei.pei_information2) ,l_effective_date);
291:
292: ------------------ cursor created to handle Null Org Struct id for MRE Correction
293:

Line 290: AND NVL(fnd_date.canonical_to_date(pei.pei_information2) ,l_effective_date);

286: WHERE pei.person_id = p_pa_request_rec.person_id
287: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
288: AND l_effective_date
289: BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1) ,l_effective_date)
290: AND NVL(fnd_date.canonical_to_date(pei.pei_information2) ,l_effective_date);
291:
292: ------------------ cursor created to handle Null Org Struct id for MRE Correction
293:
294: Cursor c_pei_null_OPM(p_position_id number) is