DBA Data[Home] [Help]

APPS.CUG_GENERIC_WF_PKG dependencies on CS_SR_INCIDENT_ADDRESS_V

Line 57: FROM cs_sr_incident_address_v

53: l_ServiceRequest_rec l_ServiceRequest_csr%ROWTYPE;
54:
55: CURSOR l_IncidentAddress_csr IS
56: SELECT address, city, state, postal_code, country
57: FROM cs_sr_incident_address_v
58: WHERE location_id = l_incident_location_id;
59: l_IncidentAddress_rec l_IncidentAddress_csr%ROWTYPE;
60:
61: -- End of changes by ANEEMUCH date 09-May-2002

Line 595: FROM cs_sr_incident_address_v

591: l_ServiceRequest_rec l_ServiceRequest_csr%ROWTYPE;
592:
593: CURSOR l_IncidentAddress_csr IS
594: SELECT address, city, state, postal_code, country
595: FROM cs_sr_incident_address_v
596: WHERE location_id = l_incident_location_id;
597: l_IncidentAddress_rec l_IncidentAddress_csr%ROWTYPE;
598:
599: CURSOR l_IncidentId_csr IS