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 jtb.source_object_type_code = 'SR'

Line 107: jtf_task_priorities_vl jp_vl,

103: jta.resource_id,
104: jta.resource_type_code
105: FROM jtf_tasks_b jtb,
106: jtf_task_assignments jta,
107: jtf_task_priorities_vl jp_vl,
108: jtf_task_types_vl jtt_vl
109: WHERE jta.task_assignment_id = v_task_assgn_id
110: and jta.task_id = jtb.task_id
111: and jtb.source_object_type_code = 'SR'

Line 162: jtf_task_priorities_vl jp_vl,

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

Line 231: jtf_task_priorities_vl jp_vl1,

227: v_resource_type varchar2) is
228: select
229: 'TRUE'
230: from
231: jtf_task_priorities_vl jp_vl1,
232: jtf_task_priorities_vl jp_vl2,
233: jtf_task_audits_b jtab
234: where
235: jtab.task_id = v_task_id

Line 232: jtf_task_priorities_vl jp_vl2,

228: select
229: 'TRUE'
230: from
231: jtf_task_priorities_vl jp_vl1,
232: jtf_task_priorities_vl jp_vl2,
233: jtf_task_audits_b jtab
234: where
235: jtab.task_id = v_task_id
236: and jtab.task_audit_id = v_task_audit_id

Line 916: jtf_task_priorities_vl jp_vl,

912: jta.resource_type_code,
913: jta.assignment_status_id
914: FROM jtf_tasks_b jtb,
915: jtf_task_assignments jta,
916: jtf_task_priorities_vl jp_vl,
917: jtf_task_types_vl jtt_vl
918: WHERE jta.task_assignment_id = v_task_assgn_id
919: and jta.task_id = jtb.task_id
920: and nvl(jtb.scheduled_start_date, sysdate - 1) > sysdate

Line 2534: l_priority jtf_task_priorities_vl.name%type;

2530: l_old_sch_st_date jtf_tasks_b.scheduled_start_date%type;
2531: l_sch_end_date jtf_tasks_b.scheduled_end_date%type;
2532: l_old_sch_end_date jtf_tasks_b.scheduled_end_date%type;
2533: l_planned_effort varchar2(100);
2534: l_priority jtf_task_priorities_vl.name%type;
2535: l_asgm_sts_name jtf_task_statuses_vl.name%type;
2536: l_sr_number cs_incidents_all_b.incident_number%type;
2537: l_sr_summary cs_incidents_all_tl.summary%type;
2538: l_product_nr mtl_system_items_vl.concatenated_segments%type;

Line 2574: jtf_task_priorities_vl jp_vl,

2570: FROM
2571: jtf_tasks_b jtb,
2572: jtf_task_assignments jta,
2573: jtf_tasks_vl j_vl,
2574: jtf_task_priorities_vl jp_vl,
2575: jtf_task_statuses_vl js_vl,
2576: cs_incidents_all c_b,
2577: hz_party_sites hps,
2578: hz_parties hp,

Line 2620: jtf_task_priorities_vl jp_vl,

2616: chscp.party_id contact_party_id
2617: FROM
2618: jtf_tasks_b jtb,
2619: jtf_tasks_vl j_vl,
2620: jtf_task_priorities_vl jp_vl,
2621: cs_incidents_all c_b,
2622: hz_party_sites hps,
2623: hz_parties hp,
2624: mtl_system_items_vl msi_b,

Line 2666: jtf_task_priorities_vl jp_vl,

2662: FROM
2663: jtf_tasks_b jtb,
2664: jtf_task_audits_b jtab,
2665: jtf_tasks_vl j_vl,
2666: jtf_task_priorities_vl jp_vl,
2667: cs_incidents_all c_b,
2668: hz_party_sites hps,
2669: hz_parties hp,
2670: mtl_system_items_vl msi_b,