DBA Data[Home] [Help]

APPS.JTF_EC_REFERENCES_PVT dependencies on JTF_TASK_REFERENCES_VL

Line 244: l_task_reference_id jtf_task_references_vl.task_reference_id%TYPE

240: IS
241: l_api_version CONSTANT NUMBER := 1.0;
242: l_api_name CONSTANT VARCHAR2(30)
243: := 'UPDATE_REFERENCES';
244: l_task_reference_id jtf_task_references_vl.task_reference_id%TYPE
245: := p_escalation_reference_id;
246:
247: CURSOR c_escalation_reference
248: IS

Line 250: FROM jtf_task_references_vl

246:
247: CURSOR c_escalation_reference
248: IS
249: SELECT 1 x
250: FROM jtf_task_references_vl
251: WHERE task_reference_id = p_escalation_reference_id;
252:
253: escalation_reference c_escalation_reference%ROWTYPE;
254: x CHAR;

Line 318: jtf_task_references_vl reference,

314: BEGIN
315: SELECT 1
316: INTO x
317: FROM jtf_tasks_vl tasks,
318: jtf_task_references_vl reference,
319: jtf_task_statuses_vl status
320: WHERE reference.task_reference_id <> p_escalation_reference_id
321: AND tasks.task_id = reference.task_id
322: AND tasks.task_type_id = jtf_ec_pub.g_escalation_type_id