APPS.CSF_ALERTS_PUB dependencies on JTF_TASK_PRIORITIES_VL

Line 58: jtf_task_priorities_vl jp_vl,

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
62: and nvl(jtb.scheduled_start_date, sysdate - 1) > sysdate

Line 106: jtf_task_priorities_vl jp_vl,

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
110: and nvl(jtb.scheduled_start_date, sysdate - 1) > sysdate

Line 160: jtf_task_priorities_vl jp_vl,

156: cursor c_task_detail (v_task_id number, v_resource_id number, v_resource_type_code varchar2) is
157: SELECT jtb.scheduled_start_date,
158: jtb.scheduled_end_date
159: FROM jtf_tasks_b jtb,
160: jtf_task_priorities_vl jp_vl,
161: jtf_task_types_vl jtt_vl
162: WHERE jtb.task_id = v_task_id
163: and nvl(jtb.scheduled_start_date, sysdate - 1) > sysdate
164: and jtb.task_type_id = jtt_vl.task_type_id

Line 222: jtf_task_priorities_vl jp_vl1,

218: v_resource_type varchar2) is
219: select
220: 'TRUE'
221: from
222: jtf_task_priorities_vl jp_vl1,
223: jtf_task_priorities_vl jp_vl2,
224: jtf_task_audits_b jtab
225: where
226: jtab.task_id = v_task_id

Line 223: jtf_task_priorities_vl jp_vl2,

219: select
220: 'TRUE'
221: from
222: jtf_task_priorities_vl jp_vl1,
223: jtf_task_priorities_vl jp_vl2,
224: jtf_task_audits_b jtab
225: where
226: jtab.task_id = v_task_id
227: and jtab.task_audit_id = v_task_audit_id

Line 906: jtf_task_priorities_vl jp_vl,

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
910: and nvl(jtb.scheduled_start_date, sysdate - 1) > sysdate

Line 2524: l_priority jtf_task_priorities_vl.name%type;

2520: l_old_sch_st_date jtf_tasks_b.scheduled_start_date%type;
2521: l_sch_end_date jtf_tasks_b.scheduled_end_date%type;
2522: l_old_sch_end_date jtf_tasks_b.scheduled_end_date%type;
2523: l_planned_effort varchar2(100);
2524: l_priority jtf_task_priorities_vl.name%type;
2525: l_asgm_sts_name jtf_task_statuses_vl.name%type;
2526: l_sr_number cs_incidents_all_b.incident_number%type;
2527: l_sr_summary cs_incidents_all_b.summary%type;
2528: l_product_nr mtl_system_items_vl.concatenated_segments%type;

Line 2564: jtf_task_priorities_vl jp_vl,

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,
2567: hz_party_sites hps,
2568: hz_parties hp,

Line 2610: jtf_task_priorities_vl jp_vl,

2606: chscp.party_id contact_party_id
2607: FROM
2608: jtf_tasks_b jtb,
2609: jtf_tasks_vl j_vl,
2610: jtf_task_priorities_vl jp_vl,
2611: cs_incidents_all c_b,
2612: hz_party_sites hps,
2613: hz_parties hp,
2614: mtl_system_items_vl msi_b,

Line 2656: jtf_task_priorities_vl jp_vl,

2652: FROM
2653: jtf_tasks_b jtb,
2654: jtf_task_audits_b jtab,
2655: jtf_tasks_vl j_vl,
2656: jtf_task_priorities_vl jp_vl,
2657: cs_incidents_all c_b,
2658: hz_party_sites hps,
2659: hz_parties hp,
2660: mtl_system_items_vl msi_b,