APPS.JTF_EC_WORKFLOW_PKG dependencies on JTF_TASKS_VL

Line 182: FROM jtf_tasks_vl

178:
179: cursor c_get_task_owner_id is
180: SELECT owner_id,
181: owner_type_code
182: FROM jtf_tasks_vl
183: WHERE task_number = p_doc_number;
184:
185:
186: -------------------------------------------------------------------------

Line 1028: l_old_owner_id jtf_tasks_vl.owner_id%TYPE := p_old_owner_id;

1024: l_api_version CONSTANT NUMBER := 1.0;
1025: l_api_name CONSTANT VARCHAR2(30) := 'Start_Resc_Workflow';
1026: l_itemkey wf_item_activity_statuses.item_key%TYPE;
1027: l_wf_key NUMBER;
1028: l_old_owner_id jtf_tasks_vl.owner_id%TYPE := p_old_owner_id;
1029: --l_old_owner_type_code jtf_tasks_vl.owner_type_code%TYPE := p_old_owner_type_code;
1030: l_user_name per_people_f.full_name%TYPE;
1031: l_esc_status jtf_ec_statuses_vl.description%TYPE;
1032: l_esc_level fnd_lookups.meaning%TYPE;

Line 1029: --l_old_owner_type_code jtf_tasks_vl.owner_type_code%TYPE := p_old_owner_type_code;

1025: l_api_name CONSTANT VARCHAR2(30) := 'Start_Resc_Workflow';
1026: l_itemkey wf_item_activity_statuses.item_key%TYPE;
1027: l_wf_key NUMBER;
1028: l_old_owner_id jtf_tasks_vl.owner_id%TYPE := p_old_owner_id;
1029: --l_old_owner_type_code jtf_tasks_vl.owner_type_code%TYPE := p_old_owner_type_code;
1030: l_user_name per_people_f.full_name%TYPE;
1031: l_esc_status jtf_ec_statuses_vl.description%TYPE;
1032: l_esc_level fnd_lookups.meaning%TYPE;
1033: l_temp_status VARCHAR2(1);

Line 1080: FROM jtf_tasks_vl t,

1076: t.creation_date date_opened,
1077: t.last_update_date date_changed,
1078: t.last_updated_by update_id,
1079: t.created_by create_id
1080: FROM jtf_tasks_vl t,
1081: jtf_task_types_vl tt
1082: WHERE t.task_id = p_task_id
1083: AND t.task_type_id = tt.task_type_id
1084: AND tt.task_type_id = 22;

Line 1091: FROM jtf_tasks_vl t,

1087: -- Get customer name
1088: -------------------------------------------------------------------------
1089: cursor c_cust_name is
1090: SELECT p.party_name customer_name
1091: FROM jtf_tasks_vl t,
1092: hz_parties p
1093: WHERE t.task_id = p_task_id
1094: AND t.customer_id = p.party_id;
1095: