DBA Data[Home] [Help]

APPS.CCT_SERVERDATAINPUT_PUB dependencies on IEB_WB_SVC_CATS

Line 727: FROM ieb_wb_svc_cats

723: DECLARE
724: CURSOR wbsc_id_cur (v_los_name IN VARCHAR2)
725: IS
726: SELECT wbsc_id
727: FROM ieb_wb_svc_cats
728: WHERE UPPER (service_category_name) = UPPER (v_los_name)
729: ORDER BY wbsc_id;
730: BEGIN
731: OPEN wbsc_id_cur (p_los_name);

Line 758: ieb_wb_svc_cats cats

754: IS
755: SELECT covs.quota
756: FROM ieb_outb_svc_coverages covs,
757: ieb_service_plans plan,
758: ieb_wb_svc_cats cats
759: WHERE cats.wbsc_id = v_los_id
760: AND cats.svcpln_svcpln_id = plan.svcpln_id
761: AND covs.svcpln_svcpln_id = plan.svcpln_id
762: -- Get weekday match (for regular) or date match (for specific)