APPS.CS_WF_ACTIVITIES_PKG dependencies on CS_STD

Line 23: CS_STD.Get_Item_Valdn_Orgzn_Id organization_id,

19: sr.customer_number,
20: sr.inventory_item_id,
21: mtl.concatenated_segments product,
22: mtl.description product_description,
23: CS_STD.Get_Item_Valdn_Orgzn_Id organization_id,
24: sr.reference_number,
25: sr.current_serial_number,
26: cp.installation_date,
27: sr.incident_id,

Line 100: AND mtl.organization_id = CS_STD.Get_Item_Valdn_Orgzn_ID

96: hz_locations hl,
97: jtf_notes_vl jn
98: WHERE it.incident_type_id = sr.incident_type_id
99: AND mtl.inventory_item_id(+) = sr.inventory_item_id
100: AND mtl.organization_id = CS_STD.Get_Item_Valdn_Orgzn_ID
101: AND cp.customer_product_id(+) = sr.customer_product_id
102: AND sr.incident_id = p_incident_id
103: AND act.source_object_id = p_incident_id
104: AND act.task_id = p_incident_action_id

Line 431: AND (MTL.ORGANIZATION_ID = CS_STD.Get_Item_Valdn_Orgzn_ID OR MTL.ORGANIZATION_ID IS NULL);

427: AND INC.PROBLEM_CODE = CSLKUP.LOOKUP_CODE(+)
428: AND CSLKUP.LOOKUP_TYPE(+) = 'REQUEST_PROBLEM_CODE'
429: AND MTL.INVENTORY_ITEM_ID(+) = INC.INVENTORY_ITEM_ID
430: AND MTL.LANGUAGE(+) = userenv('LANG')
431: AND (MTL.ORGANIZATION_ID = CS_STD.Get_Item_Valdn_Orgzn_ID OR MTL.ORGANIZATION_ID IS NULL);
432:
433:
434: l_ServiceRequest_rec l_ServiceRequest_csr%ROWTYPE;
435: