DBA Data[Home] [Help]

APPS.MSC_GANTT_UTILS dependencies on MSC_USER_PREFERENCE_KEYS

Line 9565: msc_user_preference_keys mupk,

9561:
9562: cursor c_pref_values (p_user number, p_pref_id number, p_plan_type number, p_from_flag number)is
9563: select mupv.key pref_key, nvl(mupv.value, mupk.default_value) pref_value
9564: from msc_user_preferences mup,
9565: msc_user_preference_keys mupk,
9566: msc_user_preference_values mupv
9567: where p_from_flag <> 0
9568: and mup.user_id = p_user
9569: and mup.preference_id = p_pref_id

Line 9584: from msc_user_preference_keys mupk

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