The following lines contain the word 'select', 'insert', 'update' or 'delete':
This has to be deleted according to the update 6 manual for april release
-- 120.10.3
if substr(p_duty_station_lookup,1,2) = 'US'
and
p_agency_sub_element <> 'DJ02'
then
hr_utility.set_message(8301, 'GHR_37154_ALL_PROCEDURE_FAIL');
commented by skutteti on 7-apr-98. As per the new changes this edit has to be deleted.
-- 140.02.2
if (
p_First_NOAC_Lookup_Code = '117' or
p_First_NOAC_Lookup_Code = '517'
)
and
not (
to_char(p_Effective_Date,'MMDD')>= '0513'
and
to_char(p_Effective_Date,'MMDD')<= '0930'
)
then
hr_utility.set_message(8301, 'GHR_37157_ALL_PROCEDURE_FAIL');