APPS.CS_UPDATE_WARRANTY_DATES dependencies on CS_CP_SERVICES

Line 13: FROM CS_CP_SERVICES srv, MTL_SYSTEM_ITEMS srv_item

9: CURSOR CP_Service_Cursor IS
10: SELECT srv.service_inventory_item_id item_id,
11: srv_item.service_duration duration_quantity,
12: srv_item.service_duration_period_code duration_uom
13: FROM CS_CP_SERVICES srv, MTL_SYSTEM_ITEMS srv_item
14: WHERE srv.customer_product_id = X_Customer_Product_ID
15: AND srv.warranty_flag = 'Y'
16: AND srv.service_inventory_item_id = srv_item.inventory_item_id (+)
17: FOR UPDATE OF srv.start_date_active,

Line 35: UPDATE CS_CP_SERVICES

31: X_Day_UOM,
32: NULL,
33: NULL);
34:
35: UPDATE CS_CP_SERVICES
36: SET Start_Date_Active = X_Start_Date,
37: End_Date_Active = Round(X_Start_Date + service_duration_days)
38: WHERE CURRENT OF CP_Service_Cursor;
39: END IF;