DBA Data[Home] [Help]

APPS.MSC_GET_PROFILE dependencies on FND_PROFILE_OPTIONS_VL

Line 152: select PROFILE_OPTION_NAME FROM FND_PROFILE_OPTIONS_VL

148: p_file_name IN varchar2)
149: IS
150:
151: CURSOR get_profile_name(prod varchar2) is
152: select PROFILE_OPTION_NAME FROM FND_PROFILE_OPTIONS_VL
153: WHERE START_DATE_ACTIVE <= SYSDATE and NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE
154: AND (SITE_ENABLED_FLAG = 'Y' or USER_ENABLED_FLAG = 'Y')
155: AND UPPER(USER_PROFILE_OPTION_NAME) LIKE prod||'%';
156: