APPS.CSFW_DEBRIEF_PUB dependencies on CS_INCIDENTS_ALL_B

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

197: and inventory_item_id = v_item_id;
198:
199: cursor c_creation_date (v_incident_id number)
200: is
201: select creation_date from cs_incidents_all_b where incident_id = v_incident_id;
202:
203:
204: BEGIN
205: if p_attribute1 = '$$#@' then

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

1157: where organization_id = v_org_id
1158: and inventory_item_id = v_item_id;
1159:
1160: cursor c_creation_date(v_incident_id number) is
1161: select creation_date from cs_incidents_all_b where incident_id = v_incident_id;
1162: l_validate_lab_time_msg varchar2(255);
1163:
1164:
1165: cursor find_resource is

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

1723: from csi_instance_statuses
1724: where INSTANCE_STATUS_ID = v_partStatusCd;
1725:
1726: cursor c_creation_date(v_incident_id number) is
1727: select creation_date from cs_incidents_all_b where incident_id = v_incident_id;
1728:
1729:
1730:
1731: BEGIN