DBA Data[Home] [Help]

APPS.WIP_WS_DL_UTIL dependencies on WIP_PREFERENCE_VALUES

Line 923: from wip_preference_values wpv

919: ) return varchar2
920: Is
921: cursor c_pref_values(p_pref_id number, p_level_id number) IS
922: select wpv.attribute_name, wpv.attribute_value_code
923: from wip_preference_values wpv
924: where wpv.preference_id = p_pref_id and
925: wpv.level_id = p_level_id
926: order by wpv.sequence_number;
927:

Line 1137: from wip_preference_values v1, wip_preference_values v2, wip_preference_values v3, wip_preference_values v4

1133: v1.attribute_value_code,
1134: v2.attribute_value_code,
1135: v3.attribute_value_code,
1136: v4.attribute_value_code
1137: from wip_preference_values v1, wip_preference_values v2, wip_preference_values v3, wip_preference_values v4
1138: where
1139: v1.preference_id = p_pref_id and
1140: v2.preference_id = p_pref_id and
1141: v3.preference_id = p_pref_id and

Line 1225: from wip_preference_values wpv

1221: is
1222:
1223: cursor c_pref_values(p_pref_id number, p_level_id number, p_attribute varchar2) IS
1224: select wpv.attribute_value_code
1225: from wip_preference_values wpv
1226: where wpv.preference_id = p_pref_id and
1227: wpv.level_id = p_level_id and
1228: ( p_attribute is null
1229: or wpv.attribute_name = p_attribute);