DBA Data[Home] [Help]

APPS.PAY_SA_GENERAL dependencies on FND_PROFILE

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;