Line 99: -- select the labor enabled flag value for wms_zones_b table
95: debug('The value of p_zone_id '|| p_zone_id,'ZONE_LABOR_MGMT_ENABLED');
96: END IF;
97:
98: 99: -- select the labor enabled flag value for wms_zones_b table 100: -- into the local variable
101:
102: SELECT labor_enabled
103: INTO l_labor_enabled_flag
Line 104: FROM wms_zones_b
100: -- into the local variable
101:
102: SELECT labor_enabled
103: INTO l_labor_enabled_flag 104: FROM wms_zones_b 105: WHERE organization_id = p_org_id
106: AND zone_id = p_zone_id;
107:
108: