APPS.AS_VALIDATE_SETUP dependencies on FND_PROFILE_OPTION_VALUES

Line 38: FROM FND_PROFILE_OPTIONS b, FND_PROFILE_OPTION_VALUES v

34: p_NAME VARCHAR2) RETURN VARCHAR2
35: IS
36: Cursor c_prof_value IS
37: SELECT v.PROFILE_OPTION_VALUE
38: FROM FND_PROFILE_OPTIONS b, FND_PROFILE_OPTION_VALUES v
39: WHERE b.APPLICATION_ID=279
40: AND b.PROFILE_OPTION_NAME=p_name
41: AND v.PROFILE_OPTION_ID=b.PROFILE_OPTION_ID
42: AND v.level_id=10001;

Line 56: FROM FND_PROFILE_OPTIONS b, FND_PROFILE_OPTION_VALUES v

52: p_NAME VARCHAR2) RETURN VARCHAR2
53: IS
54: Cursor c_prof_value IS
55: SELECT v.PROFILE_OPTION_VALUE
56: FROM FND_PROFILE_OPTIONS b, FND_PROFILE_OPTION_VALUES v
57: WHERE b.APPLICATION_ID=690
58: AND b.PROFILE_OPTION_NAME=p_name
59: AND v.PROFILE_OPTION_ID=b.PROFILE_OPTION_ID
60: AND v.level_id=10001;