APPS.CSF_ALERTS_PUB dependencies on JTF_TASKS_VL

Line 2527: l_task_name jtf_tasks_vl.task_name%type;

2523: l_task_asgn_record task_asgn_record;
2524: l_contact_record contact_record;
2525:
2526: l_task_number jtf_tasks_b.task_number%type;
2527: l_task_name jtf_tasks_vl.task_name%type;
2528: l_task_desc jtf_tasks_vl.description%type;
2529: l_sch_st_date jtf_tasks_b.scheduled_start_date%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;

Line 2528: l_task_desc jtf_tasks_vl.description%type;

2524: l_contact_record contact_record;
2525:
2526: l_task_number jtf_tasks_b.task_number%type;
2527: l_task_name jtf_tasks_vl.task_name%type;
2528: l_task_desc jtf_tasks_vl.description%type;
2529: l_sch_st_date jtf_tasks_b.scheduled_start_date%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;

Line 2573: jtf_tasks_vl j_vl,

2569: chscp.party_id contact_party_id
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,

Line 2619: jtf_tasks_vl j_vl,

2615: chscp.contact_type contact_type,
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,

Line 2665: jtf_tasks_vl j_vl,

2661: jtab.old_scheduled_end_date old_sch_end_date
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,