APPS.CSF_ALERTS_PUB dependencies on CS_INCIDENTS_ALL_B

Line 2472: cs_incidents_all_b ci_all_b,

2468: cursor c_rel_person_phone(v_incident_id number) is
2469: SELECT
2470: hcp.phone_country_code || ' ' || hcp.phone_area_code || ' ' || hcp.phone_number PHONE_NUMBER
2471: FROM
2472: cs_incidents_all_b ci_all_b,
2473: cs_hz_sr_contact_points_v chscp,
2474: hz_contact_points hcp
2475: WHERE
2476: ci_all_b.incident_id = chscp.incident_id

Line 2536: l_sr_number cs_incidents_all_b.incident_number%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;
2539: l_item_serial cs_customer_products_all.current_serial_number%type;
2540: l_item_description mtl_system_items_vl.description%type;