APPS.CSM_PROFILE_PKG dependencies on FND_PROFILE_OPTION_VALUES

Line 244: fnd_profile_option_values val

240: p_user_level_value NUMBER
241: ) IS
242: SELECT val.profile_option_value
243: FROM fnd_profile_options opt,
244: fnd_profile_option_values val
245: WHERE NVL(opt.start_date_active, SYSDATE) <= SYSDATE
246: AND NVL(opt.end_date_active, SYSDATE) >= SYSDATE
247: AND opt.profile_option_name = p_profile_option_name
248: AND opt.application_id = val.application_id

Line 501: FROM FND_PROFILE_OPTION_VALUES val,

497:
498: CURSOR c_get_resp_value (c_resp_id NUMBER)
499: IS
500: SELECT val.PROFILE_OPTION_VALUE
501: FROM FND_PROFILE_OPTION_VALUES val,
502: FND_PROFILE_OPTIONS prf
503: WHERE prf.PROFILE_OPTION_ID = val.PROFILE_OPTION_ID
504: AND prf.PROFILE_OPTION_NAME = 'CSM_MOBILE_QUERY_SCHEMA'
505: AND LEVEL_ID = 10003

Line 511: FROM FND_PROFILE_OPTION_VALUES val,

507:
508: CURSOR c_get_site_value
509: IS
510: SELECT val.PROFILE_OPTION_VALUE
511: FROM FND_PROFILE_OPTION_VALUES val,
512: FND_PROFILE_OPTIONS prf
513: WHERE prf.PROFILE_OPTION_ID = val.PROFILE_OPTION_ID
514: AND prf.PROFILE_OPTION_NAME = 'CSM_MOBILE_QUERY_SCHEMA'
515: AND LEVEL_ID = 10001