APPS.CUG_WF_EMAIL_UTIL dependencies on JTF_TASKS_B

Line 57: jtf_tasks_b jtv

53: ciav.incident_date, jtv.task_id, jtv.task_type_id
54: into lv_incident_id, lv_incident_type_id, lv_incident_number,
55: lv_incident_date, lv_task_id, lv_task_type_id
56: from cs_incidents_all_b ciav,
57: jtf_tasks_b jtv
58: where ciav.incident_id = jtv.source_object_id
59: and jtv.task_number = lv_task_number
60: and jtv.source_object_type_code ='SR';
61:

Line 713: jtf_tasks_b jtv

709: -- for a given Service Request
710: select jtv.task_id, jtv.task_type_id, jtv.source_object_type_code
711: into lv_task_id, lv_task_type_id, lv_source_object_type_code
712: from cs_incidents_all_b ciav,
713: jtf_tasks_b jtv
714: where ciav.incident_id = jtv.source_object_id
715: and jtv.task_number = lv_task_number;
716:
717: if (lv_source_object_type_code = 'SR' ) then

Line 812: from JTF_TASKS_B jtb

808: select jtb.source_object_id , jtb.task_id,
809: jtb.source_object_type_code, jtb.object_version_number
810: into lv_source_object_id , lv_task_id ,
811: lv_source_object_type_code, lv_object_version_number
812: from JTF_TASKS_B jtb
813: where jtb.TASK_NUMBER= lv_task_number;
814:
815: begin
816: select ACTIVITY_RESULT_CODE