APPS.JTF_EC_UTIL SQL Statements

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

Line: 16

     SELECT 1
       FROM jtf_objects_b
      WHERE object_code = p_owner_type
        AND trunc(NVL (end_date_active, SYSDATE)) >= trunc(SYSDATE)
        AND trunc(NVL (start_date_active, SYSDATE)) <= trunc(SYSDATE)
        AND (object_code IN
           (SELECT object_code
              FROM jtf_object_usages
             WHERE object_user_code = 'RESOURCES'));

Line: 83

    	Select 'x' into l_dummy
    	From jtf_task_contacts
    	Where task_id = p_escalation_id
    	And  escalation_requester_flag = 'Y';

Line: 153

SELECT 	task_status_id
FROM 	jtf_ec_statuses_vl
WHERE 	task_status_id = p_esc_status_id
AND 	NVL (start_date_active, sysdate) <= sysdate
AND 	NVL (end_date_active, sysdate) >= sysdate;

Line: 160

SELECT 	task_status_id
FROM 	jtf_ec_statuses_vl
WHERE 	name = p_esc_status_name
AND 	NVL (start_date_active, sysdate) <= sysdate
AND 	NVL (end_date_active, sysdate) >= sysdate;

Line: 233

SELECT 	'x'
FROM	fnd_lookups
WHERE	lookup_type = p_lookup_type
AND	lookup_code = p_lookup_code
AND 	enabled_flag = 'Y'
AND 	nvl(start_date_active,sysdate) <= sysdate
AND	nvl(end_date_active, sysdate) >= sysdate;

Line: 311

  Select r.task_reference_id
  from   jtf_tasks_b             t,
         jtf_task_references_b   r,
         jtf_ec_statuses_vl      s
  where r.reference_code = 'ESC'
  and   r.object_id = p_object_id
  and   r.object_type_code = p_object_type_code
  and   r.task_id = t.task_id
  and   t.task_type_id = 22
  and   t.task_status_id = s.task_status_id
  and   nvl(s.completed_flag,'N') ='N'
  and   nvl(s.cancelled_flag,'N') = 'N'
  and   nvl(s.closed_flag, 'N') = 'N';

Line: 327

  Select r.task_reference_id
  from   jtf_tasks_b             t,
         jtf_task_references_b   r,
         jtf_ec_statuses_vl      s
  where r.reference_code = 'ESC'
  and   r.object_name = p_object_name
  and   r.object_type_code = p_object_type_code
  and   t.task_type_id = 22
  and   r.task_id = t.task_id
  and   t.task_status_id = s.task_status_id
  and   nvl(s.completed_flag,'N') ='N'
  and   nvl(s.cancelled_flag,'N') = 'N'
  and   nvl(s.closed_flag, 'N') = 'N';

Line: 391

  SELECT 'x'
  FROM   jtf_task_references_b
  WHERE  object_id = p_object_id
  AND   object_type_code =  p_object_type_code
  AND   task_id = p_escalation_id
  AND   reference_code = p_reference_code;

Line: 403

  SELECT 'x'
  FROM   jtf_task_references_b
  WHERE  object_name = p_object_name
  AND   object_type_code =  p_object_type_code
  AND   task_id = p_escalation_id
  AND   reference_code = p_reference_code;

Line: 458

Select 'x'
from jtf_task_contacts
where task_id = p_escalation_id
and contact_id = p_contact_id
and contact_type_code = p_contact_type_code;

Line: 570

select 	task_id
from	jtf_tasks_b
where 	task_id = p_escal_id
and   	task_type_id = 22;

Line: 576

select 	task_id
from	jtf_tasks_b
where 	task_number = p_esc_number
and   	task_type_id = 22;

Line: 639

select 'x'
from jtf_ec_statuses_vl
where task_status_id = p_status_id
and   completed_flag = 'Y';

Line: 648

select 'x'
from  jtf_tasks_b t,
jtf_task_statuses_vl s
where t.source_object_id = p_task_id
and   t.source_object_type_code = 'ESC'
and   t.restrict_closure_flag = 'Y'
and   t.task_status_id = s.task_status_id
and   nvl(s.cancelled_flag, 'N') = 'N'
and   nvl(s.completed_flag, 'N') = 'N'
and   nvl(s.closed_flag, 'N') = 'N';

Line: 660

Select escalation_level
from jtf_tasks_b
where task_id = p_task_id;

Line: 780

select 'x'
from 	jtf_task_phones ph,
	jtf_task_contacts c
where 	ph.task_phone_id = p_task_phone_id
and 	ph.task_contact_id = c.task_contact_id
and 	c.task_id = p_escalation_id;

Line: 836

select 	c.task_contact_id
from	jtf_task_contacts c
where 	c.contact_id = p_contact_id
and 	c.task_id = p_escalation_id
and	c.contact_type_code = p_contact_type_code;

Line: 886

select 'x'
from 	jtf_task_contacts
where 	task_contact_id = p_task_contact_id
and 	task_id = p_escalation_id;

Line: 936

select 'x'
from 	jtf_task_references_vl
where 	task_reference_id = p_task_reference_id
and 	task_id = p_escalation_id;

Line: 989

select 	'x'
from 	fnd_user
where 	user_id = p_user_id
and 	nvl(start_date,sysdate) <= sysdate
and 	nvl(end_date, sysdate) >= sysdate;

Line: 996

select 	'x'
from	fnd_logins
where	login_id  = p_login_id
and	user_id	  = p_user_id;

Line: 1057

select 'x'
from 	jtf_notes_b
where 	jtf_note_id = p_note_id
and 	source_object_id = p_escalation_id;

Line: 1099

SELECT 	contact_id, contact_type_code
FROM 	jtf_task_contacts
WHERE 	task_id = p_esc_id
AND 	NVL(escalation_requester_flag,'N') = 'Y';

Line: 1106

SELECT  subject_party_name
FROM 	jtf_party_all_contacts_v
WHERE  	p_contact_id IN (party_id, subject_party_id);

Line: 1111

SELECT 	full_name
FROM 	per_all_people_f
WHERE 	person_id = p_contact_id
AND 	SYSDATE >= NVL(effective_start_date,SYSDATE)
AND 	SYSDATE <= NVL(effective_end_date,SYSDATE);