Line 53: and (hr_general.decode_lookup('NAME_TRANSLATIONS','STANDARD')
49: l_ass_status_typ_id per_ass_status_type_amends.assignment_status_type_id%type;
50: --
51: Begin
52: If p_user_status is not null 53: and (hr_general.decode_lookup('NAME_TRANSLATIONS','STANDARD') 54: <> p_user_status) then
55: --
56: select pas.assignment_status_type_id
57: into l_ass_status_typ_id