APPS.CS_STD dependencies on CS_CP_SERVICES

Line 369: from cs_cp_services CSS

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

Line 561: FROM cs_cp_services serv

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