Line 779: l_old_argument_value hr_lookups.lookup_code%TYPE;
775: ,p_validation_end_date IN DATE
776: ) RETURN NUMBER IS
777:
778: --Local variables declaration 779: l_old_argument_value hr_lookups.lookup_code%TYPE; 780:
781: BEGIN
782: --
783: -- If argument value is not null then
Line 784: -- Check if the argument value exists in hr_lookups
780:
781: BEGIN
782: --
783: -- If argument value is not null then 784: -- Check if the argument value exists in hr_lookups 785: -- where the lookup_type is passed lookuptype
786: --
787: IF p_lookup_code IS NOT NULL then
788: IF hr_api.not_exists_in_dt_hrstanlookups