Line 17: if FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY') is null then
13: is
14:
15: begin
16: 17: if FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY') is null then 18: return 'NOTEXISTS';
19: else
20: return 'EXISTS';
21: end if;
Line 64: if UPPER(l_nat_cd) = FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY') then
60: WHEN no_data_found Then
61: Null;
62: END;
63: 64: if UPPER(l_nat_cd) = FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY') then 65: return 'MATCH';
66: else
67: return 'NOMATCH';
68: end if;