APPS.GHR_CORR_CANC_SF52 dependencies on FND_DATE

Line 3962: l_value1 := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_value1));

3958: l_value1 := p_hist_pre.information6;
3959: hr_utility.set_location('l_value1: ' || l_value1 || l_proc, 38);
3960: FOR c_ipv_rec IN c_ipv(l_element_name,l_ipv_name,l_eff_date,ll_bg_id) LOOP
3961: IF c_ipv_rec.uom = 'D' THEN
3962: l_value1 := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_value1));
3963: hr_utility.set_location('l_value1: ' || l_value1 || l_proc, 38);
3964: END IF;
3965: END LOOP;
3966: ---*****************************************************************************

Line 6430: AND effective_start_date BETWEEN fnd_date.canonical_to_date(p_hist_rec.information2)

6426: hr_utility.set_location(' Inside Future Other Pay Exists',20);
6427: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;
6428: DELETE pay_element_entry_values_f
6429: where element_entry_id = p_hist_rec.information1
6430: AND effective_start_date BETWEEN fnd_date.canonical_to_date(p_hist_rec.information2)
6431: AND (l_future_othpay_effective_date - 1) ;
6432:
6433: hr_utility.set_location(' After deleting Other pay element entries',30);
6434: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;

Line 6437: AND effective_start_date BETWEEN fnd_date.canonical_to_date(p_hist_rec.information2)

6433: hr_utility.set_location(' After deleting Other pay element entries',30);
6434: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;
6435: DELETE PAY_ELEMENT_ENTRIES_F
6436: where element_entry_id = p_hist_rec.information1
6437: AND effective_start_date BETWEEN fnd_date.canonical_to_date(p_hist_rec.information2)
6438: AND (l_future_othpay_effective_date - 1) ;
6439:
6440: -- DELETE THE HISTORY RECORDS with the same element entry ID created after the current
6441: -- action and prior to the next other pay action.

Line 6445: AND effective_date BETWEEN (fnd_date.canonical_to_date(p_hist_rec.information2) + 1)

6441: -- action and prior to the next other pay action.
6442: DELETE ghr_pa_history
6443: WHERE (information5 = p_hist_rec.information1
6444: OR information1 = p_hist_rec.information1)
6445: AND effective_date BETWEEN (fnd_date.canonical_to_date(p_hist_rec.information2) + 1)
6446: AND (l_future_othpay_effective_date - 1);
6447:
6448: ELSE
6449: hr_utility.set_location(' No Future Other Pay Action exists.',40);

Line 6463: AND effective_date > (fnd_date.canonical_to_date(p_hist_rec.information2) + 1);

6459: -- DELETE THE HISTORY RECORDS with the same element entry ID created after the
6460: -- current other pay action.
6461: DELETE ghr_pa_history
6462: WHERE (information5 = p_hist_rec.information1 OR information1 = p_hist_rec.information1)
6463: AND effective_date > (fnd_date.canonical_to_date(p_hist_rec.information2) + 1);
6464:
6465: END IF;
6466: END IF;
6467: ELSIF l_element_name IN ('Retention Allowance','Supervisory Differential','AUO',

Line 6473: -- AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);

6469: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;
6470:
6471: DELETE pay_element_entry_values_f
6472: where element_entry_id = p_hist_rec.information1;
6473: -- AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);
6474:
6475: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;
6476:
6477: DELETE PAY_ELEMENT_ENTRIES_F

Line 6479: -- AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);

6475: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;
6476:
6477: DELETE PAY_ELEMENT_ENTRIES_F
6478: where element_entry_id = p_hist_rec.information1;
6479: -- AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);
6480:
6481: hr_utility.set_location('Leaving delete_other_pay_entries',170);
6482: ELSE
6483: hr_utility.set_location('Elements Other than OTHER PAY '||p_element_name,110);

Line 6489: AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);

6485: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;
6486:
6487: DELETE pay_element_entry_values_f
6488: where element_entry_id = p_hist_rec.information1
6489: AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);
6490:
6491: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;
6492:
6493: DELETE PAY_ELEMENT_ENTRIES_F

Line 6495: AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);

6491: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;
6492:
6493: DELETE PAY_ELEMENT_ENTRIES_F
6494: where element_entry_id = p_hist_rec.information1
6495: AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);
6496:
6497: hr_utility.set_location('Leaving delete_other_pay_entries',70);
6498: END IF;
6499: