DBA Data[Home] [Help]

APPS.WIP_WS_LABOR_METRIC_PUB dependencies on WIP_PREFERENCE_VALUES

Line 295: from wip_preference_values

291: cursor get_preferences(org_id number) is
292: select attribute_name,
293: substr(attribute_name,2,1) as identifier,
294: attribute_value_code
295: from wip_preference_values
296: where preference_id = 35
297: and level_id = 1
298: and sequence_number = (select sequence_number
299: from wip_preference_values

Line 299: from wip_preference_values

295: from wip_preference_values
296: where preference_id = 35
297: and level_id = 1
298: and sequence_number = (select sequence_number
299: from wip_preference_values
300: where preference_id = 35
301: and level_id = 1
302: and attribute_name = 'Org'
303: and attribute_value_code = to_char(org_id))