APPS.MSC_GET_PROFILE dependencies on FND_PROFILE_OPTIONS

Line 37: from fnd_profile_options

33: --
34: cursor profile_info is
35: select profile_option_id,
36: application_id
37: from fnd_profile_options
38: where profile_option_name = upper(name_z)
39: and start_date_active <= sysdate
40: and nvl(end_date_active, sysdate) >= sysdate;
41:

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: