APPS.CS_STD dependencies on CS_CP_SERVICES

Line 368: from cs_cp_services CSS

364: return_val VARCHAR2(1) ;
365: begin
366:
367: select 'Y' INTO return_val
368: from cs_cp_services CSS
369: where css.customer_product_id = cp_id
370: and css.warranty_flag='Y' ;
371: return(return_val);
372:

Line 560: FROM cs_cp_services serv

556: ) RETURN VARCHAR2 IS
557: CURSOR serv_cur IS
558: SELECT trunc(nvl(serv.start_date_active, sysdate)) start_date_active,
559: trunc(nvl(serv.end_date_active, sysdate)) end_date_active
560: FROM cs_cp_services serv
561: WHERE serv.customer_product_id = X_CP_ID;
562:
563: X_Sysdate DATE := TRUNC(sysdate);
564: X_Start_Date DATE;