APPS.CSFW_TASKS_PUB dependencies on CS_INCIDENTS_ALL

Line 645: select customer_id from cs_incidents_all where incident_id = v_incident_id;

641: l_customer_id number;
642:
643: cursor c_customer_id (v_incident_id number)
644: is
645: select customer_id from cs_incidents_all where incident_id = v_incident_id;
646:
647: CURSOR c_task_type (v_task_type_id NUMBER)
648: IS
649: Select name

Line 683: from cs_incidents_all

679: IS
680: Select incident_number,
681: incident_location_type,
682: incident_location_id
683: from cs_incidents_all
684: where incident_id = v_incident_id ;
685:
686: r_incident_record c_incident_number%ROWTYPE;
687:

Line 1068: from cs_incidents_all

1064: customer_email_id,
1065: customer_phone_id,
1066: category_set_id,
1067: category_id
1068: from cs_incidents_all
1069: where incident_id = v_incident_id;
1070:
1071: r_incident_record c_incident_record%ROWTYPE;
1072: