APPS.GHR_CORR_CANC_SF52 dependencies on FND_DATE

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

4266: l_value1 := p_hist_pre.information6;
4267: hr_utility.set_location('l_value1: ' || l_value1 || l_proc, 38);
4268: FOR c_ipv_rec IN c_ipv(l_element_name,l_ipv_name,l_eff_date,ll_bg_id) LOOP
4269: IF c_ipv_rec.uom = 'D' THEN
4270: l_value1 := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_value1));
4271: hr_utility.set_location('l_value1: ' || l_value1 || l_proc, 38);
4272: END IF;
4273: END LOOP;
4274: ---*****************************************************************************

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

6781: hr_utility.set_location(' Inside Future Other Pay Exists',20);
6782: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;
6783: DELETE pay_element_entry_values_f
6784: where element_entry_id = p_hist_rec.information1
6785: AND effective_start_date BETWEEN fnd_date.canonical_to_date(p_hist_rec.information2)
6786: AND (l_future_othpay_effective_date - 1) ;
6787:
6788: hr_utility.set_location(' After deleting Other pay element entries',30);
6789: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;

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

6788: hr_utility.set_location(' After deleting Other pay element entries',30);
6789: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;
6790: DELETE PAY_ELEMENT_ENTRIES_F
6791: where element_entry_id = p_hist_rec.information1
6792: AND effective_start_date BETWEEN fnd_date.canonical_to_date(p_hist_rec.information2)
6793: AND (l_future_othpay_effective_date - 1) ;
6794:
6795: -- DELETE THE HISTORY RECORDS with the same element entry ID created after the current
6796: -- action and prior to the next other pay action.

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

6796: -- action and prior to the next other pay action.
6797: DELETE ghr_pa_history
6798: WHERE (information5 = p_hist_rec.information1
6799: OR information1 = p_hist_rec.information1)
6800: AND effective_date BETWEEN (fnd_date.canonical_to_date(p_hist_rec.information2) + 1)
6801: AND (l_future_othpay_effective_date - 1);
6802:
6803: ELSE
6804: hr_utility.set_location(' No Future Other Pay Action exists.',40);

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

6814: -- DELETE THE HISTORY RECORDS with the same element entry ID created after the
6815: -- current other pay action.
6816: DELETE ghr_pa_history
6817: WHERE (information5 = p_hist_rec.information1 OR information1 = p_hist_rec.information1)
6818: AND effective_date > (fnd_date.canonical_to_date(p_hist_rec.information2) + 1);
6819:
6820: END IF;
6821: END IF;
6822: ELSIF l_element_name IN ('Retention Allowance','Supervisory Differential','AUO',

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

6824: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;
6825:
6826: DELETE pay_element_entry_values_f
6827: where element_entry_id = p_hist_rec.information1;
6828: -- AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);
6829:
6830: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;
6831:
6832: DELETE PAY_ELEMENT_ENTRIES_F

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

6830: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;
6831:
6832: DELETE PAY_ELEMENT_ENTRIES_F
6833: where element_entry_id = p_hist_rec.information1;
6834: -- AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);
6835:
6836: hr_utility.set_location('Leaving delete_other_pay_entries',170);
6837: ELSE
6838: hr_utility.set_location('Elements Other than OTHER PAY '||p_element_name,110);

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

6840: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRY_VALUES_F;
6841:
6842: DELETE pay_element_entry_values_f
6843: where element_entry_id = p_hist_rec.information1
6844: AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);
6845:
6846: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;
6847:
6848: DELETE PAY_ELEMENT_ENTRIES_F

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

6846: -- DELETE THE RECORD FROM PAY_ELEMENT_ENTRIES_F;
6847:
6848: DELETE PAY_ELEMENT_ENTRIES_F
6849: where element_entry_id = p_hist_rec.information1
6850: AND effective_start_date = fnd_date.canonical_to_date(p_hist_rec.information2);
6851:
6852: hr_utility.set_location('Leaving delete_other_pay_entries',70);
6853: END IF;
6854: