APPS.CSFW_DEBRIEF_PUB dependencies on CS_INCIDENTS_ALL

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 1672: from cs_incidents_all

1668:
1669: Cursor c_site (p_incident_id number) Is
1670: select install_site_use_id,
1671: ship_to_site_use_id
1672: from cs_incidents_all
1673: where incident_id = p_incident_id;
1674: cursor c_party_site_id (p_install_site_id number) Is
1675: select party_site_id
1676: from hz_party_site_uses

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

Line 2634: from cs_incidents_all

2630:
2631: Cursor c_site (p_incident_id number) Is
2632: select install_site_use_id,
2633: ship_to_site_use_id
2634: from cs_incidents_all
2635: where incident_id = p_incident_id;
2636: cursor c_party_site_id (p_install_site_id number) Is
2637: select party_site_id
2638: from hz_party_site_uses