DBA Data[Home] [Help]

APPS.MSC_GANTT_UTILS dependencies on MSC_USER_PREFERENCE_KEYS

Line 9570: msc_user_preference_keys mupk,

9566:
9567: cursor c_pref_values (p_user number, p_pref_id number, p_plan_type number, p_from_flag number)is
9568: select mupv.key pref_key, nvl(mupv.value, mupk.default_value) pref_value
9569: from msc_user_preferences mup,
9570: msc_user_preference_keys mupk,
9571: msc_user_preference_values mupv
9572: where p_from_flag <> 0
9573: and mup.user_id = p_user
9574: and mup.preference_id = p_pref_id

Line 9589: from msc_user_preference_keys mupk

9585: 'GANTT_RH_TOL_DAYS_EARLY', 'GANTT_RH_TOL_DAYS_LATE')
9586: union all
9587: select mupk.preference_key pref_key,
9588: mupk.default_value pref_value
9589: from msc_user_preference_keys mupk
9590: where p_from_flag = 0
9591: and mupk.plan_type = 1 -- look at only p_plan_type 1, per emily
9592: and mupk.preference_key in ('CATEGORY_SET_ID',
9593: 'GANTT_RA_ACT_LBL_1', 'GANTT_RA_ACT_LBL_2', 'GANTT_RA_ACT_LBL_3',