DBA Data[Home] [Help]

APPS.MSC_GET_NAME dependencies on MSC_USER_PREFERENCES

Line 4832: from msc_user_preferences

4828:
4829: function get_default_pref_id(p_user_id number,p_plan_type in number default null) return number is
4830: cursor get_default_pref_id_c(p_user_id number) is
4831: select preference_id
4832: from msc_user_preferences
4833: where default_flag =1
4834: and user_id = p_user_id;
4835:
4836: cursor get_default_srppref_id_c(p_user_id number, p_plan_type in number) is

Line 4838: from msc_user_preferences

4834: and user_id = p_user_id;
4835:
4836: cursor get_default_srppref_id_c(p_user_id number, p_plan_type in number) is
4837: select preference_id
4838: from msc_user_preferences
4839: where default_flag =1
4840: and user_id = p_user_id
4841: and plan_type=p_plan_type;
4842: