DBA Data[Home] [Help]

APPS.HR_PSF_BUS dependencies on HR_GENERAL

Line 205: l_avail_status_start_date := hr_general.DECODE_AVAIL_STATUS_START_DATE (

201: hr_utility.set_message(800,'PER_INVALID_JOB_PROP_END_DATE');
202: hr_utility.raise_error;
203: end if;
204:
205: l_avail_status_start_date := hr_general.DECODE_AVAIL_STATUS_START_DATE (
206: position_id
207: ,availability_status_id
208: ,p_effective_date ) ;
209: if avail_status_prop_end_date < nvl(l_avail_status_start_date,date_effective) then

Line 4848: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);

4844: where position_id = p_position_id
4845: and information_type= 'PER_RESERVED'
4846: and p_effective_date
4847: between fnd_date.canonical_to_date(poei_information3)
4848: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);
4849: --
4850: cursor csr_valid_eff_date(p_position_id number,
4851: p_validation_start_date date,
4852: p_validation_end_date date) is