APPS.WIP_WS_UTIL dependencies on WIP_PREFERENCE_VALUES

Line 88: from wip_preference_values v1

84: ( v.department_id is null or v.department_id = p_dept_id) and
85: exists
86: (
87: select 1
88: from wip_preference_values v1
89: where v1.preference_id = p_pref_id and
90: v1.level_id = v.level_id
91: )
92: order by v.level_code desc

Line 111: from wip_preference_values wpv

107:
108: BEGIN
109: select wpv.attribute_value_code
110: into l_result
111: from wip_preference_values wpv
112: where wpv.preference_id = p_pref_id and
113: wpv.level_id = p_level_id and
114: rownum = 1;
115: Exception

Line 1231: from wip_preference_values wpv

1227: p_attribute_name IN VARCHAR2,
1228: p_attribute_val IN VARCHAR2) return NUMBER IS
1229: CURSOR pref_row_seq_csr IS
1230: select wpv.sequence_number
1231: from wip_preference_values wpv
1232: where wpv.preference_id = p_pref_id
1233: and wpv.level_id = p_level_id
1234: and wpv.attribute_name = p_attribute_name
1235: and wpv.attribute_value_code = p_attribute_val;

Line 1251: from wip_preference_values wpv

1247: p_seq_num IN NUMBER,
1248: p_attribute_name IN VARCHAR2) return VARCHAR2 IS
1249: CURSOR att_val_csr IS
1250: select wpv.attribute_value_code
1251: from wip_preference_values wpv
1252: where wpv.preference_id = p_pref_id
1253: and wpv.level_id = p_level_id
1254: and wpv.sequence_number = p_seq_num
1255: and wpv.attribute_name = p_attribute_name;

Line 1534: from wip_preference_values

1530: l_level_id number;
1531:
1532: cursor pref_attach_source(p_level_id number) is
1533: select sequence_number,attribute_value_code
1534: from wip_preference_values
1535: where preference_id = g_pref_id_attachment
1536: and level_id = p_level_id;
1537: begin
1538: l_level_id := get_preference_level_id(g_pref_id_attachment,