APPS.CSFW_DEBRIEF_PUB dependencies on CS_INCIDENTS_ALL_B

Line 162: select creation_date from cs_incidents_all_b where incident_id = v_incident_id;

158: and inventory_item_id = v_item_id;
159:
160: cursor c_creation_date (v_incident_id number)
161: is
162: select creation_date from cs_incidents_all_b where incident_id = v_incident_id;
163:
164:
165: BEGIN
166: l_order_header_id := 0;

Line 652: select creation_date from cs_incidents_all_b where incident_id = v_incident_id;

648: where organization_id = v_org_id
649: and inventory_item_id = v_item_id;
650:
651: cursor c_creation_date(v_incident_id number) is
652: select creation_date from cs_incidents_all_b where incident_id = v_incident_id;
653: l_validate_lab_time_msg varchar2(255);
654:
655:
656: cursor find_resource is

Line 1043: select creation_date from cs_incidents_all_b where incident_id = v_incident_id;

1039: from csi_instance_statuses
1040: where INSTANCE_STATUS_ID = v_partStatusCd;
1041:
1042: cursor c_creation_date(v_incident_id number) is
1043: select creation_date from cs_incidents_all_b where incident_id = v_incident_id;
1044:
1045:
1046:
1047: BEGIN