DBA Data[Home] [Help]

APPS.WIP_TIME_ENTRY_PUB dependencies on WIP_PREFERENCE_LEVELS

Line 69: from wip_preference_levels

65: into l_temp
66: from wip_preference_values
67: where preference_id=26 and
68: level_id in (select level_id
69: from wip_preference_levels
70: where organization_id = p_organization_id and
71: resp_key is not null and
72: department_id is null);
73: exception

Line 113: from wip_preference_levels

109: into l_temp
110: from wip_preference_values
111: where preference_id=26 and
112: level_id in (select level_id
113: from wip_preference_levels
114: where organization_id = p_organization_id and
115: resp_key is not null and
116: department_id is null);
117: exception

Line 326: from wip_preference_levels

322: -- we will use rownum.
323:
324: select level_id
325: into l_level_id
326: from wip_preference_levels
327: where organization_id = p_organization_id
328: and department_id is null
329: and level_id in (select level_id
330: from wip_preference_values