APPS.GHR_GHRWS52L dependencies on FND_DATE

Line 227: SELECT FND_DATE.CANONICAL_TO_DATE(INFORMATION2) effective_start_date

223: -- Bug#3278827 Peformance Issue.
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

Line 247: SELECT FND_DATE.CANONICAL_TO_DATE(INFORMATION2) effective_start_date

243: -- Bug#3278827 Peformance Issue.
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

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

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

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

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

Line 713: l_scd_leave := fnd_date.canonical_to_date(p_per_scd_info.scd_leave);

709:
710: l_Second_NOAC_Lookup_code :=p_pa_request_rec.SECOND_NOA_CODE;
711: l_Service_Computation_Date :=p_pa_request_rec.SERVICE_COMP_DATE;
712: --Begin Bug# 11726461
713: l_scd_leave := fnd_date.canonical_to_date(p_per_scd_info.scd_leave);
714: l_scd_retirement := fnd_date.canonical_to_date(p_per_scd_info.scd_retirement);
715: --End Bug # 11726461
716: l_Sex :=p_personal_info.p_sex;
717: -- l_special_pay_table_id :=p_pos_valid_grade.pay_table_id; -- commented by skuttei on 17-apr-98

Line 714: l_scd_retirement := fnd_date.canonical_to_date(p_per_scd_info.scd_retirement);

710: l_Second_NOAC_Lookup_code :=p_pa_request_rec.SECOND_NOA_CODE;
711: l_Service_Computation_Date :=p_pa_request_rec.SERVICE_COMP_DATE;
712: --Begin Bug# 11726461
713: l_scd_leave := fnd_date.canonical_to_date(p_per_scd_info.scd_leave);
714: l_scd_retirement := fnd_date.canonical_to_date(p_per_scd_info.scd_retirement);
715: --End Bug # 11726461
716: l_Sex :=p_personal_info.p_sex;
717: -- l_special_pay_table_id :=p_pos_valid_grade.pay_table_id; -- commented by skuttei on 17-apr-98
718: l_staffing_differential :=p_pa_request_rec.TO_STAFFING_DIFFERENTIAL;