APPS.CSM_SERVICE_HISTORY_EVENT_PKG dependencies on CSM_ITEM_INSTANCES_ACC

Line 663: TYPE l_instance_id_tbl_type IS TABLE OF csm_item_instances_acc.instance_id%TYPE INDEX BY BINARY_INTEGER;

659: PROCEDURE PROCESS_OWNER_HISTORY( p_return_status OUT NOCOPY VARCHAR2,p_error_message OUT NOCOPY VARCHAR2
660: )
661: IS
662:
663: TYPE l_instance_id_tbl_type IS TABLE OF csm_item_instances_acc.instance_id%TYPE INDEX BY BINARY_INTEGER;
664: TYPE l_user_id_tbl_type IS TABLE OF csm_parties_acc.user_id%TYPE INDEX BY BINARY_INTEGER;
665: TYPE l_party_id_tbl_type IS TABLE OF csm_parties_acc.party_id%TYPE INDEX BY BINARY_INTEGER;
666: TYPE l_incident_id_tbl_type IS TABLE OF csm_incidents_all_acc.incident_id%TYPE INDEX BY BINARY_INTEGER;
667:

Line 690: , csm_item_instances_acc ciia

686: , ciia.user_id
687: , ciia.instance_id
688: FROM cs_incidents_all_b ciab
689: , cs_incident_statuses_b cisb
690: , csm_item_instances_acc ciia
691: , jtf_tasks_b jtb
692: WHERE ciab.customer_product_id = ciia.instance_id
693: AND ciab.incident_status_id = cisb.incident_status_id
694: AND cisb.close_flag = 'Y'

Line 720: FROM csm_item_instances_acc ciia

716: , csha.instance_id
717: FROM csm_service_history_acc csha
718: WHERE csha.incident_id=1
719: AND NOT EXISTS ( SELECT 1
720: FROM csm_item_instances_acc ciia
721: WHERE ciia.user_id = csha.user_id
722: AND ciia.instance_id = csha.instance_id
723: );
724: