APPS.WMS_POST_ALLOCATION dependencies on WMS_RULES

Line 494: FROM wms_rules rules

490: CURSOR c_opa_rule_exists (p_org_id NUMBER) IS
491: SELECT 'x' FROM dual
492: WHERE EXISTS
493: ( SELECT 'x'
494: FROM wms_rules rules
495: , wms_op_plans_b wop
496: WHERE rules.organization_id IN (p_org_id,-1)
497: AND rules.type_code = 7
498: AND rules.enabled_flag = 'Y'

Line 673: FROM wms_rules rules

669: CURSOR c_tta_rule_exists (p_org_id NUMBER) IS
670: SELECT 'x' FROM dual
671: WHERE EXISTS
672: ( SELECT 'x'
673: FROM wms_rules rules
674: WHERE rules.organization_id IN (p_org_id,-1)
675: AND rules.type_code = 3
676: AND rules.enabled_flag = 'Y'
677: );