APPS.CSF_ALERTS_PUB dependencies on JTF_TASK_ASSIGNMENTS

Line 57: jtf_task_assignments jta,

53: jta.resource_id,
54: jta.resource_type_code,
55: jta.assignment_status_id
56: FROM jtf_tasks_b jtb,
57: jtf_task_assignments jta,
58: jtf_task_priorities_vl jp_vl,
59: jtf_task_types_vl jtt_vl
60: WHERE jta.task_assignment_id = v_task_assgn_id
61: and jta.task_id = jtb.task_id

Line 105: jtf_task_assignments jta,

101: jtb.scheduled_end_date,
102: jta.resource_id,
103: jta.resource_type_code
104: FROM jtf_tasks_b jtb,
105: jtf_task_assignments jta,
106: jtf_task_priorities_vl jp_vl,
107: jtf_task_types_vl jtt_vl
108: WHERE jta.task_assignment_id = v_task_assgn_id
109: and jta.task_id = jtb.task_id

Line 212: jtf_task_assignments

208: cursor c_get_all_assignments (v_task_id number) is
209: select
210: task_assignment_Id
211: from
212: jtf_task_assignments
213: where task_id = v_task_id;
214:
215: cursor c_priority_test (v_task_id number,
216: v_task_audit_id number,

Line 656: jtf_task_assignments jt,

652: jt.resource_id,
653: jt.resource_type_code,
654: jt.assignment_status_id
655: from
656: jtf_task_assignments jt,
657: jtf_rs_resource_extns jr
658: where
659: jt.task_assignment_id = v_task_asgn_id
660: and jt.resource_id = jr.resource_id

Line 905: jtf_task_assignments jta,

901: jta.resource_id,
902: jta.resource_type_code,
903: jta.assignment_status_id
904: FROM jtf_tasks_b jtb,
905: jtf_task_assignments jta,
906: jtf_task_priorities_vl jp_vl,
907: jtf_task_types_vl jtt_vl
908: WHERE jta.task_assignment_id = v_task_assgn_id
909: and jta.task_id = jtb.task_id

Line 1039: jtf_task_assignments jta

1035:
1036: cursor c_task_assgn_detail (v_task_assgn_id number) is
1037: SELECT jta.object_version_number, jta.assignment_status_id
1038: FROM
1039: jtf_task_assignments jta
1040: WHERE jta.task_assignment_id = v_task_assgn_id;
1041: begin
1042: l_task_assgn_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1043: itemkey => itemkey,

Line 1142: jtf_task_assignments jta

1138:
1139: cursor c_task_assgn_detail (v_task_assgn_id number) is
1140: SELECT jta.object_version_number, jta.assignment_status_id
1141: FROM
1142: jtf_task_assignments jta
1143: WHERE jta.task_assignment_id = v_task_assgn_id;
1144:
1145: -- bug # 5220702
1146: l_auto_reject varchar2(1);

Line 1156: from jtf_task_assignments

1152: l_document_id varchar2(250);
1153:
1154: cursor c_get_task_id (v_task_asgn_id number) is
1155: select task_id
1156: from jtf_task_assignments
1157: where task_assignment_id = v_task_asgn_id;
1158: begin
1159: l_task_assgn_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1160: itemkey => itemkey,

Line 1486: jtf_task_assignments a

1482: select
1483: n.notes
1484: from
1485: jtf_notes_vl n,
1486: jtf_task_assignments a
1487: where
1488: n.source_object_code = 'TASK'
1489: and n.source_object_id = a.task_id
1490: and a.task_assignment_id = v_task_asgn_id

Line 1495: jtf_task_assignments a,

1491: union select
1492: n.notes
1493: from
1494: jtf_notes_vl n,
1495: jtf_task_assignments a,
1496: jtf_tasks_b t
1497: where
1498: n.source_object_code = 'SR'
1499: and n.source_object_id = t.source_object_id

Line 1725: jtf_task_assignments a

1721: select
1722: n.notes
1723: from
1724: jtf_notes_vl n,
1725: jtf_task_assignments a
1726: where
1727: n.source_object_code = 'TASK'
1728: and n.source_object_id = a.task_id
1729: and a.task_assignment_id = v_task_asgn_id

Line 1734: jtf_task_assignments a,

1730: union select
1731: n.notes
1732: from
1733: jtf_notes_vl n,
1734: jtf_task_assignments a,
1735: jtf_tasks_b t
1736: where
1737: n.source_object_code = 'SR'
1738: and n.source_object_id = t.source_object_id

Line 2562: jtf_task_assignments jta,

2558: chscp.contact_type contact_type,
2559: chscp.party_id contact_party_id
2560: FROM
2561: jtf_tasks_b jtb,
2562: jtf_task_assignments jta,
2563: jtf_tasks_vl j_vl,
2564: jtf_task_priorities_vl jp_vl,
2565: jtf_task_statuses_vl js_vl,
2566: cs_incidents_all c_b,