APPS.JTF_EC_UTIL dependencies on JTF_TASK_REFERENCES_B

Line 313: jtf_task_references_b r,

309: cursor c_esc_doc_exists_id( P_OBJECT_TYPE_CODE VARCHAR2,
310: P_OBJECT_ID NUMBER) Is
311: Select r.task_reference_id
312: from jtf_tasks_b t,
313: jtf_task_references_b r,
314: jtf_ec_statuses_vl s
315: where r.reference_code = 'ESC'
316: and r.object_id = p_object_id
317: and r.object_type_code = p_object_type_code

Line 329: jtf_task_references_b r,

325: cursor c_esc_doc_exists_name( P_OBJECT_TYPE_CODE VARCHAR2,
326: P_OBJECT_NAME VARCHAR2) Is
327: Select r.task_reference_id
328: from jtf_tasks_b t,
329: jtf_task_references_b r,
330: jtf_ec_statuses_vl s
331: where r.reference_code = 'ESC'
332: and r.object_name = p_object_name
333: and r.object_type_code = p_object_type_code

Line 392: FROM jtf_task_references_b

388: P_OBJECT_ID NUMBER,
389: P_REFERENCE_CODE VARCHAR2,
390: P_ESCALATION_ID NUMBER) Is
391: SELECT 'x'
392: FROM jtf_task_references_b
393: WHERE object_id = p_object_id
394: AND object_type_code = p_object_type_code
395: AND task_id = p_escalation_id
396: AND reference_code = p_reference_code;

Line 404: FROM jtf_task_references_b

400: P_OBJECT_NAME VARCHAR2,
401: P_REFERENCE_CODE VARCHAR2,
402: P_ESCALATION_ID NUMBER) Is
403: SELECT 'x'
404: FROM jtf_task_references_b
405: WHERE object_name = p_object_name
406: AND object_type_code = p_object_type_code
407: AND task_id = p_escalation_id
408: AND reference_code = p_reference_code;