41:
42:
43: CURSOR get_profile IS
44: SELECT profile_option_value
45: FROM fnd_profile_options A, fnd_profile_option_values B
46: WHERE a.profile_option_id = b.profile_option_id
47: AND a.profile_option_name = p_profile_name
48: AND level_id = 10001;
49:
47: AND a.profile_option_name = p_profile_name
48: AND level_id = 10001;
49:
50:
51: l_profile_value fnd_profile_option_values.profile_option_value%TYPE;
52:
53: BEGIN
54:
55: OPEN get_profile;
84: , x_exception_count OUT NOCOPY NUMBER)
85:
86: IS
87:
88: l_lab_profile fnd_profile_option_values.profile_option_value%TYPE;
89:
90: /*=====================================
91: Cursor to get default Stability
92: Study Org from setup tables.