DBA Data[Home] [Help]

APPS.WIP_PREFERENCES_PKG dependencies on WIP_PREFERENCE_DEFINITIONS

Line 23: from wip_preference_definitions

19: l_multi_val_cnt NUMBER := 0;
20:
21: cursor pref_type(cl_pref_id NUMBER) is
22: select preference_type
23: from wip_preference_definitions
24: where preference_id = cl_pref_id;
25:
26: cursor single_value (cl_resp_key VARCHAR2,
27: cl_org_id NUMBER,

Line 164: from wip_preference_definitions wp

160: select ml.meaning
161: from mfg_lookups ml
162: where ml.lookup_code = to_number(cl_value_code) and
163: ml.lookup_type = (select wp.preference_value_lookup_type
164: from wip_preference_definitions wp
165: where wp.preference_id = p_preference_id);
166: begin
167:
168: l_value_code := get_preference_value_code (p_preference_id,