APPS.WIP_WS_SKILL_CHECK_PVT dependencies on WIP_OPERATIONS

Line 63: from wip_operations

59: l_check_skill number;
60: begin
61: select nvl(check_skill,2)
62: into l_check_skill
63: from wip_operations
64: where wip_entity_id = p_wip_entity_id
65: and operation_seq_num = p_op_seq_num;
66:
67: return l_check_skill;

Line 327: ' from wip_operations '||

323: l_add_where_clause := l_add_where_clause || ' and operation_seq_num <= :4 ';
324: end if;
325:
326: l_sql := ' select operation_seq_num,nvl(check_skill,2) '||
327: ' from wip_operations '||
328: ' where organization_id = :1 '||
329: ' and wip_entity_id = :2 '||
330: l_add_where_clause;
331: