APPS.CS_COST_DETAILS_PVT dependencies on CS_INCIDENTS_ALL

Line 195: FROM cs_incidents_all_b

191: ) RETURN VARCHAR2 IS
192:
193: CURSOR c_incident IS
194: SELECT 'Y'
195: FROM cs_incidents_all_b
196: WHERE incident_id = p_incident_id;
197:
198: lv_exists_flag VARCHAR2(1) := 'N';
199: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'is_incident_id_valid';

Line 282: FROM CS_INCIDENTS_ALL_B

278: x_return_status OUT NOCOPY VARCHAR2) IS
279:
280: CURSOR c_val_ch_source(p_source_id IN NUMBER) IS
281: SELECT incident_id
282: FROM CS_INCIDENTS_ALL_B
283: WHERE incident_id =p_source_id;
284:
285: CURSOR c_val_dr_source(p_source_id IN NUMBER) IS
286: SELECT repair_line_id

Line 1051: cs_incidents_all csinall

1047: SELECT nvl(csinst.disallow_new_charge, 'N'),
1048: nvl(csinst.disallow_charge_update, 'N'),
1049: nvl(csinst.disallow_request_update,'N') --new check for costing
1050: FROM cs_incident_statuses csinst,
1051: cs_incidents_all csinall
1052: WHERE csinst.incident_status_id = csinall.incident_status_id
1053: AND csinall.incident_id = p_incident_id;
1054:
1055: BEGIN

Line 1181: FROM cs_incidents_all_b cia

1177: ) IS
1178:
1179: CURSOR c_get_sr_org(p_incident_id IN NUMBER) IS
1180: SELECT inv_organization_id, org_id
1181: FROM cs_incidents_all_b cia
1182: WHERE cia.incident_id = p_incident_id;
1183:
1184: lv_exists_flag VARCHAR2(1) := 'N';
1185: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'GET_SR_ORG_INFO';