DBA Data[Home] [Help]

APPS.WIP_WS_SKILL_CHECK_PVT dependencies on WIP_PREFERENCE_VALUES

Line 10: from wip_preference_values

6: is
7: cursor get_preferences is
8: select attribute_name,
9: attribute_value_code
10: from wip_preference_values
11: where preference_id = 41
12: and level_id = 1
13: and attribute_name <> G_PREF_ORG_ATTRIBUTE
14: and sequence_number = (select sequence_number

Line 15: from wip_preference_values

11: where preference_id = 41
12: and level_id = 1
13: and attribute_name <> G_PREF_ORG_ATTRIBUTE
14: and sequence_number = (select sequence_number
15: from wip_preference_values
16: where preference_id = 41
17: and level_id = 1
18: and attribute_name = G_PREF_ORG_ATTRIBUTE
19: and attribute_value_code = to_char(p_organization_id))