DBA Data[Home] [Help]

APPS.CCT_SERVERDATAINPUT_PUB dependencies on IEB_WB_SVC_CATS

Line 725: FROM ieb_wb_svc_cats

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

Line 756: ieb_wb_svc_cats cats

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