APPS.JTF_EC_WORKFLOW_PKG dependencies on JTF_EC_STATUSES_VL

Line 1031: l_esc_status jtf_ec_statuses_vl.description%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);
1034: -- l_found VARCHAR2(1) := 'x';
1035: l_counter NUMBER(5);

Line 1102: FROM jtf_ec_statuses_vl

1098: -------------------------------------------------------------------------
1099:
1100: cursor c_esc_status(p_status_id in NUMBER) is
1101: SELECT name
1102: FROM jtf_ec_statuses_vl
1103: WHERE task_status_id = p_status_id;
1104:
1105: -------------------------------------------------------------------------
1106: -- Get the escalation level