APPS.OKC_TASK_ALERT_ESCL_PVT dependencies on JTF_TASKS_V

Line 64: from jtf_tasks_vl jtb,

60: ,jtb.owner_id
61: ,jtb.planned_end_date
62: ,jtb.notification_period
63: ,res.tve_id
64: from jtf_tasks_vl jtb,
65: jtf_task_types_vl jttl,
66: jtf_task_statuses_vl jtsl,
67: okc_resolved_timevalues res
68: where jtb.actual_end_date IS NULL

Line 79: l_workflow_process_id jtf_tasks_v.workflow_process_id%TYPE;

75: and jtb.task_status_id = jtsl.task_status_id
76: and jtsl.task_status_id = 10;
77: --and jtsl.name = 'Open';
78:
79: l_workflow_process_id jtf_tasks_v.workflow_process_id%TYPE;
80: l_object_version_number NUMBER;
81: l_task_id jtf_tasks_b.task_id%TYPE;
82: l_task_number jtf_tasks_b.task_number%TYPE;
83: l_task_name jtf_tasks_tl.task_name%TYPE;

Line 490: from jtf_tasks_vl jtb,

486: ,jtb.planned_end_date
487: ,jtb.actual_end_date
488: ,jtb.alarm_interval
489: ,res.tve_id
490: from jtf_tasks_vl jtb,
491: jtf_task_types_tl jttl,
492: jtf_task_statuses_tl jtsl,
493: okc_resolved_timevalues res
494: where jtb.actual_end_date IS NULL

Line 506: l_workflow_process_id jtf_tasks_v.workflow_process_id%TYPE;

502: and jtb.task_status_id = jtsl.task_status_id
503: and jtsl.task_status_id = 10;
504: --and jtsl.name = 'Open';
505:
506: l_workflow_process_id jtf_tasks_v.workflow_process_id%TYPE;
507: l_object_version_number NUMBER;
508: l_tve_id NUMBER;
509: l_contract_id okc_rules_b.dnz_chr_id%TYPE;
510: l_task_id jtf_tasks_b.task_id%TYPE;

Line 524: l_alarm_interval jtf_tasks_v.alarm_interval%TYPE;

520: l_escalate_owner1 fnd_user.user_name%TYPE;
521: l_escalate_owner2 fnd_user.user_name%TYPE;
522: l_escalate_name VARCHAR2(100);
523: l_dummy VARCHAR2(100);
524: l_alarm_interval jtf_tasks_v.alarm_interval%TYPE;
525: l_return_status VARCHAR2(3);
526: l_planned_date jtf_tasks_b.planned_end_date%TYPE;
527: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
528: l_item_type VARCHAR2(30);

Line 933: from jtf_tasks_vl jtb,

929: ,jtb.planned_end_date
930: ,jtb.actual_end_date
931: ,jtb.alarm_interval
932: ,res.tve_id
933: from jtf_tasks_vl jtb,
934: jtf_task_types_vl jttl,
935: jtf_task_statuses_vl jtsl,
936: okc_resolved_timevalues res
937: where jtb.actual_end_date IS NULL

Line 949: l_workflow_process_id jtf_tasks_v.workflow_process_id%TYPE;

945: and jtb.task_status_id = jtsl.task_status_id
946: and jtsl.task_status_id = 10;
947: --and jtsl.name = 'Open';
948:
949: l_workflow_process_id jtf_tasks_v.workflow_process_id%TYPE;
950: l_object_version_number NUMBER;
951: l_contract_id okc_rules_b.dnz_chr_id%TYPE;
952: l_task_id jtf_tasks_b.task_id%TYPE;
953: l_task_number jtf_tasks_b.task_number%TYPE;