APPS.CSF_ALERTS_PUB dependencies on JTF_TASKS_VL

Line 2517: l_task_name jtf_tasks_vl.task_name%type;

2513: l_task_asgn_record task_asgn_record;
2514: l_contact_record contact_record;
2515:
2516: l_task_number jtf_tasks_b.task_number%type;
2517: l_task_name jtf_tasks_vl.task_name%type;
2518: l_task_desc jtf_tasks_vl.description%type;
2519: l_sch_st_date jtf_tasks_b.scheduled_start_date%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;

Line 2518: l_task_desc jtf_tasks_vl.description%type;

2514: l_contact_record contact_record;
2515:
2516: l_task_number jtf_tasks_b.task_number%type;
2517: l_task_name jtf_tasks_vl.task_name%type;
2518: l_task_desc jtf_tasks_vl.description%type;
2519: l_sch_st_date jtf_tasks_b.scheduled_start_date%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;

Line 2563: jtf_tasks_vl j_vl,

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

Line 2609: jtf_tasks_vl j_vl,

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

Line 2655: jtf_tasks_vl j_vl,

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