APPS.CUG_WF_EMAIL_UTIL dependencies on CS_INCIDENTS_ALL_B

Line 56: from cs_incidents_all_b ciav,

52: select ciav.incident_id, ciav.incident_type_id , ciav.incident_number,
53: ciav.incident_date, jtv.task_id, jtv.task_type_id
54: into lv_incident_id, lv_incident_type_id, lv_incident_number,
55: lv_incident_date, lv_task_id, lv_task_type_id
56: from cs_incidents_all_b ciav,
57: jtf_tasks_b jtv
58: where ciav.incident_id = jtv.source_object_id
59: and jtv.task_number = lv_task_number
60: and jtv.source_object_type_code ='SR';

Line 276: CS_INCIDENTS_ALL_b cia

272: /***
273: cursor l_Incident_Addr_csr is
274: SELECT hl.address , hl.city, hl.state, hl.province, hl.postal_code, hl.country
275: FROM cs_sr_incident_address_v hl,
276: CS_INCIDENTS_ALL_b cia
277: WHERE hl.location_id = cia.incident_location_id
278: AND cia.incident_number = lv_incident_number;
279: ***/
280: cursor l_Incident_Addr_csr(l_location_id IN NUMBER) is

Line 298: FROM CS_INCIDENTS_ALL_b

294: cursor l_SR_Addr_csr is
295: SELECT incident_location_id, incident_address, incident_city, incident_state,
296: incident_province, incident_postal_code, incident_country,
297: incident_location_type
298: FROM CS_INCIDENTS_ALL_b
299: WHERE incident_number = lv_incident_number;
300: l_SR_Addr_rec l_SR_Addr_csr%rowtype;
301:
302: CURSOR l_hz_party_site_csr(l_party_site_id IN NUMBER) IS

Line 336: CS_INCIDENTS_ALL_b cia

332: hl.state || CHR(10) || hl.province || CHR(10) || hl.postal_code || CHR(10) ||
333: hl.country
334: INTO lv_incident_address
335: FROM HZ_LOCATIONS hl,
336: CS_INCIDENTS_ALL_b cia
337: WHERE hl.location_id = cia.install_site_use_id
338: AND cia.incident_number = lv_incident_number;
339: */
340:

Line 347: CS_INCIDENTS_ALL_b cia

343: /*
344: SELECT hl.address1, hl.address2, hl.city, hl.state, hl.province, hl.postal_code, hl.country
345: INTO l_address1, l_address2, l_city, l_state, l_province, l_postal_code, l_country
346: FROM HZ_LOCATIONS hl,
347: CS_INCIDENTS_ALL_b cia
348: WHERE hl.location_id = cia.install_site_use_id
349: AND cia.incident_number = lv_incident_number;
350:
351: lv_incident_address := l_address1 || '

Line 496: FROM CS_INCIDENTS_ALL_B

492:
493:
494: CURSOR c_get_incident_date IS
495: SELECT incident_date
496: FROM CS_INCIDENTS_ALL_B
497: WHERE INCIDENT_ID = lv_incident_id;
498:
499: CURSOR c_get_sr_attr_value IS
500: SELECT sr_attribute_value

Line 712: from cs_incidents_all_b ciav,

708: -- Make sure by putting specific check that it will execute only for EMAIL NOTIFICATION TASK TYPE
709: -- for a given Service Request
710: select jtv.task_id, jtv.task_type_id, jtv.source_object_type_code
711: into lv_task_id, lv_task_type_id, lv_source_object_type_code
712: from cs_incidents_all_b ciav,
713: jtf_tasks_b jtv
714: where ciav.incident_id = jtv.source_object_id
715: and jtv.task_number = lv_task_number;
716: