APPS.CS_CP_TERMINATION_PKG dependencies on CS_CUSTOMER_PRODUCTS

Line 24: FROM cs_customer_products

20: retcode OUT NUMBER
21: ) IS
22: CURSOR cp_term_cur IS
23: SELECT customer_product_id
24: FROM cs_customer_products
25: WHERE trunc(sysdate) >= trunc(nvl(end_date_active, sysdate+1));
26:
27: --
28: BEGIN

Line 49: UPDATE cs_customer_products

45: fnd_file.put_line(fnd_file.log, 'Updating the status of this product to '||g_default_term_status_id);
46:
47: -- see if we call use the Update APis instead.
48:
49: UPDATE cs_customer_products
50: SET CUSTOMER_PRODUCT_STATUS_ID = g_default_term_status_id,
51: object_version_number = object_version_number + 1
52: WHERE customer_product_id = cp_term_cur_rec.customer_product_id;
53: