APPS.IEU_ESCALATIONS_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

    SELECT /*+ index(tasks_b jtf_tasks_b_n2) */
    distinct lkups.meaning name, tasks_b.escalation_level
    from jtf_tasks_b tasks_b ,
    fnd_lookup_values_vl lkups
    WHERE tasks_b.open_flag = 'Y'
    and nvl(tasks_b.deleted_flag,'N') = 'N'
    and tasks_b.entity ='ESCALATION'
    and lkups.lookup_type = 'JTF_TASK_ESC_LEVEL'
    and lkups.lookup_code = tasks_b.escalation_level
    and tasks_b.owner_id = p_resource_id
    and tasks_b.owner_type_code = 'RS_EMPLOYEE'
    ORDER BY 1;

Line: 34

    SELECT lkups.meaning name, lkups.lookup_code escalation_level
    from fnd_lookup_values_vl lkups
    WHERE lkups.lookup_type = 'JTF_TASK_ESC_LEVEL'
    ORDER BY 1;

Line: 50

   Select meaning into l_node_label
   from fnd_lookup_values_vl
   where lookup_type = 'IEU_NODE_LABELS'
   and view_application_id = 696
   and lookup_code = 'IEU_UWQ_ESC_LBL';

Line: 127

select where_clause
into   l_where_clause
from   ieu_uwq_sel_rt_nodes
where  resource_id=P_RESOURCE_ID
and    node_id=P_NODE_ID;

Line: 139

    SELECT /*+ index(tasks_b jtf_tasks_b_n2) */ count(*) into :l_count
    from jtf_tasks_b tasks_b ,
    jtf_task_references_b refs_b
    WHERE
    nvl(tasks_b.deleted_flag ,'||''''||'N'||''''||') <> '||''''||'Y'||''''||'
    and tasks_b.open_flag = '||''''||'Y'||''''||'
    and tasks_b.entity =  ' ||''''|| 'ESCALATION' ||''''|| '
    and refs_b.task_id(+) = tasks_b.task_id
    and tasks_b.owner_type_code = '||''''||'RS_EMPLOYEE'||''''||'
    and tasks_b.owner_id = :p_Resource_id '||l_where_clause||'; end;';