APPS.CSL_SERVICE_HISTORY_PKG dependencies on CS_INCIDENTS_ALL_B

Line 402: FROM CS_INCIDENTS_ALL_B

398: -- 11.5.10 Service uptake - 3430663. Get incident_location_id
399: SELECT CUSTOMER_PRODUCT_ID
400: , INCIDENT_LOCATION_ID
401: , CUSTOMER_ID
402: FROM CS_INCIDENTS_ALL_B
403: WHERE INCIDENT_ID = b_incident_id;
404: r_sr_type c_sr_type%ROWTYPE;
405:
406: CURSOR c_task_time( b_incident_id NUMBER

Line 422: FROM CS_INCIDENTS_ALL_B inc

418: CURSOR c_get_cp_history( b_max_date DATE,
419: b_customer_product_id NUMBER ) IS
420: SELECT DISTINCT inc.INCIDENT_ID
421: , inc.CLOSE_DATE
422: FROM CS_INCIDENTS_ALL_B inc
423: , JTF_TASKS_B tk
424: , JTF_TASK_ASSIGNMENTS ta
425: , CS_INCIDENT_STATUSES_B ists
426: , JTF_TASK_TYPES_B tt

Line 457: FROM CS_INCIDENTS_ALL_B inc

453: b_customer_id NUMBER,
454: b_incident_location_id NUMBER ) IS
455: SELECT DISTINCT inc.INCIDENT_ID
456: , inc.CLOSE_DATE
457: FROM CS_INCIDENTS_ALL_B inc
458: , JTF_TASKS_B tk
459: , JTF_TASK_ASSIGNMENTS ta
460: , CS_INCIDENT_STATUSES_B ists
461: , JTF_TASK_TYPES_B tt

Line 703: , CS_INCIDENTS_ALL_B inc

699: CURSOR c_acc_incidents IS
700: SELECT acc.INCIDENT_ID
701: , acc.RESOURCE_ID
702: FROM CSL_CS_INCIDENTS_ALL_ACC acc
703: , CS_INCIDENTS_ALL_B inc
704: , JTF_TASKS_B tsk
705: , JTF_TASK_ASSIGNMENTS ta
706: WHERE tsk.SOURCE_OBJECT_ID = inc.INCIDENT_ID
707: AND tsk.SOURCE_OBJECT_TYPE_CODE = 'SR'