APPS.CSFW_DEBRIEF_PUB dependencies on CS_INCIDENTS_ALL

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

984:
985: Cursor c_site (p_incident_id number) Is
986: select install_site_use_id,
987: ship_to_site_use_id
988: from cs_incidents_all
989: where incident_id = p_incident_id;
990: cursor c_party_site_id (p_install_site_id number) Is
991: select party_site_id
992: from hz_party_site_uses

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

Line 1785: from cs_incidents_all

1781:
1782: Cursor c_site (p_incident_id number) Is
1783: select install_site_use_id,
1784: ship_to_site_use_id
1785: from cs_incidents_all
1786: where incident_id = p_incident_id;
1787: cursor c_party_site_id (p_install_site_id number) Is
1788: select party_site_id
1789: from hz_party_site_uses