DBA Data[Home] [Help]

APPS.PQH_PTX_BUS dependencies on HR_GENERAL

Line 1816: l_avail_status_start_date := hr_general.DECODE_AVAIL_STATUS_START_DATE (

1812: hr_utility.set_message('800','PER_INVALID_JOB_PROP_END_DATE');
1813: hr_utility.raise_error;
1814: end if;
1815:
1816: l_avail_status_start_date := hr_general.DECODE_AVAIL_STATUS_START_DATE (
1817: position_id
1818: ,availability_status_id
1819: ,p_effective_date ) ;
1820: if avail_status_prop_end_date < nvl(l_avail_status_start_date,date_effective) then

Line 1870: l_avail_status_start_date := hr_general.DECODE_AVAIL_STATUS_START_DATE (

1866: <> nvl(pqh_ptx_shd.g_old_rec.avail_status_prop_end_date,hr_api.g_date)
1867: or not l_api_updating) and
1868: avail_status_prop_end_date is not null then
1869: --
1870: l_avail_status_start_date := hr_general.DECODE_AVAIL_STATUS_START_DATE (
1871: position_id
1872: ,availability_status_id
1873: ,p_effective_date ) ;
1874: if avail_status_prop_end_date < nvl(l_avail_status_start_date,date_effective) then