APPS.CSFW_TASKS_PUB dependencies on CS_INCIDENTS_ALL

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

625: l_customer_id number;
626:
627: cursor c_customer_id (v_incident_id number)
628: is
629: select customer_id from cs_incidents_all where incident_id = v_incident_id;
630:
631: CURSOR c_task_type (v_task_type_id NUMBER)
632: IS
633: Select name

Line 667: from cs_incidents_all

663: IS
664: Select incident_number,
665: incident_location_type,
666: incident_location_id
667: from cs_incidents_all
668: where incident_id = v_incident_id ;
669:
670: r_incident_record c_incident_number%ROWTYPE;
671:

Line 1051: from cs_incidents_all

1047: customer_email_id,
1048: customer_phone_id,
1049: category_set_id,
1050: category_id
1051: from cs_incidents_all
1052: where incident_id = v_incident_id;
1053:
1054: r_incident_record c_incident_record%ROWTYPE;
1055: